public int Update(Model.Operation_LogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Operation_Log set ");
strSql.Append("Mobile=@Mobile,OrderCode=@OrderCode,LStatus=@LStatus,Status=@Status,OperationType=@OperationType,Description=@Description,CreateTime=@CreateTime,UpdateTime=@UpdateTime,UserName=@UserName,Remark=@Remark,HideContent=@HideContent ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Mobile", DbTool.FixSqlParameter(model.Mobile))
, new SqlParameter("@OrderCode", DbTool.FixSqlParameter(model.OrderCode))
, new SqlParameter("@LStatus", DbTool.FixSqlParameter(model.LStatus))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@OperationType", DbTool.FixSqlParameter(model.OperationType))
, new SqlParameter("@Description", DbTool.FixSqlParameter(model.Description))
, new SqlParameter("@CreateTime", DbTool.FixSqlParameter(model.CreateTime))
, new SqlParameter("@UpdateTime", DbTool.FixSqlParameter(model.UpdateTime))
, new SqlParameter("@UserName", DbTool.FixSqlParameter(model.UserName))
, new SqlParameter("@Remark", DbTool.FixSqlParameter(model.Remark))
, new SqlParameter("@HideContent", DbTool.FixSqlParameter(model.HideContent))
, new SqlParameter("@Id", model.Id)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters));
}
public int Add(Model.Operation_LogModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Operation_Log]");
strSql.Append("(Mobile,OrderCode,LStatus,Status,OperationType,Description,CreateTime,UpdateTime,UserName,Remark,HideContent)");
strSql.Append(" values (@Mobile,@OrderCode,@LStatus,@Status,@OperationType,@Description,@CreateTime,@UpdateTime,@UserName,@Remark,@HideContent)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@Mobile", DbTool.FixSqlParameter(model.Mobile))
, new SqlParameter("@OrderCode", DbTool.FixSqlParameter(model.OrderCode))
, new SqlParameter("@LStatus", DbTool.FixSqlParameter(model.LStatus))
, new SqlParameter("@Status", DbTool.FixSqlParameter(model.Status))
, new SqlParameter("@OperationType", DbTool.FixSqlParameter(model.OperationType))
, new SqlParameter("@Description", DbTool.FixSqlParameter(model.Description))
, new SqlParameter("@CreateTime", DbTool.FixSqlParameter(model.CreateTime))
, new SqlParameter("@UpdateTime", DbTool.FixSqlParameter(model.UpdateTime))
, new SqlParameter("@UserName", DbTool.FixSqlParameter(model.UserName))
, new SqlParameter("@Remark", DbTool.FixSqlParameter(model.Remark))
, new SqlParameter("@HideContent", DbTool.FixSqlParameter(model.HideContent))
};
return(DbTool.ConvertObject <int>(SqlHelper.ExecuteScalar(conn, CommandType.Text, strSql.ToString(), parameters), 0));
}
protected Model.Operation_LogModel AutoBindDataReader(SqlDataReader dr, params string[] fields)
{
var model = new Model.Operation_LogModel();
if (DbTool.HasFields("Id", fields))
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
}
if (DbTool.HasFields("Mobile", fields))
{
model.Mobile = DbTool.ConvertObject <System.String>(dr["Mobile"]);
}
if (DbTool.HasFields("OrderCode", fields))
{
model.OrderCode = DbTool.ConvertObject <System.String>(dr["OrderCode"]);
}
if (DbTool.HasFields("LStatus", fields))
{
model.LStatus = DbTool.ConvertObject <System.Int32>(dr["LStatus"]);
}
if (DbTool.HasFields("Status", fields))
{
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
}
if (DbTool.HasFields("OperationType", fields))
{
model.OperationType = DbTool.ConvertObject <System.String>(dr["OperationType"]);
}
if (DbTool.HasFields("Description", fields))
{
model.Description = DbTool.ConvertObject <System.String>(dr["Description"]);
}
if (DbTool.HasFields("CreateTime", fields))
{
model.CreateTime = DbTool.ConvertObject <System.DateTime>(dr["CreateTime"]);
}
if (DbTool.HasFields("UpdateTime", fields))
{
model.UpdateTime = DbTool.ConvertObject <System.DateTime>(dr["UpdateTime"]);
}
if (DbTool.HasFields("UserName", fields))
{
model.UserName = DbTool.ConvertObject <System.String>(dr["UserName"]);
}
if (DbTool.HasFields("Remark", fields))
{
model.Remark = DbTool.ConvertObject <System.String>(dr["Remark"]);
}
if (DbTool.HasFields("HideContent", fields))
{
model.HideContent = DbTool.ConvertObject <System.String>(dr["HideContent"]);
}
return(model);
}
protected void BindDataReader(Model.Operation_LogModel model, SqlDataReader dr)
{
model.Id = DbTool.ConvertObject <System.Int32>(dr["Id"]);
model.Mobile = DbTool.ConvertObject <System.String>(dr["Mobile"]);
model.OrderCode = DbTool.ConvertObject <System.String>(dr["OrderCode"]);
model.LStatus = DbTool.ConvertObject <System.Int32>(dr["LStatus"]);
model.Status = DbTool.ConvertObject <System.Int32>(dr["Status"]);
model.OperationType = DbTool.ConvertObject <System.String>(dr["OperationType"]);
model.Description = DbTool.ConvertObject <System.String>(dr["Description"]);
model.CreateTime = DbTool.ConvertObject <System.DateTime>(dr["CreateTime"]);
model.UpdateTime = DbTool.ConvertObject <System.DateTime>(dr["UpdateTime"]);
model.UserName = DbTool.ConvertObject <System.String>(dr["UserName"]);
model.Remark = DbTool.ConvertObject <System.String>(dr["Remark"]);
model.HideContent = DbTool.ConvertObject <System.String>(dr["HideContent"]);
}
public Model.Operation_LogModel GetModel(int Id)
{
string sql = "select top 1 * from Operation_Log where Id =" + Id;
Model.Operation_LogModel model = new Model.Operation_LogModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
if (dr.Read())
{
//var fields = DbTool.GetReaderFieldNames(dr);
//model = AutoBindDataReader(dr, fields);
BindDataReader(model, dr);
}
dr.Close();
return(model);
}
public List <Model.Operation_LogModel> GetModelList()
{
List <Model.Operation_LogModel> result = new List <Model.Operation_LogModel>();
string sql = "select * from Operation_Log where 1=1";
Model.Operation_LogModel model = new Model.Operation_LogModel();
SqlDataReader dr = SqlHelper.ExecuteReader(conn, CommandType.Text, sql.ToString());
//var fields = DbTool.GetReaderFieldNames(dr);
while (dr.Read())
{
//model = AutoBindDataReader(dr, fields);
model = new Model.Operation_LogModel();
BindDataReader(model, dr);
result.Add(model);
}
dr.Close();
return(result);
}