log_savedal.cs

CRM管理系统 CRM管理系统

//------------------------------------*/
//版权所有：杭州商易信息技术有限公司
//功能描述：日志记录
//    作者：沈伟
//    日期：2008/08/26
//------------------------------------*/
using System;
using System.Collections.Generic;
using System.Text;
using SystemFrameworks;
using System.Data;

namespace Itsv.DAL.SystemManage
{
   public class Log_SaveDAL
   {
       #region 成员方法
       ///<summary>
       ///是否存在记录
       ///<summary>
       public bool Exists(int ls_id)
       {
           StringBuilder strSql = new StringBuilder();
           strSql.Append("select count(1) from Log_Save where ls_id=" + ls_id + "");
           object obj = DbHelperSQL.GetSingle(strSql.ToString());
           int cmdresult;
           if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
           {
               cmdresult = 0;
           }
           else
           {
               cmdresult = int.Parse(obj.ToString());
           }
           if (cmdresult == 0)
           {
               return false;
           }
           else
           {
               return true;
           }
       }
       ///<summary>
       ///增加一条记录
       ///</summary>
       public void Add(Itsv.Model.Log_Save model)
       {
           StringBuilder strSql = new StringBuilder();
           strSql.Append("insert into Log_Save(");
           strSql.Append("ls_date,ls_title,ls_descrip,ls_type,ls_user_account,ls_user");
           strSql.Append(")");
           strSql.Append(" values (");
           strSql.Append("'" + model.ls_date + "',");
           strSql.Append("'" + model.ls_title + "',");
           strSql.Append("'" + model.ls_descrip + "',");
           strSql.Append("'" + model.ls_type + "',");
           strSql.Append("'" + model.ls_user_account + "',");
           strSql.Append("'" + model.ls_user + "'");
           strSql.Append(")");
           DbHelperSQL.ExecuteSql(strSql.ToString());
       }
       ///<summary>
       ///更新一条数据
       ///<summary>
       public void Update(Itsv.Model.Log_Save model)
       {
           StringBuilder strSql = new StringBuilder();
           strSql.Append("update Log_Save set ");
           strSql.Append("ls_date='" + model.ls_date + "',");
           strSql.Append("ls_title='" + model.ls_title + "',");
           strSql.Append("ls_descrip='" + model.ls_descrip + "',");
           strSql.Append("ls_type='" + model.ls_type + "',");
           strSql.Append("ls_user_account='" + model.ls_user_account + "',");
           strSql.Append("ls_user='" + model.ls_user + "'");
           strSql.Append(" where ls_id=" + model.ls_id + "");
           DbHelperSQL.ExecuteSql(strSql.ToString());
       }
       ///<summary>
       ///删除一条数据
       ///</summary>
       public void Delete(int ls_id)
       {
           StringBuilder strSql = new StringBuilder();
           strSql.Append("delete Log_Save ");
           strSql.Append(" where ls_id=" + ls_id);
           DbHelperSQL.ExecuteSql(strSql.ToString());
       }
       ///<summary>
       ///得到一个对象实体
       ///</summary>
       public Itsv.Model.Log_Save GetModel(int ls_id)
       {
           StringBuilder strSql = new StringBuilder();
           strSql.Append("select * from Log_Save ");
           strSql.Append(" where ls_id=" + ls_id);
           Itsv.Model.Log_Save model = new Itsv.Model.Log_Save();
           DataSet ds = DbHelperSQL.Query(strSql.ToString());
           model.ls_id = ls_id;
           if (ds.Tables[0].Rows.Count > 0)
           {
               if (ds.Tables[0].Rows[0]["ls_date"].ToString() != "")
               {
                   model.ls_date = DateTime.Parse(ds.Tables[0].Rows[0]["ls_date"].ToString());
               }
               model.ls_title = ds.Tables[0].Rows[0]["ls_title"].ToString();
               model.ls_descrip = ds.Tables[0].Rows[0]["ls_descrip"].ToString();
               model.ls_type = ds.Tables[0].Rows[0]["ls_type"].ToString();
               model.ls_user_account = ds.Tables[0].Rows[0]["ls_user_account"].ToString();
               model.ls_user = ds.Tables[0].Rows[0]["ls_user"].ToString();
               return model;
           }
           else
           {
               return null;
           }
       }
       ///<summary>
       ///获得数据列表         
       ///</summary>
       public DataSet GetList(string strWhere)
       {
           StringBuilder strSql = new StringBuilder();
           strSql.Append("select * from Log_Save ");
           if (strWhere.Trim() != "")
           {
               strSql.Append(" where " + strWhere);
           }
           strSql.Append(" order by ls_id ");
           return DbHelperSQL.Query(strSql.ToString());
       }
      #endregion
   }
}