Esempio n. 1
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        try
        {
            MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
            string ftID             = "";
            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[] seg   = { "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[] value = { 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 };

                string log_message = opt.InsertData(seg, value, "HT_EQ_FAULT_DB") == "Success" ? "故障信息入库成功" : "故障信息入库失败";
                log_message += "--详情:" + string.Join(",", value);
                InsertTlog(log_message);
                bindGrid();
            }
        }
        catch (Exception ee)
        {
            Response.Write(ee.Message);
        }
    }
Esempio n. 2
0
 //保存报表
 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);
     }
 }
Esempio n. 3
0
    protected void btnModify_Click(object sender, EventArgs e)
    {
        MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
        string planname         = txtYear.Text + "-" + listMonth.SelectedValue;
        string query            = "select * from ht_prod_month_plan where plan_name = '" + planname + "生产月计划' and is_del = '0' ";

        hidePlanID.Value = opt.GetSegValue(query, "ID");
        if (hidePlanID.Value != "NoRecord")
        {
            ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "exist", "alert('己存在该月计划,请核实!!')", true);
            return;
        }

        string[] seg   = { "PLAN_NAME", "PLAN_TIME", "CREATE_ID", "CREATE_TIME", "REMARK" };
        string[] value = { planname + "生产月计划", planname, ((MSYS.Data.SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtRemark.Text };

        string log_message = opt.InsertData(seg, value, "ht_prod_month_plan") == "Success" ? "新增月度生产计划成功" : "新增月度生产计划失败";

        log_message += "--详情:" + string.Join(",", value);
        InsertTlog(log_message);
        hidePlanID.Value = opt.GetSegValue(query, "ID");


        bindGrid1();
        bindGrid2(hidePlanID.Value);
    }
Esempio n. 4
0
    protected void btnModify_Click(object sender, EventArgs e)
    {
        MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
        string planname         = txtYear.Text + "-" + listSeason2.SelectedValue + "季度生产计划";

        opt.UpDateOra("delete from  HT_PROD_SEASON_PLAN   where plan_name = '" + planname + "' and  is_del = '0'");
        string[] seg         = { "PLAN_YEAR", "QUARTER", "PLAN_NAME", "CREATE_ID", "CREATE_TIME", "REMARK" };
        string[] value       = { txtYear.Text, listSeason2.SelectedValue, planname, ((MSYS.Data.SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtRemark.Text };
        string   log_message = opt.InsertData(seg, value, "HT_PROD_SEASON_PLAN") == "Success" ? "新增季度生产计划成功" : "新增季度生产计划失败";

        log_message += "--详情:" + string.Join(",", value);
        InsertTlog(log_message);
        hidePlanID.Value = opt.GetSegValue("select * from HT_PROD_SEASON_PLAN   where plan_name = '" + planname + "' and  is_del = '0'", "ID");
        bindGrid1();
    }
Esempio n. 5
0
    protected void btnCreate_Click(object sender, EventArgs e)//按明细生成领退单
    {
        try
        {
            MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();

            //生成领用主表记录
            string[] seg   = { "OUT_DATE", "ORDER_SN", "EXPIRED_DATE", "MODIFY_TIME", "DEPT_NAME", "DEPT_ID", "CREATOR", "CREATOR_ID", "STRG_TYPE" };
            string[] value = { txtPrdctdate.Text, txtCode.Text, txtValiddate.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listApt.SelectedItem.Text, listApt.SelectedValue, "cookieName", "cookieID", "0" };
            opt.InsertData(seg, value, "HT_STRG_FLAVOR");
        }
        catch (Exception ee)
        {
            Response.Write(ee.Message);
        }
    }
Esempio n. 6
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        string[] seg        = { "ID", "ENG_CODE", "ENG_NAME", "PROCESS_CODE", "PROCESS_NAME", "CREATE_TIME", "UNIT_CODE", "UNIT_NAME", "REMARK", "IS_VALID", "IS_DEL" };
        string   tradeTime  = DateTime.Now.ToString("yyyyMMddHHmmss", DateTimeFormatInfo.InvariantInfo);
        string   createTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss", DateTimeFormatInfo.InvariantInfo);

        string[]            value = { tradeTime, ENG_CODE.Text, ENG_NAME.Text, PROCESS_CODE.Text, PROCESS_NAME.Text, createTime, UNIT_CODE.Text, UNIT_NAME.Text, remark.Text, Convert.ToInt16(rdValid.Checked).ToString(), "0" };
        MSYS.DAL.DbOperator opt   = new MSYS.DAL.DbOperator();
        string flag = opt.InsertData(seg, value, "HT_ENG_CONSUMPTION_ITEM");

        if (flag != "Success")
        {
            Response.Write("<script>alert('添加失败,数据已存在')</script>");
        }
        BindData();
    }
Esempio n. 7
0
 protected void btnSumit_Click(object sender, EventArgs e)
 {
     if (ckFault.Checked)
     {
         ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('应急维修请直接处理,无需上报!!');", true);
     }
     else
     {
         MSYS.DAL.DbOperator opt   = new MSYS.DAL.DbOperator();
         string[]            seg   = { "EQUIPMENT_ID", "EXE_TIME", "RESPONER", "MECH_AREA", "IS_EMG", "REASON", "CONTENT", "STATUS" };
         string[]            value = { listEq.SelectedValue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listOptor.SelectedValue, listArea.SelectedValue, Convert.ToInt16(ckFault.Checked).ToString(), txtReasons.Text, txtContent.Text, "-1" };
         string log_message        = opt.InsertData(seg, value, "HT_EQ_RP_PLAN_DETAIL") == "Success" ? "应急维修上报成功" : "应急维修上报失败";
         log_message += "--详情:" + string.Join(",", value);
         InsertTlog(log_message);
     }
 }
Esempio n. 8
0
    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);
        }
    }
Esempio n. 9
0
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        string[] seg       = { "ID", "ENG_CODE", "ENG_NAME", "PROCESS_CODE", "PROCESS_NAME", "TIME", "AMOUNT", "UNIT_CODE", "UNIT_NAME", "REMARK", "IS_VALID" };
        string   tradeTime = DateTime.Now.ToString("yyyyMMddHHmmss", DateTimeFormatInfo.InvariantInfo);

        System.Diagnostics.Debug.WriteLine("name" + processName.SelectedItem.Text);
        string[]            value = { tradeTime, 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() };
        MSYS.DAL.DbOperator opt   = new MSYS.DAL.DbOperator();
        System.Diagnostics.Debug.WriteLine(Time.Text);
        string flag = opt.InsertData(seg, value, "HT_ENG_MANUAL_DATA");

        System.Diagnostics.Debug.WriteLine(flag);
        if (flag != "Success")
        {
            Response.Write("<script>alert('添加失败,数据已存在')</script>");
        }
        BindData();
    }
Esempio n. 10
0
    protected void btnSave_Click(object sender, EventArgs e)
    {
        Button btn      = (Button)sender;
        int    rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex;
        string id       = GridView1.DataKeys[rowIndex].Value.ToString();

        GridViewRow row = GridView1.Rows[rowIndex];
        string      mapID, RightID;

        MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
        ///在映射表中插入URL映射
        if ("NoRecord" == (mapID = opt.GetSegValue("select * from ht_inner_map where URL = '" + ((TextBox)row.FindControl("txtURL")).Text + "'", "MAPID")))
        {
            mapID = id;

            opt.MergeInto(new string[] { "MAPID", "URL" }, new string[] { mapID, ((TextBox)row.FindControl("txtURL")).Text }, 1, "HT_INNER_MAP");
        }
        //在权限表中插入菜单权限
        if ("NoRecord" == (RightID = opt.GetSegValue("select * from ht_svr_sys_menu where F_MENU = '" + ((TextBox)row.FindControl("txtMenu")).Text + "'", "F_ID")))
        {
            RightID = (Convert.ToInt16(opt.GetSegValue("select Max(F_ID) as ID from ht_svr_sys_menu ", "ID")) + 1).ToString().PadLeft(5, '0');
        }

        string[] seg   = { "F_ID", "F_MENU", "F_MAPID", "F_PID", "F_DESCRIPT", "F_TYPE" };
        string[] value = { RightID, ((TextBox)row.FindControl("txtMenu")).Text, mapID, ((DropDownList)row.FindControl("listPrt")).SelectedValue, ((TextBox)row.FindControl("txtDscrp")).Text, "0" };

        //插入操作权限
        if ("Success" == opt.MergeInto(seg, value, 1, "ht_svr_sys_menu"))
        {
            value[0] = (Convert.ToInt16(RightID) + 1).ToString().PadLeft(5, '0');
        }
        value[5] = "1";
        if (value[1] == "")
        {
            value[1] = "子框架" + ((DropDownList)row.FindControl("listPrt")).SelectedItem.Text;
        }

        string log_message = opt.InsertData(seg, value, "ht_svr_sys_menu") == "Success" ? "插入操作权限成功" : "插入操作权限失败";

        log_message += "--详情:" + string.Join(",", value);
        InsertTlog(log_message);

        bindData();
    }
Esempio n. 11
0
    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);
    }
Esempio n. 12
0
    protected void btnCreate_Click(object sender, EventArgs e)
    {
        MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
        string  query           = "select * from HT_EQ_MCLBR_PLAN_detail where MAIN_ID = '" + listModel.SelectedValue + "' and is_del = '0'";
        DataSet data            = opt.CreateDataSetOra(query);

        if (data != null && data.Tables[0].Rows.Count > 0)
        {
            foreach (DataRow row in data.Tables[0].Rows)
            {
                string[] seg   = { "section", "equipment_id", "point", "exp_finish_time", "remark", "CREATE_TIME", "MAIN_ID" };
                string[] value = { row["section"].ToString(), row["equipment_id"].ToString(), row["point"].ToString(), System.DateTime.Now.AddMonths(1).ToString("yyyy-MM") + "-01", row["remark"].ToString(), System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtCode.Text };

                string log_message = opt.InsertData(seg, value, "HT_EQ_MCLBR_PLAN_detail") == "Success" ? "新增校准计划明细成功" : "新增校准计划明细失败";
                log_message += "--详情:" + string.Join(",", value);
                InsertTlog(log_message);
            }
        }
        bindGrid2(txtCode.Text);
    }
Esempio n. 13
0
    //同步季度生产计划
    protected void btnSync_Click(Object sender, EventArgs e)
    {
        MSYS.Web.PlanService.WsPlanForGSInterfaceService service = new MSYS.Web.PlanService.WsPlanForGSInterfaceService();
        MSYS.DAL.DbOperator opt  = new MSYS.DAL.DbOperator();
        string[]            seg1 = new string[] { "ID", "PLAN_NAME", "FLOW_STATUS", "ISSUED_STATUS", "CREATE_ID", "CREATE_TIME", "MODIFY_ID", "MODIFYER", "MODIFY_TIME", "DEPT_ID", "PLAN_YEAR", "QUARTER", "UNIT", "REMARK", "IS_DEL", "TOTAL_OUTPUT", "PZ_CODE", "ADJUST_STATUS" };
        string[]            seg2 = new string[] { "ID", "QUARTER_PLAN_ID", "PROD_CODE", "PLAN_OUTPUT_1", "PLAN_OUT_PUT_2", "PLAN_OUTPUT_3", "TOTAL_OUTPUT", "IS_DEL", "OUTPUT_1_ADJUST", "OUTPUT_2_ADJUST", "OUTPUT_3_ADJUST", "IS_VALID" };
        string table1            = " HT_PROD_SEASON_PLAN";
        string table2            = "HT_PROD_SEASON_PLAN_DETAIL";

        quarterPlanVO[] qp = service.getQuarterPlanList(txtYear.Text, listSeason.SelectedValue.ToString());
        foreach (quarterPlanVO q in qp)
        {
            string[] data   = new string[] { q.quarterPlan.id, q.quarterPlan.planName, q.quarterPlan.flowStatus, q.quarterPlan.issuedStatus, q.quarterPlan.createId, q.quarterPlan.createTime.ToString(), null, null, null, q.quarterPlan.deptId, q.quarterPlan.planYear, q.quarterPlan.quarter, q.quarterPlan.unitId };
            string   result = opt.InsertData(seg1, data, table1);
            foreach (tAmQuarterPlanDetail ap in q.subList)
            {
                string[] data_detail = new string[] { ap.id.ToString(), ap.quarterPlanId, ap.prodCode, ap.planOutput1.ToString(), ap.planOutput2.ToString(), ap.planOutput3.ToString(), ap.totalOutput.ToString(), ap.isDel, ap.output1Adjust, ap.output2Adjust, ap.output3Adjust, "true" };
            }
        }
    }
Esempio n. 14
0
    protected void btnCopy_Click(object sender, EventArgs e)
    {
        MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
        string  query           = "select * from HT_TECH_STDD_CODE_DETAIL where TECH_CODE = '" + listtech.SelectedValue + "' and is_del = '0'";
        DataSet data            = opt.CreateDataSetOra(query);

        if (data != null && data.Tables[0].Rows.Count > 0)
        {
            foreach (DataRow row in data.Tables[0].Rows)
            {
                string[] seg         = { "PARA_CODE", "VALUE", "UPPER_LIMIT", "LOWER_LIMIT", "EER_DEV", "UNIT", "TECH_CODE" };
                string[] value       = { row["PARA_CODE"].ToString(), row["VALUE"].ToString(), row["UPPER_LIMIT"].ToString(), row["LOWER_LIMIT"].ToString(), row["EER_DEV"].ToString(), row["UNIT"].ToString(), listtechC.SelectedValue };
                string   log_message = opt.InsertData(seg, value, "HT_TECH_STDD_CODE_DETAIL") == "Success" ? "复制标准成功" : "复制标准失败";
                log_message += ",复制数据:" + string.Join(",", value);
                InsertTlog(log_message);
            }
        }

        bindGrid(listtechC.SelectedValue, hideprc.Value);
        bindGrid2(listtechC.SelectedValue, hideprc.Value);
        initView();
    }