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; } }
protected void BtnDelete_Click(object sender, EventArgs e) { List <string> list = new List <string>(); if (this.Hidden1.Value.Contains("[")) { list = JsonHelper.GetListFromJson(this.Hidden1.Value); } else { list.Add(this.Hidden1.Value); } StringBuilder stringBuilder = new StringBuilder(); for (int i = 0; i < list.Count; i++) { if (list[i].ToString() != "") { if (list.Count - 1 == i) { stringBuilder.Append("'").Append(list[i].ToString()).Append("'"); } else { stringBuilder.Append("'").Append(list[i].ToString()).Append("',"); } } } DatumLogic datumLogic = new DatumLogic(); if (datumLogic.DeleteList(stringBuilder.ToString())) { this.JS.Text = "alert('操作成功!');"; this.Data_Bind(); return; } this.JS.Text = "alert('操作失败,网络连接故障,请稍候再试')"; }
protected void btnFiles_Click(object sender, EventArgs e) { this.GET_SelectRow(); string text = string.Empty; if (this.ViewState["i_id"] != null) { text = this.ViewState["i_id"].ToString(); } if (text != "") { using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString)) { sqlConnection.Open(); SqlTransaction sqlTransaction = sqlConnection.BeginTransaction(); DatumLogic datumLogic = new DatumLogic(); try { if (datumLogic.UpdateByID(HighlightsList.table_name, "i_id", text, sqlTransaction)) { string[] array = text.Split(new char[] { ',' }); if (array.Length > 0) { for (int i = 0; i < array.Length; i++) { if (!string.IsNullOrEmpty(array[i].ToString())) { if (this.flc.Exists(array[i].ToString(), sqlTransaction)) { this.flc.Update(array[i].ToString(), 1, HighlightsList.table_name, sqlTransaction); } else { if (this.ViewState[HighlightsList.temTable] != null) { DataTable dataTable = this.ViewState[HighlightsList.temTable] as DataTable; foreach (DataRow dr in dataTable.Rows) { filesModel filesModel = new filesModel(); filesModel = this.flc.getModelByRow(dr); if (filesModel.file_sid == array[i].ToString()) { this.flc.Add(filesModel, sqlTransaction); } } } } } } } sqlTransaction.Commit(); this.JS.Text = "alert('操作成功!');"; this.Data_Bind(); } } catch (Exception) { sqlTransaction.Rollback(); base.RegisterScript("alert('系统提示:\\n\\n操作失败!');"); } } } }
protected void btnFiles_Click(object sender, EventArgs e) { this.GET_SelectRow(); string text = string.Empty; if (this.ViewState["i_id"] != null) { text = this.ViewState["i_id"].ToString(); } if (text != "") { using (SqlConnection sqlConnection = new SqlConnection(SqlHelper.ConnectionString)) { sqlConnection.Open(); SqlTransaction sqlTransaction = sqlConnection.BeginTransaction(); DatumLogic datumLogic = new DatumLogic(); try { if (datumLogic.UpdateByID(EPC_17_Ppm_ScienceInnovate_EngineerConfirmList.table_name, 1, "ID", text, sqlTransaction)) { string[] array = text.Split(new char[] { ',' }); if (array.Length > 0) { for (int i = 0; i < array.Length; i++) { if (!string.IsNullOrEmpty(array[i].ToString())) { if (this.flc.Exists(array[i].ToString(), sqlTransaction)) { this.flc.Update(array[i].ToString(), 1, EPC_17_Ppm_ScienceInnovate_EngineerConfirmList.table_name, sqlTransaction); } else { if (this.ViewState[EPC_17_Ppm_ScienceInnovate_EngineerConfirmList.temTable] != null) { DataTable dataTable = this.ViewState[EPC_17_Ppm_ScienceInnovate_EngineerConfirmList.temTable] as DataTable; foreach (DataRow dr in dataTable.Rows) { filesModel filesModel = new filesModel(); filesModel = this.flc.getModelByRow(dr); if (filesModel.file_sid == array[i].ToString()) { this.flc.Add(filesModel, sqlTransaction); } } } } } } } sqlTransaction.Commit(); base.RegisterScript("top.ui.show('操作成功!')"); this.MeasureBind(this._PrjCode, this._BigSort, this._SmallSort); } } catch (Exception ex) { ex.ToString(); sqlTransaction.Rollback(); sqlConnection.Close(); base.RegisterScript("top.ui.show('操作失败!');"); } } } }
protected void Button_save_Click(object sender, EventArgs e) { if (this.TextBox_cfyj.Text.Length > this.TextBox_cfyj.MaxLength) { this.JavaScriptControl1.Text = "alert('奖罚依据输入内容过长!')"; return; } if (this.TextBox_cfyy.Text.Length > this.TextBox_cfyy.MaxLength) { this.JavaScriptControl1.Text = "alert('奖罚原因输入内容过长!')"; return; } if (this.Textbox_bz.Text.Length > this.Textbox_bz.MaxLength) { this.JavaScriptControl1.Text = "alert('备注输入内容过长!')"; return; } ItemProgInfo itemProgInfo = new ItemProgInfo(); if (!string.IsNullOrWhiteSpace(this.pk)) { itemProgInfo.ID = int.Parse(this.pk); } itemProgInfo.ApproveResult = 0; itemProgInfo.ByProgObject = this.TextBox_bcfdx.Text.Trim(); itemProgInfo.Remark = this.Textbox_bz.Text.Trim(); itemProgInfo.ProgUnit = this.TextBox_cfdw.Text; if (this.Textbox_cfje.Text.Trim() != "") { itemProgInfo.ProgMoney = decimal.Parse(this.Textbox_cfje.Text.Trim()); } if (this.Textbox_cfrq.Text.Trim() != "") { itemProgInfo.ProgDate = DateTime.Parse(this.Textbox_cfrq.Text.Trim()); } itemProgInfo.ProgGist = this.TextBox_cfyj.Text.Trim(); itemProgInfo.ProgCause = this.TextBox_cfyy.Text.Trim(); itemProgInfo.Principal = this.Textbox_fzr.Text.Trim(); itemProgInfo.ProgBurstunit = this.Textbox_cfdkcdw.Text.Trim(); if (base.Request["Levels"] != null) { itemProgInfo.ProgSign = int.Parse(base.Request["Levels"].ToString()); } if (base.Request["Prjcode"] != null) { itemProgInfo.PrjCode = base.Request["Prjcode"].ToString(); } if (this.DropDownList_lb.SelectedValue != "") { itemProgInfo.ProgSortCode = int.Parse(this.DropDownList_lb.SelectedValue); } string sqlString = string.Empty; bool flag; if (string.IsNullOrWhiteSpace(this.pk)) { flag = ItemProgAction.ItemProgInfoOp(itemProgInfo, "Insert"); DatumLogic datumLogic = new DatumLogic(); int maxID = datumLogic.getMaxID("Prj_ItemProg", "ID"); if (this.cbkmark.Checked) { sqlString = string.Concat(new object[] { "UPDATE Prj_ItemProg SET filesType = ", this.DDTClass.SelectedValue, ",[mark] = 3 WHERE ID=", maxID }); } else { sqlString = string.Concat(new object[] { "UPDATE Prj_ItemProg SET filesType = ", this.DDTClass.SelectedValue, ",[mark] = 2 WHERE ID=", maxID }); } } else { flag = ItemProgAction.ItemProgInfoOp(itemProgInfo, "Update"); if (this.cbkmark.Checked) { sqlString = string.Concat(new object[] { "UPDATE Prj_ItemProg SET filesType = ", this.DDTClass.SelectedValue, ",[mark] = 3 WHERE ID=", itemProgInfo.ID }); } else { sqlString = string.Concat(new object[] { "UPDATE Prj_ItemProg SET filesType = ", this.DDTClass.SelectedValue, ",[mark] = 2 WHERE ID=", itemProgInfo.ID }); } } if (flag) { publicDbOpClass.ExecSqlString(sqlString); base.RegisterScript("top.ui.tabSuccess({ parentName: '_ItemProgManage' })"); return; } this.JavaScriptControl1.Text = "alert('保存失败!');"; }
public int GetMaxId() { DatumLogic logic = new DatumLogic(); return(logic.getMaxID("Prj_TechnologyTell", "MainID")); }