protected void BtnSave_Click(object sender, EventArgs e) { DatumLogic datumLogic = new DatumLogic(); MeasureDataInfo measureInfo = this.GetMeasureInfo(); if (this._Type == "Add") { int num = MeasureDataAction.MeasureAdd(measureInfo); if (num == 1) { int maxID = datumLogic.getMaxID("Prj_TechnologyManage", "ID"); if (maxID > 0) { if (this.cbkmark.Checked) { datumLogic.UpdateByID("Prj_TechnologyManage", "[mark]=3 ,filesType=" + int.Parse(this.DDTClass.SelectedValue.ToString()) + " ", "ID", maxID.ToString(), null); } else { datumLogic.UpdateByID("Prj_TechnologyManage", "[mark]=2 ,filesType=" + int.Parse(this.DDTClass.SelectedValue.ToString()) + " ", "ID", maxID.ToString(), null); } } base.RegisterScript("top.ui.tabSuccess({ parentName: '" + this.parentName + "' });"); this.BtnSave.Enabled = false; return; } base.RegisterScript("top.ui.show('保存失败')"); return; } else { int num = MeasureDataAction.MeasureUpd(measureInfo); if (num == 1) { int id = measureInfo.Id; if (id > 0) { if (this.cbkmark.Checked) { datumLogic.UpdateByID("Prj_TechnologyManage", "[mark]=3 ,filesType=" + int.Parse(this.DDTClass.SelectedValue.ToString()) + " ", "ID", id.ToString(), null); } else { datumLogic.UpdateByID("Prj_TechnologyManage", "[mark]=2 ,filesType=" + int.Parse(this.DDTClass.SelectedValue.ToString()) + " ", "ID", id.ToString(), null); } } base.RegisterScript("top.ui.tabSuccess({ parentName: '" + this.parentName + "' });"); return; } base.RegisterScript("top.ui.show('保存失败')"); return; } }
public static int MeasureAdd(MeasureDataInfo objInfo) { string str = ""; str = "insert into Prj_TechnologyManage (ID,PrjCode,SerialNumber,ItemName,AccessoriesName,Remark,"; string str2 = str; string str3 = str2 + " BigSort,SmallSort,TechGuid,FlowState,JoinPerson,ReceivePerson) values('" + objInfo.Id.ToString() + "','" + objInfo.PrjCode + "','" + objInfo.SerialNumber + "','"; str = str3 + objInfo.ItemName + "','" + objInfo.AccessoriesName + "','" + objInfo.Remark + "','" + objInfo.BigSort.ToString() + "','" + objInfo.SmallSort.ToString() + "','" + objInfo.TechGuid + "'"; int flowState = objInfo.FlowState; object obj2 = str; string str4 = string.Concat(new object[] { obj2, ",", objInfo.FlowState, "," }); return(publicDbOpClass.ExecSqlString(str4 + "'" + objInfo.JoinPerson.ToString() + "','" + objInfo.ReceivePerson.ToString() + "')")); }
private MeasureDataInfo GetMeasureInfo() { MeasureDataInfo measureDataInfo = new MeasureDataInfo(); if (this._Type == "Add") { measureDataInfo.Id = int.Parse(this._MaxId); measureDataInfo.BigSort = int.Parse(this._BigSort); if (this._SmallSort.Trim() != null) { measureDataInfo.SmallSort = int.Parse(this._SmallSort); } else { measureDataInfo.SmallSort = 0; } } else { measureDataInfo.Id = int.Parse(this._Id); } measureDataInfo.PrjCode = this._PrjCode; measureDataInfo.SerialNumber = this.TxtStandCode.Text.Trim(); measureDataInfo.ItemName = this.TxtStandName.Text.Trim(); measureDataInfo.Remark = this.TxtRemark.Text; measureDataInfo.FlowState = -1; measureDataInfo.TechGuid = this.hdnTechGuid.Value.Trim(); if (!string.IsNullOrEmpty(this.hfldPerson.Value.Trim())) { measureDataInfo.ReceivePerson = this.hfldPerson.Value.Trim(); } else { measureDataInfo.ReceivePerson = this.txtReceive.Text; } if (!string.IsNullOrEmpty(this.hfldName.Value.Trim())) { measureDataInfo.JoinPerson = this.hfldName.Value.Trim(); } else { measureDataInfo.JoinPerson = this.txtJoin.Text; } return(measureDataInfo); }
public static int MeasureUpd(MeasureDataInfo objInfo) { string str2 = "update Prj_TechnologyManage set ItemName='" + objInfo.ItemName + "',Remark='" + objInfo.Remark; return(publicDbOpClass.ExecSqlString(str2 + "',JoinPerson='" + objInfo.JoinPerson + "',ReceivePerson='" + objInfo.ReceivePerson + "' where ID='" + objInfo.Id.ToString() + "'")); }