protected void BtnSave_Click(object sender, EventArgs e) { TechnologyStandardInfo standardInfo = this.GetStandardInfo(); int mark = 2; if (this.cbkmark.Checked) { mark = 3; } if (this._Type == "Add") { TechnologyStandardAction.TechnologyAdd(standardInfo); int num = this.coBll.UpdGuidang("Prj_TechnologyCriterion", mark, Convert.ToInt32(this.DDTClass.SelectedValue.Trim()), " where MainId=" + standardInfo.MainId); if (num == 1) { base.RegisterScript("top.ui.tabSuccess({ parentName: '_technologystandardquery' });"); this.BtnSave.Enabled = false; return; } base.RegisterScript("top.ui.alert('保存失败!'); "); return; } else { TechnologyStandardAction.TechnologyUpd(standardInfo); int num = this.coBll.UpdGuidang("Prj_TechnologyCriterion", mark, Convert.ToInt32(this.DDTClass.SelectedValue.Trim()), " where MainId=" + standardInfo.MainId); if (num == 1) { base.RegisterScript("top.ui.tabSuccess({ parentName: '_technologystandardquery' });"); return; } base.RegisterScript("top.ui.alert('保存失败!'); "); return; } }
public static int TechnologyUpd(TechnologyStandardInfo objInfo) { string str2 = "update Prj_TechnologyCriterion set TechnologyCriterionID='" + objInfo.TechnologyCriterionID + "',TechnologyClassify='"; object obj2 = str2 + objInfo.TechnologyClassify + "',TechnologyName='" + objInfo.TechnologyName + "',TechnologyPromulgateTime='"; return(publicDbOpClass.ExecSqlString(string.Concat(new object[] { obj2, objInfo.TechnologyPromulgateTime, "',Remark='", objInfo.Remark, "' where MainID='", objInfo.MainId, "'" }))); }
private TechnologyStandardCollectin GetSelect() { TechnologyStandardCollectin technologyStandardCollectin = new TechnologyStandardCollectin(); ArrayList arrayList = new ArrayList(); int maxId = TechnologyStandardAction.GetMaxId(); for (int i = 0; i < this.DGrdStandard.Items.Count; i++) { System.Web.UI.WebControls.DataGridItem dataGridItem = this.DGrdStandard.Items[i]; System.Web.UI.WebControls.CheckBox checkBox = (System.Web.UI.WebControls.CheckBox)dataGridItem.Cells[6].FindControl("CHK"); if (checkBox.Checked) { TechnologyStandardInfo technologyStandardInfo = new TechnologyStandardInfo(); technologyStandardInfo.TechnologyCriterion = int.Parse(this.DGrdStandard.DataKeys[i].ToString()); technologyStandardInfo.MainId = maxId + i; technologyStandardInfo.PrjCode = this.ViewState["PRJCODE"].ToString(); technologyStandardInfo.TechnologyCriterionID = dataGridItem.Cells[1].Text.ToString(); technologyStandardInfo.TechnologyClassify = dataGridItem.Cells[4].Text.ToString(); technologyStandardInfo.TechnologyName = dataGridItem.Cells[3].Text.ToString(); technologyStandardInfo.TechnologyPromulgateTime = dataGridItem.Cells[2].Text.ToString(); technologyStandardInfo.Remark = dataGridItem.Cells[5].Text.ToString(); technologyStandardCollectin.Add(technologyStandardInfo); arrayList.Add(technologyStandardInfo.MainId); } } this.ViewState["list"] = arrayList; return(technologyStandardCollectin); }
public static int TechnologyAdd(TechnologyStandardInfo objInfo) { string str = ""; str = "insert into Prj_TechnologyCriterion (MainID,PrjCode,TechnologyCriterionID,TechnologyClassify,"; object obj2 = str + "TechnologyName,TechnologyPromulgateTime,Remark,TechGuid) values('"; string str2 = string.Concat(new object[] { obj2, objInfo.MainId, "','", objInfo.PrjCode, "','", objInfo.TechnologyCriterionID, "','", objInfo.TechnologyClassify, "','" }); return(publicDbOpClass.ExecSqlString(str2 + objInfo.TechnologyName + "','" + objInfo.TechnologyPromulgateTime + "','" + objInfo.Remark + "','" + objInfo.TechGuid + "')")); }
private TechnologyStandardInfo GetStandardInfo() { TechnologyStandardInfo technologyStandardInfo = new TechnologyStandardInfo(); if (this._Type == "Add") { technologyStandardInfo.MainId = int.Parse(this._MaxId); } else { technologyStandardInfo.MainId = int.Parse(this._Id); } technologyStandardInfo.PrjCode = this._PrjCode; technologyStandardInfo.TechnologyCriterionID = this.TxtStandCode.Text.Trim(); technologyStandardInfo.TechnologyName = this.TxtStandName.Text.Trim(); technologyStandardInfo.TechnologyClassify = ((EditDropDownList)this.lbPlanSort.FindControl("ddlPlanSort")).Text; technologyStandardInfo.TechnologyPromulgateTime = this.DatePublic.Text; technologyStandardInfo.Remark = this.TxtRemark.Text.Trim(); technologyStandardInfo.TechGuid = this.hdnTechGuid.Value.Trim(); return(technologyStandardInfo); }