public bool Update(Model_SystemLogError model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update SystemLogError set ");
builder.Append("SystemLog_ID=@SystemLog_ID,");
builder.Append("SystemLog_PagePath=@SystemLog_PagePath,");
builder.Append("SystemLog_SysPath=@SystemLog_SysPath,");
builder.Append("SystemLog_Desc=@SystemLog_Desc,");
builder.Append("SystemLog_LoginID=@SystemLog_LoginID,");
builder.Append("SystemLog_CreateDate=@SystemLog_CreateDate,");
builder.Append("SystemLog_IP=@SystemLog_IP,");
builder.Append("SystemLog_Source=@SystemLog_Source");
builder.Append(" where ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SystemLog_ID", SqlDbType.Char, 0x24), new SqlParameter("@SystemLog_PagePath", SqlDbType.NVarChar, 500), new SqlParameter("@SystemLog_SysPath", SqlDbType.NVarChar, 500), new SqlParameter("@SystemLog_Desc", SqlDbType.NVarChar, -1), new SqlParameter("@SystemLog_LoginID", SqlDbType.Char, 0x24), new SqlParameter("@SystemLog_CreateDate", SqlDbType.DateTime), new SqlParameter("@SystemLog_IP", SqlDbType.VarChar, 50), new SqlParameter("@SystemLog_Source", SqlDbType.Int, 4) };
cmdParms[0].Value = model.SystemLog_ID;
cmdParms[1].Value = model.SystemLog_PagePath;
cmdParms[2].Value = model.SystemLog_SysPath;
cmdParms[3].Value = model.SystemLog_Desc;
cmdParms[4].Value = model.SystemLog_LoginID;
cmdParms[5].Value = model.SystemLog_CreateDate;
cmdParms[6].Value = model.SystemLog_IP;
cmdParms[7].Value = model.SystemLog_Source;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
internal int Update(DbTransaction tran, Model_SystemLogError model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" UPDATE ");
builder.Append(" SystemLogError ");
builder.Append(" SET ");
builder.Append(" SystemLog_ID=@SystemLog_ID,SystemLog_PagePath=@SystemLog_PagePath,SystemLog_SysPath=@SystemLog_SysPath,SystemLog_Desc=@SystemLog_Desc,SystemLog_LoginID=@SystemLog_LoginID,SystemLog_CreateDate=@SystemLog_CreateDate,SystemLog_IP=@SystemLog_IP,SystemLog_Source=@SystemLog_Source ");
builder.Append(" WHERE ");
builder.Append(" SystemLog_ID=@SystemLog_ID ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.SystemLog_ID, model.SystemLog_PagePath, model.SystemLog_SysPath, model.SystemLog_Desc, model.SystemLog_LoginID, model.SystemLog_CreateDate, model.SystemLog_IP, model.SystemLog_Source }));
}
internal int Add(DbTransaction tran, Model_SystemLogError model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" INSERT INTO ");
builder.Append(" SystemLogError( ");
builder.Append(" SystemLog_ID,SystemLog_PagePath,SystemLog_SysPath,SystemLog_Desc,SystemLog_LoginID,SystemLog_CreateDate,SystemLog_IP,SystemLog_Source ");
builder.Append(" ) ");
builder.Append(" values( ");
builder.Append(" @SystemLog_ID,@SystemLog_PagePath,@SystemLog_SysPath,@SystemLog_Desc,@SystemLog_LoginID,@SystemLog_CreateDate,@SystemLog_IP,@SystemLog_Source ");
builder.Append(" ) ");
return(this.CurrDB.ExecuteNonQuery(builder.ToString(), tran, new object[] { model.SystemLog_ID, model.SystemLog_PagePath, model.SystemLog_SysPath, model.SystemLog_Desc, model.SystemLog_LoginID, model.SystemLog_CreateDate, model.SystemLog_IP, model.SystemLog_Source }));
}
public Model_SystemLogError DataRowToModel(DataRow row)
{
Model_SystemLogError error = new Model_SystemLogError();
if (row != null)
{
if (row["SystemLog_ID"] != null)
{
error.SystemLog_ID = row["SystemLog_ID"].ToString();
}
if (row["SystemLog_PagePath"] != null)
{
error.SystemLog_PagePath = row["SystemLog_PagePath"].ToString();
}
if (row["SystemLog_SysPath"] != null)
{
error.SystemLog_SysPath = row["SystemLog_SysPath"].ToString();
}
if (row["SystemLog_Desc"] != null)
{
error.SystemLog_Desc = row["SystemLog_Desc"].ToString();
}
if (row["SystemLog_LoginID"] != null)
{
error.SystemLog_LoginID = row["SystemLog_LoginID"].ToString();
}
if (row["SystemLog_CreateDate"] != null)
{
error.SystemLog_CreateDate = new DateTime?(DateTime.Parse(row["SystemLog_CreateDate"].ToString()));
}
if (row["SystemLog_IP"] != null)
{
error.SystemLog_IP = row["SystemLog_IP"].ToString();
}
if (row["SystemLog_Source"] != null)
{
error.SystemLog_Source = new int?(int.Parse(row["SystemLog_Source"].ToString()));
}
if (row["DoctorInfo_Name"] != null)
{
error.DoctorName = row["DoctorInfo_Name"].ToString();
}
}
return(error);
}
public List <Model_SystemLogError> DataTableToList(DataTable dt)
{
List <Model_SystemLogError> list = new List <Model_SystemLogError>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_SystemLogError item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public bool Add(Model_SystemLogError model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into SystemLogError(");
builder.Append("SystemLog_ID,SystemLog_PagePath,SystemLog_SysPath,SystemLog_Desc,SystemLog_LoginID,SystemLog_CreateDate,SystemLog_IP,SystemLog_Source)");
builder.Append(" values (");
builder.Append("@SystemLog_ID,@SystemLog_PagePath,@SystemLog_SysPath,@SystemLog_Desc,@SystemLog_LoginID,@SystemLog_CreateDate,@SystemLog_IP,@SystemLog_Source)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@SystemLog_ID", SqlDbType.Char, 0x24), new SqlParameter("@SystemLog_PagePath", SqlDbType.NVarChar, 500), new SqlParameter("@SystemLog_SysPath", SqlDbType.NVarChar, 500), new SqlParameter("@SystemLog_Desc", SqlDbType.NVarChar, -1), new SqlParameter("@SystemLog_LoginID", SqlDbType.Char, 0x24), new SqlParameter("@SystemLog_CreateDate", SqlDbType.DateTime), new SqlParameter("@SystemLog_IP", SqlDbType.VarChar, 50), new SqlParameter("@SystemLog_Source", SqlDbType.Int, 4) };
cmdParms[0].Value = model.SystemLog_ID;
cmdParms[1].Value = model.SystemLog_PagePath;
cmdParms[2].Value = model.SystemLog_SysPath;
cmdParms[3].Value = model.SystemLog_Desc;
cmdParms[4].Value = model.SystemLog_LoginID;
cmdParms[5].Value = model.SystemLog_CreateDate;
cmdParms[6].Value = model.SystemLog_IP;
cmdParms[7].Value = model.SystemLog_Source;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Add(Model_SystemLogError model)
{
return(this.dal.Add(model));
}
public bool Update(Model_SystemLogError model)
{
return(this.dal.Update(model));
}
public int Update(Model_SystemLogError model)
{
return(this.Update(null, model));
}
internal List <Model_SystemLogError> GetModel_SystemLogErrorListByPage(DbTransaction tran, int pageSize, int pageIndex, string orderColumn, string orderType, string strCondition, params object[] param)
{
if ((pageSize <= 0) || (pageIndex <= 0))
{
throw new Exception("分页参数错误，必须大于零");
}
if (string.IsNullOrEmpty(orderColumn))
{
throw new Exception("排序字段必须填写");
}
int num = ((pageIndex - 1) * pageSize) + 1;
int num2 = pageIndex * pageSize;
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT * FROM (");
builder.Append(string.Format(" SELECT (ROW_NUMBER() OVER(ORDER BY {0} {1})) as rownum,* FROM SystemLogError", orderColumn, orderType));
if (!string.IsNullOrWhiteSpace(strCondition))
{
builder.Append(" WHERE ");
builder.Append(strCondition);
}
builder.Append(" ) t ");
builder.Append(" WHERE rownum between ");
builder.Append(string.Format(" {0} ", num));
builder.Append(" AND ");
builder.Append(string.Format(" {0} ", num2));
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param);
List <Model_SystemLogError> list = new List <Model_SystemLogError>();
Model_SystemLogError item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Model_SystemLogError();
if (row["SystemLog_ID"] != null)
{
item.SystemLog_ID = row["SystemLog_ID"].ToString();
}
if (row["SystemLog_PagePath"] != null)
{
item.SystemLog_PagePath = row["SystemLog_PagePath"].ToString();
}
if (row["SystemLog_SysPath"] != null)
{
item.SystemLog_SysPath = row["SystemLog_SysPath"].ToString();
}
if (row["SystemLog_Desc"] != null)
{
item.SystemLog_Desc = row["SystemLog_Desc"].ToString();
}
if (row["SystemLog_LoginID"] != null)
{
item.SystemLog_LoginID = row["SystemLog_LoginID"].ToString();
}
if (row["SystemLog_CreateDate"] != null)
{
if (string.IsNullOrWhiteSpace(row["SystemLog_CreateDate"].ToString()))
{
item.SystemLog_CreateDate = null;
}
else
{
item.SystemLog_CreateDate = new DateTime?(DateTime.Parse(row["SystemLog_CreateDate"].ToString()));
}
}
if (row["SystemLog_IP"] != null)
{
item.SystemLog_IP = row["SystemLog_IP"].ToString();
}
if (row["SystemLog_Source"] != null)
{
if (string.IsNullOrWhiteSpace(row["SystemLog_Source"].ToString()))
{
item.SystemLog_Source = null;
}
else
{
item.SystemLog_Source = new int?(int.Parse(row["SystemLog_Source"].ToString()));
}
}
list.Add(item);
}
return(list);
}
internal List <Model_SystemLogError> GetModel_SystemLogErrorList(DbTransaction tran, int recordNum, string orderColumn, string orderType, string strCondition, params object[] param)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
if (recordNum > 0)
{
builder.Append(" TOP " + recordNum);
}
builder.Append(" * ");
builder.Append(" FROM ");
builder.Append(" SystemLogError ");
if (!string.IsNullOrEmpty(strCondition))
{
builder.Append(" WHERE ");
builder.Append(strCondition);
}
if (!string.IsNullOrEmpty(orderColumn))
{
builder.Append(" ORDER BY ");
builder.Append(orderColumn);
if (!string.IsNullOrEmpty(orderType))
{
builder.Append(" " + orderType);
}
}
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, param);
List <Model_SystemLogError> list = new List <Model_SystemLogError>();
Model_SystemLogError item = null;
foreach (DataRow row in set.Tables[0].Rows)
{
item = new Model_SystemLogError();
if (row["SystemLog_ID"] != null)
{
item.SystemLog_ID = row["SystemLog_ID"].ToString();
}
if (row["SystemLog_PagePath"] != null)
{
item.SystemLog_PagePath = row["SystemLog_PagePath"].ToString();
}
if (row["SystemLog_SysPath"] != null)
{
item.SystemLog_SysPath = row["SystemLog_SysPath"].ToString();
}
if (row["SystemLog_Desc"] != null)
{
item.SystemLog_Desc = row["SystemLog_Desc"].ToString();
}
if (row["SystemLog_LoginID"] != null)
{
item.SystemLog_LoginID = row["SystemLog_LoginID"].ToString();
}
if (row["SystemLog_CreateDate"] != null)
{
if (string.IsNullOrWhiteSpace(row["SystemLog_CreateDate"].ToString()))
{
item.SystemLog_CreateDate = null;
}
else
{
item.SystemLog_CreateDate = new DateTime?(DateTime.Parse(row["SystemLog_CreateDate"].ToString()));
}
}
if (row["SystemLog_IP"] != null)
{
item.SystemLog_IP = row["SystemLog_IP"].ToString();
}
if (row["SystemLog_Source"] != null)
{
if (string.IsNullOrWhiteSpace(row["SystemLog_Source"].ToString()))
{
item.SystemLog_Source = null;
}
else
{
item.SystemLog_Source = new int?(int.Parse(row["SystemLog_Source"].ToString()));
}
}
list.Add(item);
}
return(list);
}
public int Add(Model_SystemLogError model)
{
return(this.Add(null, model));
}
internal Model_SystemLogError GetModel_SystemLogErrorByPK(DbTransaction tran, string systemlog_id)
{
StringBuilder builder = new StringBuilder();
builder.Append(" SELECT ");
builder.Append(" TOP 1 * ");
builder.Append(" FROM ");
builder.Append(" SystemLogError ");
builder.Append(" WHERE ");
builder.Append(" SystemLog_ID=@SystemLog_ID ");
DataSet set = this.CurrDB.ExecuteDataSet(builder.ToString(), tran, new object[] { systemlog_id });
Model_SystemLogError error = null;
if (set.Tables[0].Rows.Count > 0)
{
DataRow row = set.Tables[0].Rows[0];
error = new Model_SystemLogError();
if (row["SystemLog_ID"] != null)
{
error.SystemLog_ID = row["SystemLog_ID"].ToString();
}
if (row["SystemLog_PagePath"] != null)
{
error.SystemLog_PagePath = row["SystemLog_PagePath"].ToString();
}
if (row["SystemLog_SysPath"] != null)
{
error.SystemLog_SysPath = row["SystemLog_SysPath"].ToString();
}
if (row["SystemLog_Desc"] != null)
{
error.SystemLog_Desc = row["SystemLog_Desc"].ToString();
}
if (row["SystemLog_LoginID"] != null)
{
error.SystemLog_LoginID = row["SystemLog_LoginID"].ToString();
}
if (row["SystemLog_CreateDate"] != null)
{
if (string.IsNullOrWhiteSpace(row["SystemLog_CreateDate"].ToString()))
{
error.SystemLog_CreateDate = null;
}
else
{
error.SystemLog_CreateDate = new DateTime?(DateTime.Parse(row["SystemLog_CreateDate"].ToString()));
}
}
if (row["SystemLog_IP"] != null)
{
error.SystemLog_IP = row["SystemLog_IP"].ToString();
}
if (row["SystemLog_Source"] == null)
{
return(error);
}
if (string.IsNullOrWhiteSpace(row["SystemLog_Source"].ToString()))
{
error.SystemLog_Source = null;
return(error);
}
error.SystemLog_Source = new int?(int.Parse(row["SystemLog_Source"].ToString()));
}
return(error);
}
public int Update(Model_SystemLogError model)
{
return(this.DAL.Update(model));
}
public int Add(Model_SystemLogError model)
{
return(this.DAL.Add(model));
}
