/// <summary>
/// 更新一条数据
/// </summary>
public void Update(TSM.Model.pms_OutAssistance_WorkPlan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update pms_OutAssistance_WorkPlan set ");
strSql.Append("PlanMonth=@PlanMonth,");
strSql.Append("WorkTypeID=@WorkTypeID,");
strSql.Append("WorkContentID=@WorkContentID,");
strSql.Append("WorkPlan=@WorkPlan,");
strSql.Append("PlanTime=@PlanTime,");
strSql.Append("PlannerID=@PlannerID,");
strSql.Append("Report=@Report,");
strSql.Append("ReportTime=@ReportTime,");
strSql.Append("ReporterID=@ReporterID,");
strSql.Append("Completion=@Completion,");
strSql.Append("Result=@Result,");
strSql.Append("WorkHour=@WorkHour");
strSql.Append(" where WorkPlanID=@WorkPlanID ");
SqlParameter[] parameters =
{
new SqlParameter("@WorkPlanID", SqlDbType.Int, 4),
new SqlParameter("@PlanMonth", SqlDbType.VarChar, 7),
new SqlParameter("@WorkTypeID", SqlDbType.Int, 4),
new SqlParameter("@WorkContentID", SqlDbType.Int, 4),
new SqlParameter("@WorkPlan", SqlDbType.VarChar, 300),
new SqlParameter("@PlanTime", SqlDbType.DateTime),
new SqlParameter("@PlannerID", SqlDbType.Int, 4),
new SqlParameter("@Report", SqlDbType.VarChar, 300),
new SqlParameter("@ReportTime", SqlDbType.DateTime),
new SqlParameter("@ReporterID", SqlDbType.Int, 4),
new SqlParameter("@Completion", SqlDbType.VarChar, 64),
new SqlParameter("@Result", SqlDbType.VarChar, 64),
new SqlParameter("@WorkHour", SqlDbType.Int, 4)
};
parameters[0].Value = model.WorkPlanID;
parameters[1].Value = model.PlanMonth;
parameters[2].Value = model.WorkTypeID;
parameters[3].Value = model.WorkContentID;
parameters[4].Value = model.WorkPlan;
parameters[5].Value = model.PlanTime;
parameters[6].Value = model.PlannerID;
parameters[7].Value = model.Report;
parameters[8].Value = model.ReportTime;
parameters[9].Value = model.ReporterID;
parameters[10].Value = model.Completion;
parameters[11].Value = model.Result;
parameters[12].Value = model.WorkHour;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(TSM.Model.pms_OutAssistance_WorkPlan model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into pms_OutAssistance_WorkPlan(");
strSql.Append("PlanMonth,WorkTypeID,WorkContentID,WorkPlan,PlanTime,PlannerID,Report,ReportTime,ReporterID,Completion,Result,WorkHour)");
strSql.Append(" values (");
strSql.Append("@PlanMonth,@WorkTypeID,@WorkContentID,@WorkPlan,@PlanTime,@PlannerID,@Report,@ReportTime,@ReporterID,@Completion,@Result,@WorkHour)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@PlanMonth", SqlDbType.VarChar, 7),
new SqlParameter("@WorkTypeID", SqlDbType.Int, 4),
new SqlParameter("@WorkContentID", SqlDbType.Int, 4),
new SqlParameter("@WorkPlan", SqlDbType.VarChar, 300),
new SqlParameter("@PlanTime", SqlDbType.DateTime),
new SqlParameter("@PlannerID", SqlDbType.Int, 4),
new SqlParameter("@Report", SqlDbType.VarChar, 300),
new SqlParameter("@ReportTime", SqlDbType.DateTime),
new SqlParameter("@ReporterID", SqlDbType.Int, 4),
new SqlParameter("@Completion", SqlDbType.VarChar, 64),
new SqlParameter("@Result", SqlDbType.VarChar, 64),
new SqlParameter("@WorkHour", SqlDbType.Int, 4)
};
parameters[0].Value = model.PlanMonth;
parameters[1].Value = model.WorkTypeID;
parameters[2].Value = model.WorkContentID;
parameters[3].Value = model.WorkPlan;
parameters[4].Value = model.PlanTime;
parameters[5].Value = model.PlannerID;
parameters[6].Value = model.Report;
parameters[7].Value = model.ReportTime;
parameters[8].Value = model.ReporterID;
parameters[9].Value = model.Completion;
parameters[10].Value = model.Result;
parameters[11].Value = model.WorkHour;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void SaveWorkPlan()
{
var cookie = HttpContext.Current.Request.Cookies[FormsAuthentication.FormsCookieName];
var ticket = FormsAuthentication.Decrypt(cookie.Value);
string uid = ticket.UserData;
TSM.Model.pms_OutAssistance_WorkPlan modelpms_OutAssistance_WorkPlan = new TSM.Model.pms_OutAssistance_WorkPlan();
modelpms_OutAssistance_WorkPlan.PlanMonth = da1.Text.ToString();
modelpms_OutAssistance_WorkPlan.WorkTypeID = int.Parse(ddlType.SelectedValue);
modelpms_OutAssistance_WorkPlan.WorkContentID = int.Parse(ddlCont.SelectedValue);
modelpms_OutAssistance_WorkPlan.WorkPlan = txaPlan.Text.ToString();
modelpms_OutAssistance_WorkPlan.PlanTime = DateTime.Now.Date;
modelpms_OutAssistance_WorkPlan.PlannerID = int.Parse(uid);
modelpms_OutAssistance_WorkPlan.Report = "";
modelpms_OutAssistance_WorkPlan.ReportTime = Convert.ToDateTime("2000-01-01");
modelpms_OutAssistance_WorkPlan.ReporterID = int.Parse(ddlRept.SelectedValue);
modelpms_OutAssistance_WorkPlan.Completion = "";
modelpms_OutAssistance_WorkPlan.Result = "";
modelpms_OutAssistance_WorkPlan.WorkHour = 0;
m_bllpms_OutAssistance_WorkPlan.Add(modelpms_OutAssistance_WorkPlan);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public TSM.Model.pms_OutAssistance_WorkPlan GetModel(int WorkPlanID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 WorkPlanID,PlanMonth,WorkTypeID,WorkContentID,WorkPlan,PlanTime,PlannerID,Report,ReportTime,ReporterID,Completion,Result,WorkHour from pms_OutAssistance_WorkPlan ");
strSql.Append(" where WorkPlanID=@WorkPlanID ");
SqlParameter[] parameters =
{
new SqlParameter("@WorkPlanID", SqlDbType.Int, 4)
};
parameters[0].Value = WorkPlanID;
TSM.Model.pms_OutAssistance_WorkPlan model = new TSM.Model.pms_OutAssistance_WorkPlan();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["WorkPlanID"].ToString() != "")
{
model.WorkPlanID = int.Parse(ds.Tables[0].Rows[0]["WorkPlanID"].ToString());
}
model.PlanMonth = ds.Tables[0].Rows[0]["PlanMonth"].ToString();
if (ds.Tables[0].Rows[0]["WorkTypeID"].ToString() != "")
{
model.WorkTypeID = int.Parse(ds.Tables[0].Rows[0]["WorkTypeID"].ToString());
}
if (ds.Tables[0].Rows[0]["WorkContentID"].ToString() != "")
{
model.WorkContentID = int.Parse(ds.Tables[0].Rows[0]["WorkContentID"].ToString());
}
model.WorkPlan = ds.Tables[0].Rows[0]["WorkPlan"].ToString();
if (ds.Tables[0].Rows[0]["PlanTime"].ToString() != "")
{
model.PlanTime = DateTime.Parse(ds.Tables[0].Rows[0]["PlanTime"].ToString());
}
if (ds.Tables[0].Rows[0]["PlannerID"].ToString() != "")
{
model.PlannerID = int.Parse(ds.Tables[0].Rows[0]["PlannerID"].ToString());
}
model.Report = ds.Tables[0].Rows[0]["Report"].ToString();
if (ds.Tables[0].Rows[0]["ReportTime"].ToString() != "")
{
model.ReportTime = DateTime.Parse(ds.Tables[0].Rows[0]["ReportTime"].ToString());
}
if (ds.Tables[0].Rows[0]["ReporterID"].ToString() != "")
{
model.ReporterID = int.Parse(ds.Tables[0].Rows[0]["ReporterID"].ToString());
}
model.Completion = ds.Tables[0].Rows[0]["Completion"].ToString();
model.Result = ds.Tables[0].Rows[0]["Result"].ToString();
if (ds.Tables[0].Rows[0]["WorkHour"].ToString() != "")
{
model.WorkHour = int.Parse(ds.Tables[0].Rows[0]["WorkHour"].ToString());
}
return(model);
}
else
{
return(null);
}
}