//保存报表 protected void SaveBook_Click(object sender, EventArgs e) { try { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); DataSet data = opt.CreateDataSetOra("select * from HT_SYS_EXCEL_BOOK where F_NAME = '" + ReportName.Text + "'"); if (data != null && data.Tables[0].Select().GetLength(0) > 0) { string[] seg = { "F_PARA", "F_TYPE" }; string[] value = { GetPara(), listType.SelectedValue }; string log_message = opt.UpDateData(seg, value, "HT_SYS_EXCEL_BOOK", " where F_NAME = '" + ReportName.Text + "'") == "Success" ? "更新报表成功" : "更新报表失败"; log_message += "--标识:" + ReportName.Text; InsertTlog(log_message); } else { string[] seg = { "F_PARA", "F_NAME", "F_SYNCHRO_TIME", "F_TYPE" }; string[] value = { GetPara(), ReportName.Text, DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss"), listType.SelectedValue }; string log_message = opt.InsertData(seg, value, "HT_SYS_EXCEL_BOOK") == "Success" ? "插入报表成功" : "插入报表失败"; log_message += "--标识:" + ReportName.Text; InsertTlog(log_message); } tvHtml = InitTreeR(); ScriptManager.RegisterStartupScript(UpdatePanel3, this.Page.GetType(), "", "initTreetoggle();", true); } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string[] seg = { "ID", "NAME", "MOBILE", "PHONE", "RTXID", "GENDER", "TEAM_CODE", "EMAIL", "LEVELGROUPID", "DESCRIPTION", "ROLE" }; string[] value = { txtID.Text, txtName.Text, txtPhone.Text, txtCallNO.Text, txtFax.Text, getGender(), listTeam.SelectedValue, txtEmail.Text, listApt.SelectedValue, txtDscp.Text, listRole.SelectedValue }; string log_message = opt.UpDateData(seg, value, "ht_svr_user", " where ID = '" + txtID.Text + "'") == "Success" ? "修改用户成功" : "修改用户失败"; log_message += "--用户ID:" + txtID.Text; InsertTlog(log_message); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "alert", "alert('" + log_message + "')", true); }
protected void btnModify_Click(object sender, EventArgs e) { string[] seg = { "ENG_CODE", "ENG_NAME", "PROCESS_CODE", "PROCESS_NAME", "UNIT_NAME", "UNIT_CODE", "REMARK", "IS_VALID" }; string[] value = { ENG_CODE.Text, ENG_NAME.Text, PROCESS_CODE.Text, PROCESS_NAME.Text, UNIT_NAME.Text, UNIT_CODE.Text, remark.Text, Convert.ToInt16(rdValid.Checked).ToString() }; //string[] value = { energyConsumptionPoint.SelectedValue.ToString(), energyConsumptionPoint.SelectedItem.Text, processName.SelectedValue.ToString(), processName.SelectedItem.Text, StartTime.Text, EndTime.Text, energyConsumption.Text, department.SelectedValue.ToString(), department.SelectedItem.Text, remark.Text, Convert.ToInt16(rdValid.Checked).ToString() }; string condition = " where ID =" + ENERGYID.Text; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string flag = opt.UpDateData(seg, value, "HT_ENG_CONSUMPTION_ITEM", condition); if (flag != "Success") { Response.Write("<script>alert('修改数据失败,已存在相同数据')</script>"); } BindData(); }
protected void btnGrid2Save_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); Button btn = (Button)sender; int Rowindex = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号 string ID = GridView2.DataKeys[Rowindex].Value.ToString(); Regex regNum = new Regex("^[0-9]"); if (((TextBox)GridView2.Rows[Rowindex].FindControl("txtNodeName")).Text == "" || regNum.IsMatch(((TextBox)GridView2.Rows[Rowindex].FindControl("txtNodeName")).Text) || ((TextBox)GridView2.Rows[Rowindex].FindControl("txtOrder")).Text == "") { ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "alert", "alert('请输入正确格式的信息!!');", true); return; } try { string[] seg = { "SECTION_CODE", "NODENAME", "ORDERS", "DESCRIPT", "CREATE_TIME", "TAG" }; string[] value = { listSection2.SelectedValue, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtNodeName")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtOrder")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtDscrpt")).Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ((TextBox)GridView2.Rows[Rowindex].FindControl("txtTag")).Text }; if (ID == "0") { string log_message = opt.InsertData(seg, value, "ht_pub_path_node") == "Success" ? "新增路径节点成功" : "新增路径节点失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); } else { string log_message = opt.UpDateData(seg, value, "ht_pub_path_node", " where ID = '" + ID + "'") == "Success" ? "更新路径节点成功" : "更新路径节点失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); string query = "delete from ht_pub_path_section where SECTION_CODE = '" + listSection2.SelectedValue + "'"; log_message = opt.UpDateOra(query) == "Success" ? "删除工艺路径成功" : "删除工艺路径失败"; InsertTlog(log_message); } bindGrid2(); if (listSection1.SelectedValue == listSection2.SelectedValue) { createGridView(); bindGrid1(); } } catch (Exception ee) { Response.Write(ee.Message); } }
protected void btnModify_Click(object sender, EventArgs e) { string[] seg = { "ENG_CODE", "ENG_NAME", "PROCESS_CODE", "PROCESS_NAME", "TIME", "AMOUNT", "UNIT_CODE", "UNIT_NAME", "REMARK", "IS_VALID" }; string[] value = { energyConsumptionPoint.SelectedValue.ToString(), energyConsumptionPoint.SelectedItem.Text, processName.SelectedValue.ToString(), processName.SelectedItem.Text, Time.Text, energyConsumption.Text, department.SelectedValue.ToString(), department.SelectedItem.Text, remark.Text, Convert.ToInt16(rdValid.Checked).ToString() }; System.Diagnostics.Debug.WriteLine(Time.Text); string condition = " where ID = '" + consumeID.Text + "'"; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string flag = opt.UpDateData(seg, value, "HT_ENG_MANUAL_DATA", condition); if (flag != "Success") { System.Diagnostics.Debug.WriteLine(flag); System.Diagnostics.Debug.WriteLine("eng" + energyConsumptionPoint.SelectedItem.Text); Response.Write("<script>alert('修改数据失败,已存在相同数据')</script>"); } BindData(); }
protected void btnSave_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string ftID = ""; List <String> commandlist = new List <string>(); string log_message; if (ckFault.Checked) { string query = "select * from HT_EQ_FAULT_DB where Error_name = '" + txtName.Text + "' and eqp_TYpe = '" + listEqType.SelectedValue + "' and SPECIFIC_LOCATION = '" + txtLocation.Text + "' and SECTION_CODE = '" + listSection.SelectedValue + "' and FAULT_TYPE1 = '" + listStyle1.SelectedValue + "' and FAULT_TYPE2 = '" + listStyle2.SelectedValue + "' and FAULT_TYPE3 = '" + listStyle3.SelectedValue + "' and FAULT_TYPE4 = '" + listStyle4.SelectedValue + "' and FAULT_TYPE5 = '" + listStyle5.SelectedValue + "' and FAULT_TYPE6 = '" + listStyle6.SelectedValue + "' and SCEAN = '" + txtScean.Text + "' and ERROR_DESCRIPTION = '" + txtDescpt.Text + "' and FAILURE_CAUSE = '" + txtReason.Text + "' and SOLUTION = '" + txtSolution.Text + "' and EQUIP_CODE = '" + listEq.SelectedValue + "'"; query = query.Replace("= ''", "is null"); DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { ftID = data.Tables[0].Rows[0]["ID"].ToString(); } else { ftID = opt.GetSegValue("select fault_id_seq.nextval from dual", "nextval"); string[] seg1 = { "ID", "ERROR_NAME", "EQP_TYPE", "SPECIFIC_LOCATION", "SECTION_CODE", "FAULT_TYPE1", "FAULT_TYPE2", "FAULT_TYPE3", "FAULT_TYPE4", "FAULT_TYPE5", "FAULT_TYPE6", "SCEAN", "ERROR_DESCRIPTION", "FAILURE_CAUSE", "SOLUTION", "CREATE_TIME", "EQUIP_CODE", "EDITOR" }; string[] value1 = { ftID, txtName.Text, listEqType.SelectedValue, txtLocation.Text, listSection.SelectedValue, listStyle1.SelectedValue, listStyle2.SelectedValue, listStyle3.SelectedValue, listStyle4.SelectedValue, listStyle5.SelectedValue, listStyle6.SelectedValue, txtScean.Text, txtDescpt.Text, txtReason.Text, txtSolution.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listEq.SelectedValue, ((MSYS.Data.SysUser)Session["User"]).text }; log_message = opt.InsertData(seg1, value1, "HT_EQ_FAULT_DB") == "Success" ? "故障信息入库成功" : "故障信息入库失败"; log_message += ",故障信息ID:" + ftID; InsertTlog(log_message); } } string[] seg = { "EQUIPMENT_ID", "EXE_TIME", "RESPONER", "MECH_AREA", "IS_FAULT", "RECORD", "RESULTS", "CONDITION", "FAULT_ID", "EXE_SEGTIME", "STATUS" }; string[] value = { listEq.SelectedValue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listOptor.SelectedValue, listArea.SelectedValue, Convert.ToInt16(ckFault.Checked).ToString(), txtRecord.Text, txtResults.Text, txtCondition.Text, ftID, txtSegcount.Text, "2" }; log_message = opt.UpDateData(seg, value, "HT_EQ_MT_PLAN_DETAIL", "where id = '" + txtCode.Text + "'") == "Success" ? "维修执行成功" : "维修执行失败"; log_message += ",维修明细ID:" + txtCode.Text; InsertTlog(log_message); bindGrid(); string alter = opt.GetSegValue("select case when total = done then 1 else 0 end as status from (select count(distinct t.id) as total,count( distinct t1.id) as done from HT_EQ_MT_PLAN_DETAIL t left join HT_EQ_MT_PLAN_DETAIL t1 on t1.id = t.id and t1.status >= '2' and t1.is_del = '0' where t.main_id = '" + hideMainid.Value + "' and t.is_del = '0')", "status"); if (alter == "1") { opt.UpDateOra("update HT_EQ_MT_PLAN set TASK_STATUS = '2' where PZ_CODE = '" + hideMainid.Value + "' and TASK_STATUS = '1'"); } ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "GridClick();", true); }
protected void btnRowSave_Click(object sender, EventArgs e) { bindGridView2(); //System.Diagnostics.Debug.WriteLine((GridView2.Rows[0].TemplateControl.FindControl("product_2") as TextBox).Text); System.Diagnostics.Debug.WriteLine(((TextBox)GridView2.Rows[0].FindControl("霉变异味")).Text); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); Button btn = (Button)sender; //string[] text = { "smell_2", "adjoin_2", "white_2", "water_2", "input_2", "sugar_2", "soda_2", "ntri_2" }; string[] text = this.getSTDD(); int loop = text.Length; int Rowindex = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号 string sql = "select prod_code from ht_pub_prod_design where is_del=0 and prod_name='" + ((TextBox)GridView2.Rows[Rowindex].FindControl("product_2")).Text + "'"; DataSet data = opt.CreateDataSetOra(sql); string prod_code = data.Tables[0].Rows[0][0].ToString(); string teamid = "01"; string team = ((TextBox)GridView2.Rows[Rowindex].FindControl("product_2")).Text; if (team == "乙班") { teamid = "02"; } if (team == "丙班") { teamid = "03"; } //((TextBox)GridView2.Rows[Rowindex].FindControl("txtNodeName")).Text //string[] seg = { "SECTION_CODE", "NODENAME", "ORDERS", "DESCRIPT", "CREATE_TIME", "TAG" }; //string[] value = { listSection2.SelectedValue, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtNodeName")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtOrder")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtDscrpt")).Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), ((TextBox)GridView2.Rows[Rowindex].FindControl("txtTag")).Text }; for (int i = 0; i < loop; i++) { string[] seg = { "INSPECT_VALUE" }; string[] value = { ((TextBox)GridView2.Rows[Rowindex].FindControl(text[i])).Text }; //string[] arg = {"703100001001","703100001002","703100001003","703100002001","703070305007","703100003001","703100003002","703100003003"}; string[] arg = this.getSTDDCode(); string log_message = opt.UpDateData(seg, value, "HT_QLT_INSPECT_RECORD", " where RECORD_TIME = '" + ((TextBox)GridView2.Rows[Rowindex].FindControl("record_time_2")).Text + "' and INSPECT_CODE='" + arg[i] + "' and prod_code = '" + prod_code + "' and is_del=0 and team_id='" + teamid + "'") == "Success" ? "更新路径节点成功" : "更新路径节点失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); } }