/// <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); }