/// <summary> /// 得到一个对象实体 /// </summary> public ManageTaskListModel DataRowToModel(DataRow row) { ManageTaskListModel model = new ManageTaskListModel(); if (row != null) { if (row["TaskListID"] != null && row["TaskListID"].ToString() != "") { model.TaskListID = long.Parse(row["TaskListID"].ToString()); } if (row["TaskID"] != null && row["TaskID"].ToString() != "") { model.TaskID = long.Parse(row["TaskID"].ToString()); } if (row["ProductCode"] != null) { model.ProductCode = row["ProductCode"].ToString(); } if (row["StockListID"] != null && row["StockListID"].ToString() != "") { model.StockListID = long.Parse(row["StockListID"].ToString()); } if (row["TaskStartPosition"] != null) { model.TaskStartPosition = row["TaskStartPosition"].ToString(); } if (row["TaskEndPosition"] != null) { model.TaskEndPosition = row["TaskEndPosition"].ToString(); } if (row["TaskCreatePerson"] != null) { model.TaskCreatePerson = row["TaskCreatePerson"].ToString(); } if (row["ProductBatch"] != null) { model.ProductBatch = row["ProductBatch"].ToString(); } if (row["TaskCreateTime"] != null && row["TaskCreateTime"].ToString() != "") { model.TaskCreateTime = DateTime.Parse(row["TaskCreateTime"].ToString()); } if (row["TaskCompleteTime"] != null && row["TaskCompleteTime"].ToString() != "") { model.TaskCompleteTime = DateTime.Parse(row["TaskCompleteTime"].ToString()); } if (row["TaskParameter"] != null) { model.TaskParameter = row["TaskParameter"].ToString(); } if (row["TaskRemark"] != null) { model.TaskRemark = row["TaskRemark"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ManageTaskListModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ManageTaskList set "); strSql.Append("TaskID=@TaskID,"); strSql.Append("ProductCode=@ProductCode,"); strSql.Append("StockListID=@StockListID,"); strSql.Append("TaskStartPosition=@TaskStartPosition,"); strSql.Append("TaskEndPosition=@TaskEndPosition,"); strSql.Append("TaskCreatePerson=@TaskCreatePerson,"); strSql.Append("ProductBatch=@ProductBatch,"); strSql.Append("TaskCreateTime=@TaskCreateTime,"); strSql.Append("TaskCompleteTime=@TaskCompleteTime,"); strSql.Append("TaskParameter=@TaskParameter,"); strSql.Append("TaskRemark=@TaskRemark"); strSql.Append(" where TaskListID=@TaskListID"); SqlParameter[] parameters = { new SqlParameter("@TaskID", SqlDbType.BigInt, 8), new SqlParameter("@ProductCode", SqlDbType.NVarChar, 50), new SqlParameter("@StockListID", SqlDbType.BigInt, 8), new SqlParameter("@TaskStartPosition", SqlDbType.NVarChar, 50), new SqlParameter("@TaskEndPosition", SqlDbType.NVarChar, 50), new SqlParameter("@TaskCreatePerson", SqlDbType.NVarChar, 50), new SqlParameter("@ProductBatch", SqlDbType.NVarChar, 50), new SqlParameter("@TaskCreateTime", SqlDbType.DateTime), new SqlParameter("@TaskCompleteTime", SqlDbType.DateTime), new SqlParameter("@TaskParameter", SqlDbType.NVarChar, 50), new SqlParameter("@TaskRemark", SqlDbType.NVarChar, 100), new SqlParameter("@TaskListID", SqlDbType.BigInt, 8) }; parameters[0].Value = model.TaskID; parameters[1].Value = model.ProductCode; parameters[2].Value = model.StockListID; parameters[3].Value = model.TaskStartPosition; parameters[4].Value = model.TaskEndPosition; parameters[5].Value = model.TaskCreatePerson; parameters[6].Value = model.ProductBatch; parameters[7].Value = model.TaskCreateTime; parameters[8].Value = model.TaskCompleteTime; parameters[9].Value = model.TaskParameter; parameters[10].Value = model.TaskRemark; parameters[11].Value = model.TaskListID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public long Add(ManageTaskListModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ManageTaskList("); strSql.Append("TaskID,ProductCode,StockListID,TaskStartPosition,TaskEndPosition,TaskCreatePerson,ProductBatch,TaskCreateTime,TaskCompleteTime,TaskParameter,TaskRemark)"); strSql.Append(" values ("); strSql.Append("@TaskID,@ProductCode,@StockListID,@TaskStartPosition,@TaskEndPosition,@TaskCreatePerson,@ProductBatch,@TaskCreateTime,@TaskCompleteTime,@TaskParameter,@TaskRemark)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@TaskID", SqlDbType.BigInt, 8), new SqlParameter("@ProductCode", SqlDbType.NVarChar, 50), new SqlParameter("@StockListID", SqlDbType.BigInt, 8), new SqlParameter("@TaskStartPosition", SqlDbType.NVarChar, 50), new SqlParameter("@TaskEndPosition", SqlDbType.NVarChar, 50), new SqlParameter("@TaskCreatePerson", SqlDbType.NVarChar, 50), new SqlParameter("@ProductBatch", SqlDbType.NVarChar, 50), new SqlParameter("@TaskCreateTime", SqlDbType.DateTime), new SqlParameter("@TaskCompleteTime", SqlDbType.DateTime), new SqlParameter("@TaskParameter", SqlDbType.NVarChar, 50), new SqlParameter("@TaskRemark", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.TaskID; parameters[1].Value = model.ProductCode; parameters[2].Value = model.StockListID; parameters[3].Value = model.TaskStartPosition; parameters[4].Value = model.TaskEndPosition; parameters[5].Value = model.TaskCreatePerson; parameters[6].Value = model.ProductBatch; parameters[7].Value = model.TaskCreateTime; parameters[8].Value = model.TaskCompleteTime; parameters[9].Value = model.TaskParameter; parameters[10].Value = model.TaskRemark; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt64(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ManageTaskListModel GetModel(long TaskListID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 TaskListID,TaskID,ProductCode,StockListID,TaskStartPosition,TaskEndPosition,TaskCreatePerson,ProductBatch,TaskCreateTime,TaskCompleteTime,TaskParameter,TaskRemark from ManageTaskList "); strSql.Append(" where TaskListID=@TaskListID"); SqlParameter[] parameters = { new SqlParameter("@TaskListID", SqlDbType.BigInt) }; parameters[0].Value = TaskListID; ManageTaskListModel model = new ManageTaskListModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ManageTaskListModel model) { return(dal.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public long Add(ManageTaskListModel model) { return(dal.Add(model)); }