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 TechStandardSelect(TechnologyStandardCollectin objColl) { string str = ""; str = " begin "; foreach (TechnologyStandardInfo info in objColl) { str = str + " insert into Prj_TechnologyCriterion (MainID,PrjCode,TechnologyCriterionID,TechnologyClassify,"; str = str + "TechnologyName,TechnologyPromulgateTime,Remark,MainKey) values('"; object obj2 = str; str = string.Concat(new object[] { obj2, info.MainId, "','", info.PrjCode, "','", info.TechnologyCriterionID, "','", info.TechnologyClassify, "','" }); string str2 = str; str = str2 + info.TechnologyName + "','" + info.TechnologyPromulgateTime + "','" + info.Remark + "'," + info.TechnologyCriterion.ToString() + ")"; } return(publicDbOpClass.ExecSqlString(str + " end ")); }
protected void BtnSave_Click(object sender, EventArgs e) { TechnologyStandardCollectin select = this.GetSelect(); if (select.Count < 1) { return; } TechnologyStandardAction.TechStandardSelect(select); ConstructOrganizeBBl constructOrganizeBBl = new ConstructOrganizeBBl(); if (this.ViewState["list"] != null) { ArrayList arrayList = this.ViewState["list"] as ArrayList; for (int i = 0; i < arrayList.Count; i++) { constructOrganizeBBl.UpdGuidang("Prj_TechnologyCriterion", 2, 1, " where MainId=" + arrayList[i].ToString()); } } this.Js.Text = "window.close();"; }