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