/// <summary>
/// 增加一条数据
/// </summary>
public void Add(HM.Model.Eq.Tb_EQ_Task model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@TaskId", SqlDbType.VarChar, 36),
new SqlParameter("@CommId", SqlDbType.Int, 4),
new SqlParameter("@PlanId", SqlDbType.VarChar, 36),
new SqlParameter("@TaskNO", SqlDbType.NVarChar, 50),
new SqlParameter("@EqId", SqlDbType.VarChar, 36),
new SqlParameter("@SpaceId", SqlDbType.VarChar, 36),
new SqlParameter("@Content", SqlDbType.NVarChar, 500),
new SqlParameter("@BeginTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@WorkDayBegin", SqlDbType.NVarChar, 50),
new SqlParameter("@RoleCode", SqlDbType.NVarChar, 50),
new SqlParameter("@Statue", SqlDbType.NVarChar, 50),
new SqlParameter("@ClosePerson", SqlDbType.VarChar, 36),
new SqlParameter("@CloseTime", SqlDbType.DateTime),
new SqlParameter("@CloseReason", SqlDbType.NVarChar, 50),
new SqlParameter("@PollingPerson", SqlDbType.VarChar, 36),
new SqlParameter("@PollingDate", SqlDbType.DateTime),
new SqlParameter("@Remark", SqlDbType.NVarChar, 500),
new SqlParameter("@IsDelete", SqlDbType.Int, 4),
new SqlParameter("@AddPId", SqlDbType.VarChar, 36),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@PerfNum", SqlDbType.NVarChar, 50),
new SqlParameter("@WorkTime", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.TaskId;
parameters[1].Value = model.CommId;
parameters[2].Value = model.PlanId;
parameters[3].Value = model.TaskNO;
parameters[4].Value = model.EqId;
parameters[5].Value = model.SpaceId;
parameters[6].Value = model.Content;
parameters[7].Value = model.BeginTime;
parameters[8].Value = model.EndTime;
parameters[9].Value = model.WorkDayBegin;
parameters[10].Value = model.RoleCode;
parameters[11].Value = model.Statue;
parameters[12].Value = model.ClosePerson;
parameters[13].Value = model.CloseTime;
parameters[14].Value = model.CloseReason;
parameters[15].Value = model.PollingPerson;
parameters[16].Value = model.PollingDate;
parameters[17].Value = model.Remark;
parameters[18].Value = model.IsDelete;
parameters[19].Value = model.AddPId;
parameters[20].Value = model.AddDate;
parameters[21].Value = model.PerfNum;
parameters[22].Value = model.WorkTime;
DbHelperSQL.RunProcedure("Proc_Tb_EQ_Task_ADD", parameters, out rowsAffected);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HM.Model.Eq.Tb_EQ_Task GetModel(string TaskId)
{
SqlParameter[] parameters =
{
new SqlParameter("@TaskId", SqlDbType.VarChar, 50)
};
parameters[0].Value = TaskId;
HM.Model.Eq.Tb_EQ_Task model = new HM.Model.Eq.Tb_EQ_Task();
DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_EQ_Task_GetModel", parameters, "ds");
if (ds.Tables[0].Rows.Count > 0)
{
model.TaskId = ds.Tables[0].Rows[0]["TaskId"].ToString();
if (ds.Tables[0].Rows[0]["CommId"].ToString() != "")
{
model.CommId = int.Parse(ds.Tables[0].Rows[0]["CommId"].ToString());
}
model.PlanId = ds.Tables[0].Rows[0]["PlanId"].ToString();
model.TaskNO = ds.Tables[0].Rows[0]["TaskNO"].ToString();
model.EqId = ds.Tables[0].Rows[0]["EqId"].ToString();
model.SpaceId = ds.Tables[0].Rows[0]["SpaceId"].ToString();
model.Content = ds.Tables[0].Rows[0]["Content"].ToString();
if (ds.Tables[0].Rows[0]["BeginTime"].ToString() != "")
{
model.BeginTime = DateTime.Parse(ds.Tables[0].Rows[0]["BeginTime"].ToString());
}
if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "")
{
model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString());
}
model.WorkDayBegin = ds.Tables[0].Rows[0]["WorkDayBegin"].ToString();
model.RoleCode = ds.Tables[0].Rows[0]["RoleCode"].ToString();
model.Statue = ds.Tables[0].Rows[0]["Statue"].ToString();
model.ClosePerson = ds.Tables[0].Rows[0]["ClosePerson"].ToString();
if (ds.Tables[0].Rows[0]["CloseTime"].ToString() != "")
{
model.CloseTime = DateTime.Parse(ds.Tables[0].Rows[0]["CloseTime"].ToString());
}
model.CloseReason = ds.Tables[0].Rows[0]["CloseReason"].ToString();
model.PollingPerson = ds.Tables[0].Rows[0]["PollingPerson"].ToString();
if (ds.Tables[0].Rows[0]["PollingDate"].ToString() != "")
{
model.PollingDate = DateTime.Parse(ds.Tables[0].Rows[0]["PollingDate"].ToString());
}
model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString();
if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "")
{
model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].ToString());
}
model.AddPId = ds.Tables[0].Rows[0]["AddPId"].ToString();
if (ds.Tables[0].Rows[0]["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(ds.Tables[0].Rows[0]["AddDate"].ToString());
}
model.PerfNum = ds.Tables[0].Rows[0]["PerfNum"].ToString();
model.WorkTime = ds.Tables[0].Rows[0]["WorkTime"].ToString();
return(model);
}
else
{
return(null);
}
}
