public static int ADD(QualityGoalInfo QGI)
{
string str = " insert into Ent_Quality_Goal(PrjCode,ScheduleCode,QualityGoal,Remark,mark,filesType) values (";
object obj2 = str;
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj2, " '", QGI.PrjCode, "','", QGI.ScheduleCode, "','", QGI.QualityGoal, "','", QGI.Remark, "','", QGI.Mark, "','", QGI.FilesType, "')" })));
}
public static int Update(QualityGoalInfo QGI)
{
object obj2 = " update Ent_Quality_Goal set QualityGoal = '" + QGI.QualityGoal + "',";
object obj3 = string.Concat(new object[] { obj2, " PrjCode = '", QGI.PrjCode, "',ScheduleCode = '", QGI.ScheduleCode, "',Remark = '", QGI.Remark, "',mark='", QGI.Mark, "',filesType='", QGI.FilesType, "' " });
return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj3, " where i_id = '", QGI.i_id, "'" })));
}
public static QualityGoalInfo GetSingleQualityGoalInfo(Guid projectCode, string scheduleCode)
{
QualityGoalInfo info = new QualityGoalInfo();
string str2 = getViewName();
using (DataTable table = publicDbOpClass.DataTableQuary("select * from " + str2 + " where PrjCode = '" + projectCode.ToString() + "' and ScheduleCode = '" + scheduleCode + "'"))
{
if (table.Rows.Count == 1)
{
return(GetQualityGoalInfoFromDataRow(table.Rows[0]));
}
}
return(info);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!base.IsPostBack && base.Request.QueryString["Code"] != null && base.Request.QueryString["Code"].ToString() != "")
{
com.jwsoft.pm.entpm.PageHelper.BindDropDownTree(this.DDTClass, 20, true);
this.InfoObj = QualityGoalAction.GetModel(base.Request.QueryString["Code"].ToString());
if (this.InfoObj != null)
{
this.litName.Text = this.InfoObj.ScheduleName;
this.litRemark.Text = this.InfoObj.Remark;
this.litGoal.Text = this.InfoObj.QualityGoal;
int arg_D9_0 = this.InfoObj.Mark;
if (this.InfoObj.Mark.ToString() != "")
{
this.hdnmark.Value = this.InfoObj.Mark.ToString();
if (this.InfoObj.Mark == 2)
{
this.litGD.Text = "否";
}
else
{
this.litGD.Text = "是";
}
}
else
{
this.litGD.Text = "否";
}
int arg_164_0 = this.InfoObj.FilesType;
if (this.InfoObj.FilesType.ToString() != "" && this.InfoObj.FilesType > 0)
{
this.DDTClass.SelectedValue = this.InfoObj.FilesType.ToString();
if (this.DDTClass.SelectedItem.Text != null && this.DDTClass.SelectedItem.Text.ToString() != "")
{
this.litType.Text = this.DDTClass.SelectedItem.Text.ToString();
}
}
}
}
}
public static QualityGoalInfo GetModel(string i_id)
{
QualityGoalInfo info = new QualityGoalInfo();
DataTable singleRow = GetSingleRow(i_id);
if (singleRow.Rows.Count <= 0)
{
return(null);
}
if ((singleRow.Rows[0]["i_id"] != null) && (singleRow.Rows[0]["i_id"].ToString() != ""))
{
info.i_id = int.Parse(singleRow.Rows[0]["i_id"].ToString());
}
if ((singleRow.Rows[0]["PrjCode"] != null) && (singleRow.Rows[0]["PrjCode"].ToString() != ""))
{
info.PrjCode = new Guid(singleRow.Rows[0]["PrjCode"].ToString());
}
if ((singleRow.Rows[0]["TaskName"] != null) && (singleRow.Rows[0]["TaskName"].ToString() != ""))
{
info.ScheduleName = singleRow.Rows[0]["TaskName"].ToString();
}
if ((singleRow.Rows[0]["QualityGoal"] != null) && (singleRow.Rows[0]["QualityGoal"].ToString() != ""))
{
info.QualityGoal = singleRow.Rows[0]["QualityGoal"].ToString();
}
if ((singleRow.Rows[0]["Remark"] != null) && (singleRow.Rows[0]["Remark"].ToString() != ""))
{
info.Remark = singleRow.Rows[0]["Remark"].ToString();
}
if ((singleRow.Rows[0]["mark"] != null) && (singleRow.Rows[0]["mark"].ToString() != ""))
{
info.Mark = int.Parse(singleRow.Rows[0]["mark"].ToString());
}
if ((singleRow.Rows[0]["filesType"] != null) && (singleRow.Rows[0]["filesType"].ToString() != ""))
{
info.FilesType = int.Parse(singleRow.Rows[0]["filesType"].ToString());
}
return(info);
}
