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