/// <summary>
/// 修改实体
/// </summary>
public int EditModel(SC_OrderDetailedArrange model)
{
StringBuilder sql = new StringBuilder();
IList <DbParameter> parameters = new List <DbParameter>();
sql.AppendFormat("UPDATE [SC_OrderDetailedArrange] SET ");
sql.AppendFormat("[OrderDetailedArrangeID] = @OrderDetailedArrangeID ");
sql.AppendFormat(",[OrderDetailedID] = @OrderDetailedID ");
sql.AppendFormat(",[ProduceTaskID] = @ProduceTaskID ");
sql.AppendFormat(",[CreateDate] = @CreateDate ");
sql.AppendFormat(",[CreateUserID] = @CreateUserID ");
sql.AppendFormat(",[DeleteDate] = @DeleteDate ");
sql.AppendFormat(",[DeleteReason] = @DeleteReason ");
sql.AppendFormat(",[DeleteUserID] = @DeleteUserID ");
sql.AppendFormat("WHERE [OrderDetailedArrangeID] = @OrderDetailedArrangeID ");
parameters.Add(_commonDbConneciton.CreateSqlParameter("@OrderDetailedArrangeID", SqlDbType.Int, model.OrderDetailedArrangeID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@OrderDetailedID", SqlDbType.Int, model.OrderDetailedID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@ProduceTaskID", SqlDbType.Int, model.ProduceTaskID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@CreateDate", SqlDbType.DateTime, model.CreateDate));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@CreateUserID", SqlDbType.NVarChar, model.CreateUserID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@DeleteDate", SqlDbType.DateTime, model.DeleteDate));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@DeleteReason", SqlDbType.NVarChar, model.DeleteReason));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@DeleteUserID", SqlDbType.NVarChar, model.DeleteUserID));
return(ExecuteNonQuery(sql.ToString(), parameters));
}
/// <summary>
/// 添加实体
/// </summary>
public int AddModel(SC_OrderDetailedArrange model)
{
string sql = string.Empty;
sql = @"SET identity_insert OrderList ON;INSERT INTO [SC_OrderDetailedArrange](
[OrderDetailedArrangeID]
,[OrderDetailedID]
,[ProduceTaskID]
,[CreateDate]
,[CreateUserID]
,[DeleteDate]
,[DeleteReason]
,[DeleteUserID]
)VALUES(
@OrderDetailedArrangeID
,@OrderDetailedID
,@ProduceTaskID
,@CreateDate
,@CreateUserID
,@DeleteDate
,@DeleteReason
,@DeleteUserID
)";
IList <DbParameter> parameters = new List <DbParameter>();
parameters.Add(_commonDbConneciton.CreateSqlParameter("@OrderDetailedArrangeID", SqlDbType.Int, model.OrderDetailedArrangeID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@OrderDetailedID", SqlDbType.Int, model.OrderDetailedID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@ProduceTaskID", SqlDbType.Int, model.ProduceTaskID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@CreateDate", SqlDbType.DateTime, model.CreateDate));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@CreateUserID", SqlDbType.NVarChar, model.CreateUserID));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@DeleteDate", SqlDbType.DateTime, model.DeleteDate));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@DeleteReason", SqlDbType.NVarChar, model.DeleteReason));
parameters.Add(_commonDbConneciton.CreateSqlParameter("@DeleteUserID", SqlDbType.NVarChar, model.DeleteUserID));
return(ExecuteNonQuery(sql, parameters));
}
/// <summary>
/// 修改
/// </summary>
public int EditModel(SC_OrderDetailedArrange model)
{
try
{
return(_sC_OrderDetailedArrangeDao.EditModel(model));
}
catch
{
return(-1);
}
}
/// <summary>
/// 查询实体
/// </summary>
private SC_OrderDetailedArrange GetModel(string sql, IList <DbParameter> parameters)
{
SqlDataReader reader = (SqlDataReader)_commonDbConneciton.ExecuteReader(sql, parameters);
SC_OrderDetailedArrange model = new SC_OrderDetailedArrange();
while (reader.Read())
{
model = new SC_OrderDetailedArrange();
model = GetEntity(reader);
}
reader.Close();
return(model);
}
private void btnInsert_Click(object sender, EventArgs e)
{
SC_OrderDetailedArrangeBll bll = new SC_OrderDetailedArrangeBll();
SC_OrderDetailedArrange model = new SC_OrderDetailedArrange();
model.CreateDate = DateTime.Now;
model.CreateUserID = "";
model.DeleteDate = DateTime.Now;
model.DeleteReason = "";
model.DeleteUserID = "";
model.OrderDetailedID = 1;
model.ProduceTaskID = 1;
bll.AddModel(model);
}
/// <summary>
/// 查询实体
/// </summary>
private List <SC_OrderDetailedArrange> GetList(string sql, IList <DbParameter> parameters)
{
List <SC_OrderDetailedArrange> ls = new List <SC_OrderDetailedArrange>();
SqlDataReader reader = (SqlDataReader)_commonDbConneciton.ExecuteReader(sql, parameters);
SC_OrderDetailedArrange model;
while (reader.Read())
{
model = new SC_OrderDetailedArrange();
model = GetEntity(reader);
ls.Add(model);
}
reader.Close();
return(ls);
}
