protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); if (rd1.Checked) { if (listProd2.SelectedValue == "" || listPlanno.SelectedValue == "" || listTeam2.SelectedValue == "" || txtDate.Text == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "message", "alert('请录入完整的数据信息')", true); return; } else { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; string[] seg = { "PLANNO", "PROD_CODE", "SECTION_CODE", "TEAM", "TIME", "PARA_CODE", "CREATOR", "VALUE" }; foreach (GridViewRow row in GridView2.Rows) { string paravalue = ((TextBox)row.FindControl("txtParavalue")).Text; string paracode = ((DropDownList)row.FindControl("listPara")).SelectedValue; if (((TextBox)row.FindControl("txtParavalue")).Text != "") { string[] value = { listPlanno.SelectedValue, listProd2.SelectedValue, paracode.Substring(0, 5), listTeam2.SelectedValue, txtDate.Text, paracode, user.text, paravalue }; commandlist.Add(opt.getMergeStr(seg, value, 6, "HT_PROD_REPORT_DETAIL")); } } } } else { if (listProd2.SelectedValue == "" || listPlanno.SelectedValue == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "message", "alert('请录入完整的数据信息')", true); return; } else { foreach (GridViewRow row in GridView2.Rows) { string paravalue = ((TextBox)row.FindControl("txtParavalue")).Text; string paracode = ((DropDownList)row.FindControl("listPara")).SelectedValue; string[] seg = { "SECTION_CODE", "PLANNO", GridView2.DataKeys[row.RowIndex].Value.ToString() }; string[] value = { paracode.Substring(0, 5), listPlanno.SelectedValue, paravalue }; commandlist.Add(opt.getMergeStr(seg, value, 2, "HT_PROD_REPORT")); } } } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存物料过程数据成功," : "保存物料过程数据失败,"; log_message += "--详情产品:" + listProd2.SelectedValue + "计划号:" + listPlanno.SelectedValue + "班组:" + listTeam.SelectedValue + "日期:" + txtDate.Text; InsertTlog(log_message); ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", " $('.shade').fadeOut(100);", true); bindGrid(); bindGrid3(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); //opt.bindDropDownList(tag, "select DISTINCT ALM_TAGNAME from fixalarms", "ALM_TAGNAME", "ALM_TAGNAME"); opt.bindDropDownList(area, "select DISTINCT ALM_ALMAREA from fixalarms order by ALM_ALMAREA", "ALM_ALMAREA", "ALM_ALMAREA"); } }
protected void btnGridNew_Click(object sender, EventArgs e) { setBlank(); SetEnable("未提交"); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); txtCode.Text = "RP" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select nvl( max(substr(pz_code,11,3)),0) as ordernum from HT_EQ_RP_PLAN where substr(pz_code,1,10) ='RP" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0'); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; listEditor.SelectedValue = user.id; listApt.SelectedValue = user.OwningBusinessUnitId; bindGrid2(""); }
protected void btnGridNew_Click(object sender, EventArgs e)// 新增领退明细 { setBlank(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); txtCode.Text = "SF" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select nvl(max(substr(ORDER_SN,11,3)),0) as ordernum from HT_STRG_FLAVOR where substr(ORDER_SN,1,10) ='SF" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0'); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; listCreator.SelectedValue = user.id; listApt.SelectedValue = user.OwningBusinessUnitId; bindGrid2(); SetEnable(true); }
//根据操作用户插入日志 public void InsertTlog(string record) { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string query = "insert into HT_SVR_LOGIN_RECORD(F_USER,F_COMPUTER,F_TIME,F_DESCRIPT)values('" + user.text + "','" + Page.Request.UserHostName.ToString() + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + record + "')"; opt.UpDateOra(query); }
// private string currentTableId; protected void Page_Load(object sender, EventArgs e) { base.PageLoad(sender, e); if (!IsPostBack) { txtBtime.Text = System.DateTime.Now.ToString("yyyy-MM"); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); opt.bindDropDownList(listProd, "select prod_code,prod_name from ht_pub_prod_design where is_del= '0'", "prod_name", "prod_code"); bindgrid(); } }
protected void Page_Load(object sender, EventArgs e) { base.PageLoad(sender, e); if (!IsPostBack) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); opt.bindDropDownList(listEq, "select IDKEY,EQ_NAME from ht_eq_eqp_tbl where is_del = '0' and is_valid = '1'", "EQ_NAME", "IDKEY"); opt.bindDropDownList(listOptor, "select s.name,s.id from ht_svr_sys_role t left join ht_svr_sys_menu r on substr(t.f_right,r.f_id,1) = '1' left join ht_svr_user s on s.role = t.f_id where r.f_id = '" + this.RightId + "' union select q.name,q.id from ht_svr_sys_role t left join ht_svr_sys_menu r on substr(t.f_right,r.f_id,1) = '1' left join ht_svr_org_group s on s.f_role = t.f_id left join ht_svr_user q on q.levelgroupid = s.f_code where r.f_id = '" + this.RightId + "' order by id desc", "name", "ID"); opt.bindDropDownList(listArea, "select r.section_code,r.section_name from ht_pub_tech_section r where r.is_del = '0' and r.is_valid = '1' union select '' as section_code,'' as section_name from dual order by section_code", "section_name", "section_code"); opt.bindDropDownList(listSection, "select r.section_code,r.section_name from ht_pub_tech_section r where r.is_del = '0' and r.is_valid = '1' union select '' as section_code,'' as section_name from dual order by section_code", "section_name", "section_code"); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; txtOpttime.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); listOptor.SelectedValue = user.id; } }
protected void Page_Load(object sender, EventArgs e) { base.PageLoad(sender, e); if (!IsPostBack) { txtBtime.Text = System.DateTime.Now.ToString("yyyy-MM"); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); opt.bindDropDownList(prod_code, "select prod_code,prod_name from ht_pub_prod_design where is_del= '0'", "prod_name", "prod_code"); opt.bindDropDownList(address, "select distinct factory_address from ht_qlt_inspect_factory where is_del='0' and is_valid='1'", "factory_address", "factory_address"); opt.bindDropDownList(time, "select distinct factory_time from ht_qlt_inspect_factory where is_del='0' and is_valid='1'", "factory_time", "factory_time"); //bindgrid(); bindFactoryTables(); } }
protected void btnNew_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string code = opt.GetSegValue("select nvl(max(substr(QLT_CODE,4,3)),0)+1 as code from ht_qlt_stdd_code t", "code"); txtCode.Text = "QLT" + code.PadLeft(3, '0'); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; txtCreator.Text = user.text; txtCrtDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); txtDscpt.Text = ""; txtEndDate.Text = ""; txtExeDate.Text = ""; txtName.Text = ""; txtVersion.Text = ""; listAprv.SelectedValue = ""; }
protected void btngrid2Sure_Click(object sender, EventArgs e) { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; Button btn = (Button)sender; GridViewRow row = (GridViewRow)btn.NamingContainer; int index = row.RowIndex; string[] seg = { "RECORD_ID", "INSPECT_CODE", "STATUS", "SCORE", "CREAT_ID", "CREATE_TIME" }; string[] value = { GridView2.DataKeys[index].Values[0].ToString(), GridView2.DataKeys[index].Values[1].ToString(), "2", row.Cells[11].Text, user.id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string log_message = opt.MergeInto(seg, value, 1, "HT_QLT_INSPECT_EVENT") == "Success" ? "保存工艺质量事件成功" : "保存工艺质量事件失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); bindgrid2(); }
protected void btnAdd_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string str = opt.GetSegValue("select nvl(Max(substr(inspect_stdd_code,7,3)),0)+1 as code from HT_QLT_INSPECT_STDD t where is_del='0'", "CODE"); txtCode.Text = "ISP703" + str.PadLeft(3, '0'); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; listCreator.SelectedValue = user.id; txtCrtDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); btnSubmit.Enabled = true; btnSubmit.CssClass = "btn1 auth"; txtName.Text = ""; txtVersion.Text = ""; txtDscpt.Text = ""; ckValid.Checked = false; listAprv.SelectedValue = ""; }
protected void btnConfirm_Click(object sender, EventArgs e) { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; foreach (GridViewRow row in GridView2.Rows) { if (((CheckBox)row.FindControl("ck")).Checked && ((Label)row.FindControl("labStatus")).Text == "未处理") { int index = row.RowIndex; string[] seg = { "RECORD_ID", "INSPECT_CODE", "STATUS", "SCORE", "CREAT_ID", "CREATE_TIME" }; string[] value = { GridView2.DataKeys[index].Values[0].ToString(), GridView2.DataKeys[index].Values[1].ToString(), "2", row.Cells[11].Text, user.id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") }; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string log_message = opt.MergeInto(seg, value, 1, "HT_QLT_INSPECT_EVENT") == "Success" ? "确认工艺质量事件成功" : "确认工艺质量事件失败"; log_message += "--详情:" + string.Join(",", value); InsertTlog(log_message); } } bindgrid2(); }
protected void btnAdd_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string str = opt.GetSegValue("select nvl(Max(substr(tech_CODE,7,3)),0)+1 as code from ht_tech_stdd_code t where is_del='0'", "CODE"); txtCode.Text = "TCH703" + str.PadLeft(3, '0'); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; listCreator.SelectedValue = user.id; txtCrtDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); listCrtApt.SelectedValue = user.OwningBusinessUnitId; btnSubmit.Enabled = true; btnSubmit.CssClass = "btn1 auth"; txtName.Text = ""; txtVersion.Text = ""; txtExeDate.Text = ""; txtEndDate.Text = ""; listStatus.SelectedValue = ""; txtDscpt.Text = ""; ckValid.Checked = false; listAprv.SelectedValue = ""; }
protected void initView() { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); opt.bindDropDownList(listProd, "select prod_code,prod_name from ht_pub_prod_design where is_del= '0'", "prod_name", "prod_code"); opt.bindDropDownList(prod_code, "select prod_code,prod_name from ht_pub_prod_design where is_del= '0'", "prod_name", "prod_code"); opt.bindDropDownList(listTeam, "select team_code,team_name from ht_sys_team where is_del = '0' order by team_code", "team_name", "team_code"); opt.bindDropDownList(listShift, "select shift_code,shift_name from ht_sys_shift where is_del = '0'", "shift_name", "shift_code"); listTeam.SelectedValue = opt.GetSegValue(" select team_code from ht_prod_schedule where date_begin < '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' and date_end > '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'", "team_code"); listShift.SelectedValue = opt.GetSegValue(" select Shift_code from ht_prod_schedule where date_begin < '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' and date_end > '" + System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'", "Shift_code"); listEditor.Items.Clear(); ListItem item = new ListItem(user.text, user.id); listEditor.Items.Add(item); listEditor.SelectedValue = user.id; txtProdTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); string query = "select r.inspect_code,s.section_name ,r.inspect_name,0 as value,t.lower_value,t.upper_value,r.unit,'' as status,t.minus_score from ht_qlt_inspect_proj r left join ht_pub_tech_section s on s.section_code = r.inspect_group left join ht_qlt_inspect_stdd t on t.inspect_code = r.inspect_code and t.is_del = '0' where r.inspect_type = '0' and r.is_del = '0' order by s.section_name"; DataSet data = opt.CreateDataSetOra(query); bindGrid1(data); }
protected void btnAddR_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string str = opt.GetSegValue("select Max(Formula_code) as code from Ht_Qa_Mater_Formula ", "CODE"); if (str == "") { str = "00000000"; } txtCode.Text = "70306" + (Convert.ToInt16(str.Substring(5)) + 1).ToString().PadLeft(3, '0'); MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; listCreator.SelectedValue = user.id; txtCrtDate.Text = System.DateTime.Now.ToString("yyyy-MM-dd"); listCrtApt.SelectedValue = user.OwningBusinessUnitId; txtName.Text = ""; txtVersion.Text = ""; txtExeDate.Text = ""; txtEndDate.Text = ""; listStatus.SelectedValue = ""; txtDscpt.Text = ""; ckValid.Checked = false; }
protected void btnModify_Click(object sender, EventArgs e) { MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); List <string> commandlist = new List <string>(); if (listProd2.SelectedValue == "" || listTeam2.SelectedValue == "" || txtDate.Text == "") { ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "message", "alert('请录入完整的数据信息')", true); return; } else { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["User"]; string[] seg = { "PROD_CODE", "PROD_DATE", "TEAM", "PARA_CODE", "PARA_VALUE", "RECORD_TIME", "EDITOR" }; foreach (GridViewRow row in GridView2.Rows) { string paravalue = ((TextBox)row.FindControl("txtParavalue")).Text; string paracode = ((DropDownList)row.FindControl("listPara")).SelectedValue; if (((TextBox)row.FindControl("txtParavalue")).Text != "") { string[] value = { listProd2.SelectedValue, txtDate.Text, listTeam2.SelectedValue, paracode, paravalue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), user.id, }; commandlist.Add(opt.getMergeStr(seg, value, 4, "HT_PROD_INOUT_REPORT")); } } } string log_message = opt.TransactionCommand(commandlist) == "Success" ? "保存投入产出人工录入数据成功," : "保存投入产出人工录入数据失败,"; log_message += "--详情产品:" + listProd2.SelectedValue + listProd2.SelectedItem.Text + "班组:" + listTeam.SelectedValue + "日期:" + txtDate.Text; InsertTlog(log_message); ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('" + log_message + "'); ", true); bindGrid(); }
protected void bindGrid1() { MSYS.Data.SysUser user = (MSYS.Data.SysUser)Session["user"]; string query = "select g1.tb_zt as 业务名,g1.tbr_name as 申请人,g3.f_name as 申请部门 ,g1.state as 主业务审批状态,g2.STATUS as 当前流程状态,g2.gongwen_id,g2.id ,g1.BUSIN_ID from HT_PUB_APRV_FLOWINFO g1 left join ht_pub_aprv_opinion g2 on g1.id = g2.gongwen_id and g2.rolename = '" + user.UserRole + "' left join ht_svr_org_group g3 on g3.f_code = g1.tb_bm_id where g1.TB_DATE between '" + txtStarttime.Text + "' and '" + txtEndtime.Text + "' and ISENABLE = '1'"; //调试期间用下面SQL,正式运行用上面 // string query = "select g1.tb_zt as 业务名,g1.tbr_name as 申请人,g1.tb_bm_name as 申请部门 ,g1.state as 主业务审批状态,g2.STATUS as 当前流程状态,g2.gongwen_id,g2.id ,g1.BUSIN_ID from HT_PUB_APRV_FLOWINFO g1 left join ht_pub_aprv_opinion g2 on g1.id = g2.gongwen_id where g1.TB_DATE between '" + txtStarttime.Text + "' and '" + txtEndtime.Text + "' and ISENABLE = '1'"; if (ckDone.Checked) { query += " and g1.state = '0'"; } MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); // query += " and g2.rolename = '" + opt.GetSegValue("select * from HT_SVR_USER where LOGINNAME = '" + "cookieName" + "'", "ROLE") + "'"; //该处思路是找到当前登陆用户的角色,在列表中显示当前角色应审批的流程部分,还有按流程顺序,前面未完的部分不应出现在列表中 DataSet data = opt.CreateDataSetOra(query); GridView1.DataSource = data; GridView1.DataBind(); if (data != null && data.Tables[0].Rows.Count > 0) { for (int i = GridView1.PageSize * GridView1.PageIndex; i < GridView1.PageSize * (GridView1.PageIndex + 1) && i < data.Tables[0].Rows.Count; i++) { DataRowView mydrv = data.Tables[0].DefaultView[i]; GridViewRow row = GridView1.Rows[i - GridView1.PageSize * GridView1.PageIndex]; Label labState1 = (Label)row.FindControl("labStatus1"); switch (mydrv["主业务审批状态"].ToString()) { case "0": labState1.Text = "办理中"; break; case "1": labState1.Text = "被驳回"; break; case "2": labState1.Text = "己办结"; break; default: labState1.Text = "办理中"; break; } Label labState2 = (Label)row.FindControl("labStatus2"); switch (mydrv["当前流程状态"].ToString()) { case "0": labState2.Text = "未审批"; break; case "1": labState2.Text = "未通过"; break; case "2": labState2.Text = "己通过"; break; default: labState2.Text = "未审批"; break; } } } }