protected void btnAdd_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (!Regex.IsMatch(hidePlanID.Value, @"^[+-]?/d*$"))
{
hidePlanID.Value = hidePlanID.Value.Substring(hidePlanID.Value.LastIndexOf(',') + 1);
}
foreach (GridViewRow row in GridView2.Rows)
{
if (((TextBox)row.FindControl("txtPlanNo")).Text.Substring(11, 4) == "TEMP")
{
string[] subseg = { "plan_no", "MONTH_PLAN_ID", "plan_Sort", "prod_code", "plan_output" };
string[] subvalue = { ((TextBox)row.FindControl("txtPlanNo")).Text, hidePlanID.Value, ((TextBox)row.FindControl("txtOrder")).Text, ((DropDownList)row.FindControl("listProd")).SelectedValue, ((TextBox)row.FindControl("txtOutput")).Text };
opt.MergeInto(subseg, subvalue, 1, "HT_PROD_MONTH_PLAN_DETAIL");
}
}
string planno = opt.GetSegValue("select nvl(Max(substr(PLAN_NO,16,2)),0)+1 as CODE from ht_prod_month_plan_detail where month_plan_ID = '" + hidePlanID.Value + "'", "CODE");
string mtr_code = "PD" + txtYear.Text + listMonth.SelectedValue + "000TEMP" + planno.PadLeft(2, '0');
string order = opt.GetSegValue("select nvl(max(plan_sort),0)+1 as ordernum from ht_prod_month_plan_detail where month_plan_id= '" + hidePlanID.Value + "'", "ordernum");
string[] seg = { "plan_no", "MONTH_PLAN_ID", "plan_Sort", "is_del", "is_valid" };
string[] value = { mtr_code, hidePlanID.Value, order, "0", "0" };
opt.MergeInto(seg, value, 1, "HT_PROD_MONTH_PLAN_DETAIL");
string query = " select t.plan_Sort as 顺序号, t.plan_no as 计划号, t.prod_code as 产品名称,round(t.plan_output,3) as 计划产量,t.path_code as 路径编码,r.name as 生产状态,(case t.mater_status when '1' then '要料中' when '2' then '己出库' when '3' then '己到料' else '' end) as 原料状态,(case t.coat_status when '1' then '要料中' when '2' then '己出库' when '3' then '己到料' else '' end) as 回填液状态,(case t.FLAVOR_STATUS when '1' then '要料中' when '2' then '己出库' when '3' then '己到料' else '' end) as 香精香料状态 from ht_prod_month_plan_detail t left join ht_inner_prodexe_status r on t.exe_status = r.id where t.is_del = '0' and t.MONTH_PLAN_ID = " + hidePlanID.Value + " order by plan_Sort";
DataSet set = opt.CreateDataSetOra(query);
if (set != null)
{
DataTable data = set.Tables[0];
databindGrid2(data);
}
}
protected void btnGrid2Save_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "SHIFT_MAIN_ID", "mater_code", "PLAN_NO", "mater_vl", "bz_unit", "remark" };
string[] value = { hdID.Value, ((DropDownList)row.FindControl("listMater")).SelectedValue, listPlanno.SelectedValue, ((TextBox)row.FindControl("txtAmount")).Text, ((TextBox)row.FindControl("txtUnit")).Text, ((TextBox)row.FindControl("txtDescpt")).Text };
string log_message = opt.MergeInto(seg, value, 3, "HT_PROD_SHIFTCHG_DETAIL") == "Success" ? "保存生产交接班信息成功" : "保存生产交接班信息失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
string[] seg1 = { "PLANNO", "PROD_CODE", "SECTION_CODE", "TEAM", "TIME", "PARA_CODE", "CREATOR", "VALUE", };
string paravalue = ((DropDownList)row.FindControl("listMater")).SelectedValue;
string paracode = ((DropDownList)row.FindControl("listMater")).SelectedValue;
if (((TextBox)row.FindControl("txtParavalue")).Text != "")
{
string[] value1 = { listPlanno.SelectedValue, listPlanno.SelectedValue.Substring(8, 7), paracode.Substring(0, 5), listTeam.SelectedValue, txtDate.Text, paracode, txtEditor.Text, paravalue };
opt.MergeInto(seg1, value1, 6, "HT_PROD_REPORT_DETAIL");
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
MSYS.Web.PlanService.WsPlanForGSInterfaceService service = new MSYS.Web.PlanService.WsPlanForGSInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
System.Diagnostics.Debug.WriteLine(System.DateTime.Now.Month.ToString());
string month = System.DateTime.Now.Month.ToString().Length < 2? "0" + System.DateTime.Now.Month.ToString():System.DateTime.Now.Month.ToString();
prodAssignPlan[] pb = service.getProdAssignForGS(System.DateTime.Now.Year.ToString(), month);
prodAssignVO[] pvo = service.getProdAssignListForGS(System.DateTime.Now.Year.ToString(), month);
string[] seg = { "id", "PLAN_NAME", "B_FLOW_STATUS", "ISSUED_STATUS", "PLAN_TIME", "IS_DEL", "REMARK", "CREATE_ID" };
string[] seg2 = { "month_plan_id", "plan_no", "prod_code ", "plan_year", "prod_month", "plan_type", "plan_output", "plan_sort", "exe_status", "is_del", "is_valid", "create_id", "path_code" };
if (pb == null || pvo == null)
{
System.Diagnostics.Debug.WriteLine("无数据");
return;
}
string monthid = "";
string cid = "";
foreach (prodAssignPlan p in pb)
{
if (p.planNo.ToString().Substring(0, 2) != "GS")
{
continue;
}
monthid = p.id;
string sqllog = "select id from ht_svr_user where loginname = '" + pvo[0].planNo + "'";
if (pvo[0].createId != null)
{
cid = opt.CreateDataSetOra(sqllog).Tables[0].Rows[0][0].ToString();
}
string[] value = { p.id, p.planName, "2", p.issuedStatus, p.planNo.Substring(2, 4) + "-" + p.planNo.Substring(6, 2), "0", p.remark, cid };
// string[] value2 = { p.id };
opt.MergeInto(seg, value, 2, "HT_PROD_MONTH_PLAN");
// opt.getMergeStr(seg2, value2, 1, "HT_PROD_MONTH_PLAN_DETAIL");
// dt.Rows.Add(paras);
}
foreach (prodAssignVO p in pvo)
{
//if (p.planNo.ToString().Substring(0, 2) != "GS")
//continue;
// string sql = "select xy_prod_code from ht_pub_prod_design where prod_code = " + p.prodCode;
// DataSet ds = opt.CreateDataSetOra(sql);
//string xy_prod_code = ds.Tables[0].Rows[0][0].ToString();
if (p.prodCode.Substring(0, 3) != "703")
{
continue;
}
string path_code = opt.GetSegValue("select path_code from ht_pub_prod_design where prod_code = '" + p.prodCode + "'", "path_code");
string[] value = { monthid, p.planNo, p.prodCode, p.jobYear, p.jobMonth, p.planType, p.jobOutput, p.jobSort, Convert.ToInt32(p.status).ToString(), "0", "1", cid, path_code };
opt.MergeInto(seg2, value, 2, "HT_PROD_MONTH_PLAN_DETAIL");
insertSectionPath(path_code, p.planNo);
}
bindGrid1();
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('同步完成');", true);
return;
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
MSYS.Web.PlanService.WsPlanForGSInterfaceService service = new MSYS.Web.PlanService.WsPlanForGSInterfaceService();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
quarterPlanVO[] pb = service.getQuarterPlanList(System.DateTime.Now.Year.ToString(), GetQuarterNum(System.DateTime.Now));
if (pb == null)
{
return;
}
// prodAssignVO[] pvo = service.getProdAssignListForGS("", "");
string[] seg = { "id", "PLAN_NAME", "FLOW_STATUS", "ISSUED_STATUS", "PLAN_YEAR", "QUARTER", "IS_DEL", "REMARK", "CREATE_ID" };
string[] seg2 = { "QUARTER_PLAN_ID", "prod_code ", "plan_OUTPUT_1", "PLAN_OUTPUT_2", "PLAN_OUTPUT_3", "TOTAL_OUTPUT", "IS_DEL" };
foreach (quarterPlanVO p in pb)
{
//string plname = p.quarterPlan.planName == "" ? System.DateTime.Now.Year.ToString() + "-" + GetQuarterNum(new DateTime()) + "季度生产计划" :p.quarterPlan.planName;
string plname = System.DateTime.Now.Year.ToString() + "-" + Convert.ToInt32(GetQuarterNum(System.DateTime.Now)).ToString() + "季度生产计划";
System.Diagnostics.Debug.WriteLine(plname);
System.Diagnostics.Debug.WriteLine(p.quarterPlan.id);
string sqllog = "select id from ht_svr_user where loginname = '" + p.quarterPlan.createId + "'";
string cid = opt.CreateDataSetOra(sqllog).Tables[0].Rows[0][0].ToString();
string[] value = { p.quarterPlan.pzCode, plname, "2", p.quarterPlan.issuedStatus, p.quarterPlan.planYear, Convert.ToInt32(GetQuarterNum(System.DateTime.Now)).ToString(), "0", p.quarterPlan.remark, cid };
// string[] value2 = { p.id };
opt.MergeInto(seg, value, 2, "HT_PROD_SEASON_PLAN");
foreach (tAmQuarterPlanDetail pd in p.subList)
{
System.Diagnostics.Debug.WriteLine(pd.prodCode);
System.Diagnostics.Debug.WriteLine(System.DateTime.Now.Year.ToString());
System.Diagnostics.Debug.WriteLine(GetQuarterNum(System.DateTime.Now));
string sql = "select prod_code from ht_pub_prod_design where xy_prod_code = " + pd.prodCode;
DataSet ds = opt.CreateDataSetOra(sql);
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
continue;
}
string xy_prod_code = ds.Tables[0].Rows[0][0].ToString();
if (xy_prod_code.Substring(0, 3) != "703")
{
continue;
}
// string[] value2 = { p.quarterPlan.id, pd.prodCode, pd.planOutput1.ToString(), pd.planOutput2.ToString(), pd.planOutput3.ToString(), pd.totalOutput.ToString(), pd.isDel };
string[] value2 = { p.quarterPlan.pzCode, xy_prod_code, pd.planOutput1.ToString(), pd.planOutput2.ToString(), pd.planOutput3.ToString(), pd.totalOutput.ToString(), pd.isDel };
opt.MergeInto(seg2, value2, 2, "HT_PROD_SEASON_PLAN_DETAIL");
}
// opt.getMergeStr(seg2, value2, 1, "HT_PROD_MONTH_PLAN_DETAIL");
// dt.Rows.Add(paras);
}
bindGrid1();
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", "alert('同步完成');", true);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (!Regex.IsMatch(hidePlanID.Value, @"^[+-]?/d*$"))
{
hidePlanID.Value = hidePlanID.Value.Substring(hidePlanID.Value.LastIndexOf(',') + 1);
}
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
foreach (GridViewRow row in GridView2.Rows)
{
if (!(((TextBox)row.FindControl("txtAmount1")).Text == "" && ((TextBox)row.FindControl("txtAmount2")).Text == "" && ((TextBox)row.FindControl("txtAmount3")).Text == ""))
{
if (((TextBox)row.FindControl("txtAmount1")).Text == "")
{
((TextBox)row.FindControl("txtAmount1")).Text = "0";
}
if (((TextBox)row.FindControl("txtAmount2")).Text == "")
{
((TextBox)row.FindControl("txtAmount2")).Text = "0";
}
if (((TextBox)row.FindControl("txtAmount3")).Text == "")
{
((TextBox)row.FindControl("txtAmount3")).Text = "0";
}
((TextBox)row.FindControl("txtOutput")).Text = (Convert.ToDouble(((TextBox)row.FindControl("txtAmount1")).Text) + Convert.ToDouble(((TextBox)row.FindControl("txtAmount2")).Text) + Convert.ToDouble(((TextBox)row.FindControl("txtAmount3")).Text)).ToString("0.000");
string[] seg = { "QUARTER_PLAN_ID", "ID", "prod_code", "TOTAL_OUTPUT", "plan_output_1", "plan_output_2", "plan_output_3", "IS_DEL" };
string[] value = { hidePlanID.Value, GridView2.DataKeys[row.RowIndex].Value.ToString(), ((DropDownList)row.FindControl("listProd")).SelectedValue, ((TextBox)row.FindControl("txtOutput")).Text, ((TextBox)row.FindControl("txtAmount1")).Text, ((TextBox)row.FindControl("txtAmount2")).Text, ((TextBox)row.FindControl("txtAmount3")).Text, "0" };
opt.MergeInto(seg, value, 2, "ht_prod_season_plan_Detail");
}
}
string mtr_code = opt.GetSegValue("select seasondt_id_seq.nextval as id from dual", "id");
string[] subseg = { "QUARTER_PLAN_ID", "ID", "IS_VALID" };
string[] subvalue = { hidePlanID.Value, mtr_code, "0" };
opt.MergeInto(subseg, subvalue, 2, "ht_prod_season_plan_Detail");
string query = "select r.prod_code as 产品,round(r.TOTAL_OUTPUT,3) as 计划数量,round(r.plan_output_1,3) as month1,round(r.plan_output_2,3) as month2,round(r.plan_output_3,3) as month3,r.id from ht_prod_season_plan_Detail r where r.is_del = '0' and r.QUARTER_PLAN_ID = " + hidePlanID.Value + "order by r.id";
DataSet set = opt.CreateDataSetOra(query);
if (set != null)
{
datagrid2Bind(set.Tables[0]);
}
}
protected void btnSave2_Click(object sender, EventArgs e)
{
string suc = "保存成功";
for (int i = 0; i < GridView2.Rows.Count; i++)
{
GridViewRow row = GridView2.Rows[i];
string mtr_code = ((TextBox)row.FindControl("txtCodeM")).Text;
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
{
string[] seg = { "PARA_CODE", "TECH_CODE", "VALUE", "UPPER_LIMIT", "LOWER_LIMIT", "EER_DEV", "UNIT", "IS_DEL" };
string[] value = { ((TextBox)row.FindControl("txtCodeM")).Text, txtCode.Text, ((TextBox)row.FindControl("txtValueM")).Text, ((TextBox)row.FindControl("txtUlimitM")).Text, ((TextBox)row.FindControl("txtLlimitM")).Text, ((TextBox)row.FindControl("txtDevM")).Text, ((TextBox)row.FindControl("txtUnitM")).Text, "0" };
string log_message;
if (opt.MergeInto(seg, value, 2, "HT_TECH_STDD_CODE_DETAIL") == "Success")
{
log_message = "保存参数成功";
}
else
{
log_message = "保存参数失败";
suc = "部分参数保存失败，请检查！！";
}
log_message += ", 保存数据：" + string.Join(",", value);
InsertTlog(log_message);
}
}
bindGrid(txtCode.Text, hideprc.Value);
bindGrid2(txtCode.Text, hideprc.Value);
ScriptManager.RegisterStartupScript(UpdatePanel5, this.Page.GetType(), "alert", "alert('" + suc + "')", true);
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "QLT_CODE", "QLT_NAME", "STANDARD_VOL", "B_DATE", "E_DATE", "CREATE_ID", "CREATE_DATE", "REMARK" };
string[] value = { txtCode.Text, txtName.Text, txtVersion.Text, txtExeDate.Text, txtEndDate.Text, ((MSYS.Data.SysUser)Session["User"]).id, txtCrtDate.Text, txtDscpt.Text, };
string log_message;
if (opt.MergeInto(seg, value, 1, "HT_QLT_STDD_CODE") == "Success")
{
log_message = "保存质量考核标准成功";
opt.bindDropDownList(listVersion, "select QLT_CODE,QLT_NAME from ht_qlt_STDD_CODE where is_valid = '1' and is_del= '0'", "QLT_NAME", "QLT_CODE");
opt.bindDropDownList(listtech, "select QLT_CODE,QLT_NAME from ht_qlt_STDD_CODE where is_valid = '1' and is_del= '0'", "QLT_NAME", "QLT_CODE");
opt.bindDropDownList(listtechC, "select QLT_CODE,QLT_NAME from ht_qlt_STDD_CODE where is_valid = '1' and is_del= '0'", "QLT_NAME", "QLT_CODE");
listAprv.SelectedValue = "-1";
}
else
{
log_message = "保存质量考核标准失败";
}
log_message += "--数据详情:" + string.Join(",", value);
InsertTlog(log_message);
}
protected void btnSave_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "INSPECT_CODE", "INSPECT_GROUP", "INSPECT_NAME", "INSPECT_TYPE", "REMARK", "CREATE_ID", "CREATE_TIME", "UNIT" };
string[] value = { txtCode.Text, listSection2.SelectedValue, txtName.Text, listType2.SelectedValue, txtRemark.Text, listCreator.SelectedValue, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtUnit.Text };
string log_message = opt.MergeInto(seg, value, 1, "ht_qlt_inspect_proj") == "Success" ? "保存工艺检查项目成功" : "保存工艺检查项目失败";
if (log_message == "保存工艺检查项目成功")
{
string[] procseg = { };
object[] procvalues = { };
if (listSection2.SelectedValue == "4")
{
opt.ExecProcedures("Create_Sensor_Report", procseg, procvalues);
}
else if (listSection2.SelectedValue.Length == 1 && listSection2.SelectedValue != "4")
{
opt.ExecProcedures("Create_phychem_Report", procseg, procvalues);
}
else
{
opt.ExecProcedures("Create_process_Report", procseg, procvalues);
}
}
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
bindGrid();
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", " $('.shade').fadeOut(100);", true);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Button btn = (Button)sender;
int Rowindex = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号
if (Rowindex >= 0)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "PZ_TYPE", "INDEX_NO", "ROLE", "FLOW_NAME" };
string[] value = { ((DropDownList)GridView1.Rows[Rowindex].FindControl("listType")).SelectedValue, ((TextBox)GridView1.Rows[Rowindex].FindControl("txtOrder")).Text, ((DropDownList)GridView1.Rows[Rowindex].FindControl("listRole")).SelectedValue, ((TextBox)GridView1.Rows[Rowindex].FindControl("txtFlowname")).Text };
string log_message = opt.MergeInto(seg, value, 2, "ht_pub_aprv_model") == "Success" ? "模板流程表保存成功" : "模板流程表保存失败";
log_message += ",保存参数:" + ((DropDownList)GridView1.Rows[Rowindex].FindControl("listType")).SelectedValue + " " + ((TextBox)GridView1.Rows[Rowindex].FindControl("txtOrder")).Text;
InsertTlog(log_message);
bindData(txtCode.Text);
}
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
protected void btnGrid2Save_Click(object sender, EventArgs e)//
{
Button btn = (Button)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
if (((DropDownList)row.FindControl("listGridarea")).SelectedValue == "" || ((DropDownList)row.FindControl("listGridEq")).SelectedValue == "" || ((TextBox)row.FindControl("txtGridExptime")).Text == "")
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('请将信息填写完全后再保存');", true);
return;
}
int rowIndex = ((GridViewRow)btn.NamingContainer).RowIndex;
string id = GridView2.DataKeys[rowIndex].Value.ToString();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (id == "0")
{
id = opt.GetSegValue("select rpdetail_id_seq.nextval as id from dual", "id");
}
string[] seg = { "ID", "mech_area", "equipment_id", "reason", "content", "exp_finish_time", "remark", "CREATE_TIME", "MAIN_ID", "STATUS" };
string[] value = { id, ((DropDownList)row.FindControl("listGridarea")).SelectedValue, ((DropDownList)row.FindControl("listGridEq")).SelectedValue, ((TextBox)row.FindControl("txtGridReason")).Text, ((TextBox)row.FindControl("txtGridcntnt")).Text, ((TextBox)row.FindControl("txtGridExptime")).Text, ((TextBox)row.FindControl("txtGridremark")).Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtCode.Text, "0" };
string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_RP_PLAN_detail") == "Success" ? "新增维修明细成功" : "新增维修明细失败";
log_message += "--详情：" + string.Join(",", value);
InsertTlog(log_message);
bindGrid2(txtCode.Text);
}
protected void btnGrid2Save_Click(object sender, EventArgs e)
{
try
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (txtPzcode.Text == "")
{
txtPzcode.Text = "PK" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select nvl(max(substr(PZ_CODE,3,11)),0) as ordernum from HT_EQ_STG_PICKUP where substr(PZ_CODE,1,10) ='PK" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0');
}
Button btn = (Button)sender;
int Rowindex = ((GridViewRow)btn.NamingContainer).RowIndex;//获得行号
string ID = GridView2.DataKeys[Rowindex].Value.ToString();
if (ID == "0")
{
ID = opt.GetSegValue("select sub_pickup_id_seq.nextval as id from dual", "ID");
}
string[] seg = { "ID", "MAIN_CODE", "STORAGE", "Sp_Code", "sp_name", "sp_standard", "sp_model", "sp_unit", "pickup_num", "own_section", "remark" };
string[] value = { ID, txtPzcode.Text, ((DropDownList)GridView2.Rows[Rowindex].FindControl("listGridstrg")).SelectedValue, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridCode")).Text, ((DropDownList)GridView2.Rows[Rowindex].FindControl("listGridName")).SelectedItem.Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridSpec")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridModel")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridUnit")).Text, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridAmount")).Text, ((DropDownList)GridView2.Rows[Rowindex].FindControl("listGridSection")).SelectedValue, ((TextBox)GridView2.Rows[Rowindex].FindControl("txtGridDscprt")).Text };
string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_STG_PICKUP_DETAIL") == "Success" ? "保存备品备件领退明细成功" : "保存备品备件领退明细失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
bindGrid2();
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
}//绑定GridView2数据源
protected void btnGrid2Save_Click(object sender, EventArgs e)//
{
try
{
Button btn = (Button)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
int rowIndex = row.RowIndex;
string id = GridView2.DataKeys[rowIndex].Value.ToString();
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "ID", "OLDVALUE", "POINTVALUE", "SAMPLE_TIME", "remark", "STATUS" };
string[] value = { id, ((TextBox)row.FindControl("txtGridOldvalue")).Text, ((TextBox)row.FindControl("txtGridNewvalue")).Text, ((TextBox)row.FindControl("txtGridClbrtime")).Text, ((TextBox)row.FindControl("txtGridremark")).Text, "2" };
string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_MCLBR_PLAN_detail") == "Success" ? "自动校准成功" : "自动校准失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
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_MCLBR_PLAN_detail t left join HT_EQ_MCLBR_PLAN_detail t1 on t1.id = t.id and t1.status >= '2' and t1.is_del = '0' where t.main_id = '" + txtCode.Value + "' and t.is_del = '0')", "status");
if (alter == "1")
{
opt.UpDateOra("update HT_EQ_MCLBR_PLAN set TASK_STATUS = '2' where PZ_CODE = '" + txtCode.Value + "' and TASK_STATUS = '1'");
bindGrid1();
}
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
protected void btnModify2_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (txtCode_2.Text.Length == 8 && txtCode_2.Text.Substring(0, 5) == listSection_2.SelectedValue)
{
string[] seg = { "IDKEY", "CLS_CODE", "EQ_NAME", "SECTION_CODE", "REMARK", "CREATOR", "CREATE_TIME", "IS_CTRL" };
string[] value = { txtCode_2.Text, listSort_2.SelectedValue, txtName_2.Text, listSection_2.SelectedValue, txtDscpt_2.Text, ((MSYS.Data.SysUser)Session["user"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Convert.ToInt16(ckCtrl_2.Checked).ToString() };
string log_message;
if (opt.MergeInto(seg, value, 1, "HT_EQ_EQP_TBL") == "Success")
{
log_message = "保存设备成功";
tvHtml = InitTree();
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('保存成功');", true);
}
else
{
log_message = "保存设备失败";
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "alert('保存失败');", true);
}
log_message += "--数据详情:" + string.Join("-", value);
InsertTlog(log_message);
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "message", "alert('请确认设备所属工艺段是否正确')", true);
}
}
protected void btnGrid2Save_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (txtCode.Text == "")
{
txtCode.Text = "SC" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select count(ORDER_SN) as ordernum from HT_STRG_COAT where substr(ORDER_SN,1,10) ='SC" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0');
}
Button btn = (Button)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
string ID = GridView2.DataKeys[row.RowIndex].Value.ToString();
if (ID == "0")
{
ID = opt.GetSegValue("select STRGCOAT_ID_SEQ.nextval as id from dual", "ID");
}
string[] seg = { "ID", "STORAGE", "unit_code", "mater_code", "ORIGINAL_DEMAND", "MAIN_CODE" };
string[] value = { ID, ((DropDownList)row.FindControl("listGridstrg")).SelectedValue, ((TextBox)row.FindControl("txtGridUnit")).Text, ((TextBox)row.FindControl("txtGridcode")).Text, ((TextBox)row.FindControl("txtGridAmount")).Text, txtCode.Text };
string log_message = opt.MergeInto(seg, value, 1, "HT_STRG_COAT_SUB") == "Success" ? "保存原料领用明细成功" : "保存原料领用明细失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
update_MainAmount(txtCode.Text);
bindGrid2();
}
protected void btnModify1_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
{
string[] seg = { "SECTION_CODE", "SECTION_NAME", "REMARK", "IS_PATH_CONFIG", "CREATE_ID", "CREATE_TIME" };
string[] value = { txtCode_1.Text, txtName_1.Text, txtDscrp_1.Text, Convert.ToInt16(rdValid_1.Checked).ToString(), ((MSYS.Data.SysUser)Session["user"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") };
string log_message;
if (opt.MergeInto(seg, value, 1, "HT_PUB_TECH_SECTION") == "Success")
{
log_message = "保存工艺段成功";
tvHtml = InitTree();
opt.bindDropDownList(listSection_2, "select section_code,section_name from ht_pub_tech_section where is_del = '0' and is_valid = '1' order by section_code", "section_name", "section_code");
opt.bindDropDownList(listSection, "select section_code,section_name from ht_pub_tech_section where is_valid = '1' and is_del = '0' order by section_code", "section_name", "section_code");
string[] procseg = { };
object[] procvalues = { };
opt.ExecProcedures("Create_Online_month_Report", procseg, procvalues);
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('保存成功');", true);
}
else
{
log_message = "保存工艺段失败";
}
log_message += "--数据详情:" + string.Join("-", value);
InsertTlog(log_message);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] subseg = { "ID", "EDITOR", "EDITTIME", "REASON", "COMMENTS" };
string[] subvalue = { hideEventID.Value, txtEditor.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), txtReason.Text, txtDescrpt.Text };
opt.MergeInto(subseg, subvalue, 1, "HT_TECH_EVENT");
}
protected void btnSave_Click(object sender, EventArgs e)//
{
if (txtName.Text == "" || listEditor.SelectedValue == "" || txtExptime.Text == "")
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", "alert('请将信息填写完全');", true);
return;
}
try
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "PZ_CODE", "MT_NAME", "CREATE_ID", "CREATE_DEPT_ID", "EXPIRED_DATE", "REMARK", "CREATE_TIME" };
string[] value = { txtCode.Text, txtName.Text, listEditor.SelectedValue, listApt.SelectedValue, txtExptime.Text, txtdscrpt.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") };
string log_message = opt.MergeInto(seg, value, 1, "HT_EQ_RP_PLAN") == "Success" ? "新增维修计划成功" : "新增维修计划失败";
log_message += "--详情：" + string.Join(",", value);
InsertTlog(log_message);
bindGrid1();
}
catch (Exception ee)
{
Response.Write(ee.Message);
}
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string userPwd;
if (txtPswd.Text == "")
{
userPwd = opt.GetSegValue("select password from ht_svr_user where id= '" + txtID.Text + "'", "password");
txtPswd.Text = opt.GetSegValue("select psd from ht_svr_user where id= '" + txtID.Text + "'", "psd");
}
else
{
userPwd = MSYS.Security.Encrypt.GetMD5String(txtPswd.Text);
}
string[] seg = { "ID", "NAME", "WEIGHT", "PARENTID", "MOBILE", "PHONE", "RTXID", "GENDER", "LOGINNAME", "PASSWORD", "EMAIL", "LEVELGROUPID", "IS_LOCAL", "IS_SYNC", "IS_DEL", "DESCRIPTION", "ROLE", "PSD", "TEAM_CODE" };
string[] value = { txtID.Text, txtName.Text, txtWeight.Text, txtPrt.Text, txtPhone.Text, txtCallNO.Text, txtFax.Text, getGender(), txtUser.Text, userPwd, txtEmail.Text, listApt.SelectedValue, Convert.ToInt16(rdLocal.Checked).ToString(), Convert.ToInt16(rdAsyn.Checked).ToString(), "0", txtDscp.Text, listRole.SelectedValue, txtPswd.Text, listTeam.SelectedValue };
string log_message = opt.MergeInto(seg, value, 1, "ht_svr_user") == "Success" ? "修改用户成功" : "修改用户失败";
value[9] = "";
log_message += "--详情：" + string.Join(",", value);
InsertTlog(log_message);
bindData();
ScriptManager.RegisterStartupScript(UpdatePanel1, this.Page.GetType(), "", " $('.shade').fadeOut(200);", true);
}
protected void btnGrid2Save_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (txtCode.Text == "")
{
txtCode.Text = "SC" + System.DateTime.Now.ToString("yyyyMMdd") + (Convert.ToInt16(opt.GetSegValue("select count(ORDER_SN) as ordernum from HT_STRG_COAT where substr(ORDER_SN,1,10) ='SC" + System.DateTime.Now.ToString("yyyyMMdd") + "'", "ordernum")) + 1).ToString().PadLeft(3, '0');
}
foreach (GridViewRow row in GridView2.Rows)
{
string ID = GridView2.DataKeys[row.RowIndex].Value.ToString();
if (ID == "0")
{
ID = opt.GetSegValue("select STRGCOAT_ID_SEQ.nextval as id from dual", "ID");
}
string[] seg = { "ID", "mater_code", "STORAGE", "unit_code", "ORIGINAL_DEMAND", "MAIN_CODE" };
string[] value = { ID, ((TextBox)row.FindControl("txtGridcode")).Text, ((DropDownList)row.FindControl("listGridstrg")).SelectedValue, ((TextBox)row.FindControl("txtGridUnit")).Text, ((TextBox)row.FindControl("txtGridAmount")).Text, txtCode.Text };
string log_message = opt.MergeInto(seg, value, 1, "HT_STRG_COAT_SUB") == "Success" ? "保存原料领退明细成功" : "保存原料领退明细失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
}
//////计算出入库单总各类型总量
DataSet res = opt.CreateDataSetOra("select sum(t.original_demand) as amount ,t.mater_flag from HT_STRG_COAT_SUB t where t.main_code = '" + txtCode.Text + "' group by t.mater_flag");
if (res != null && res.Tables[0].Rows.Count > 0)
{
double CABOSUM = 0, PEICESSUM = 0;
foreach (DataRow row in res.Tables[0].Rows)
{
if (row["mater_flag"].ToString() == "HT")
{
CABOSUM += Convert.ToDouble(row["amount"].ToString());
}
if (row["mater_flag"].ToString() == "LY")
{
PEICESSUM += Convert.ToDouble(row["amount"].ToString());
}
}
txtStemSum.Text = CABOSUM.ToString("0.00");
txtChipSum.Text = PEICESSUM.ToString("0.00");
string[] seg1 = { "ORDER_SN", "CABOSUM", "PEICESSUM" };
string[] value1 = { txtCode.Text, txtStemSum.Text, txtChipSum.Text };
opt.MergeInto(seg1, value1, 1, "HT_STRG_COAT");
}
bindGrid2();
bindGrid1();
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
List <string> commandlist = new List <string>();
string log_message;
if (txtPrdctdate.Text == "" || txtValiddate.Text == "" || listPrdctPlan.SelectedValue == "" || listPrdct.SelectedValue == "" || DropDownListShift.SelectedValue == "" || DropDownListTeam.SelectedValue == "")
{
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "alert", "alert('请输入必要信息!!')", true);
return;
}
//生成领用主表记录
string[] seg = { "ORDER_SN", "OUT_DATE", "EXPIRED_DATE", "MODIFY_TIME", "WARE_HOUSE_ID", "DEPT_ID", "CREATOR_ID", "MONTHPLANNO", "BATCHNUM", "STRG_TYPE", "team_code", "shift_code" };
string[] value = { txtCode.Text, txtPrdctdate.Text, txtValiddate.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listStorage.SelectedValue, listApt.SelectedValue, listCreator.SelectedValue, listPrdctPlan.SelectedValue, txtBatchNum.Text, "0", DropDownListTeam.SelectedValue.ToString(), DropDownListShift.SelectedValue.ToString() };
commandlist.Add(opt.getMergeStr(seg, value, 1, "HT_STRG_COAT"));
commandlist.Add("delete from HT_STRG_COAT_SUB where MAIN_CODE = '" + txtCode.Text + "'");
//根据生产计划对应的配方明细生成原料领用明细
// commandlist.Add("insert into HT_STRG_COAT_SUB select '' as ID, g3.mater_code as MATER_CODE,g4.data_origin_flag as STORAGE,g3.batch_num*" + txtBatchNum.Text + " as ORIGINAL_DEMAND, '' as REAL_DEMAND,'' as Remark,g4.unit_code as UNIT_CODE , '0' as IS_DEL,g3.coat_flag as mater_flag,'" + txtCode.Text + "' as MAIN_CODE,'' as PACKNUM ,'' as SUBSTANCE, '' as ODDQTY ,g3.CLASS_NAME as cls_code from ht_prod_month_plan_detail g1 left join ht_pub_prod_design g2 on g1.prod_code = g2.prod_code left join HT_QA_COAT_FORMULA_detail g3 on g3.formula_code = g2.COAT_FORMULA_CODE and g3.is_del = '0' left join ht_pub_materiel g4 on g4.material_code = g3.mater_code where g1.plan_no = '" + listPrdctPlan.SelectedValue + "' and g3.mater_code is not null");
//commandlist.Add("insert into HT_STRG_COAT_SUB select '' as ID, g3.mater_code as MATER_CODE,g4.data_origin_flag as STORAGE,g3.batch_num*" + txtBatchNum.Text + " as ORIGINAL_DEMAND, '' as REAL_DEMAND,'' as Remark,g4.unit_code as UNIT_CODE , '0' as IS_DEL,g3.coat_flag as mater_flag,'" + txtCode.Text.Trim() + "' as MAIN_CODE,'' as PACKNUM ,'' as SUBSTANCE, '' as ODDQTY , '' as cls_code, '' as REMNANT, ''as PIECE_NUM from ht_prod_month_plan_detail g1 left join ht_pub_prod_design g2 on g1.prod_code = g2.prod_code left join HT_QA_COAT_FORMULA_detail g3 on g3.formula_code = g2.COAT_FORMULA_CODE and g3.is_del = '0' left join ht_pub_materiel g4 on g4.material_code = g3.mater_code where g1.plan_no = '" + listPrdctPlan.SelectedValue + "' and g3.mater_code is not null");
commandlist.Add("insert into HT_STRG_COAT_SUB select '' as ID, g3.mater_code as MATER_CODE,g4.data_origin_flag as STORAGE,g3.batch_num*1 as ORIGINAL_DEMAND, '' as REAL_DEMAND,'' as Remark,g4.unit_code as UNIT_CODE , '0' as IS_DEL,g3.coat_flag as mater_flag,'" + txtCode.Text.Trim() + "' as MAIN_CODE,'' as PACKNUM ,'' as SUBSTANCE, '' as ODDQTY , '' as cls_code, '' as REMNANT, ''as PIECE_NUM from ht_prod_month_plan_detail g1 left join ht_pub_prod_design g2 on g1.prod_code = g2.prod_code left join HT_QA_COAT_FORMULA_detail g3 on g3.formula_code = g2.COAT_FORMULA_CODE and g3.is_del = '0' left join ht_pub_materiel g4 on g4.material_code = g3.mater_code where g1.plan_no = '" + listPrdctPlan.SelectedValue + "' and g3.mater_code is not null");
log_message = opt.TransactionCommand(commandlist) == "Success" ? "生成原料领用主表记录成功" : "生成原料领用主表记录失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
//////计算出入库单总各类型总量
DataSet res = opt.CreateDataSetOra("select sum(t.original_demand) as amount ,t.mater_flag from HT_STRG_COAT_SUB t where t.main_code = '" + txtCode.Text + "' group by t.mater_flag");
if (res != null && res.Tables[0].Rows.Count > 0)
{
double CABOSUM = 0, PEICESSUM = 0;
foreach (DataRow row in res.Tables[0].Rows)
{
if (row["mater_flag"].ToString() == "HT")
{
if (row["amount"].ToString() != "")
{
CABOSUM += Convert.ToDouble(row["amount"].ToString());
}
}
if (row["mater_flag"].ToString() == "LY")
{
if (row["amount"].ToString() != "")
{
PEICESSUM += Convert.ToDouble(row["amount"].ToString());
}
}
}
txtStemSum.Text = CABOSUM.ToString("0.00");
txtChipSum.Text = PEICESSUM.ToString("0.00");
string[] seg1 = { "ORDER_SN", "CABOSUM", "PEICESSUM" };
string[] value1 = { txtCode.Text, txtStemSum.Text, txtChipSum.Text };
opt.MergeInto(seg1, value1, 1, "HT_STRG_COAT");
}
bindGrid1();
bindGrid2();
}
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();
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
{
string[] seg = { "PROCESS_CODE", "PROCESS_NAME", "REMARK", "IS_VALID", "CREATE_ID", "CREATE_TIME" };
string[] value = { txtCode.Text, txtName.Text, txtDscrp.Text, Convert.ToInt16(rdValid.Checked).ToString(), ((MSYS.Data.SysUser)Session["user"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") };
opt.MergeInto(seg, value, 1, "HT_PUB_INSPECT_PROCESS");
}
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (txtCode.Text.Length == 10 && txtCode.Text.Substring(0, 5) == listSection.SelectedValue)
{
string oldepath = opt.GetSegValue("select * from HT_PUB_TECH_PARA where PARA_CODE = '" + txtCode.Text + "'", "PATH_NODE");
string[] seg = { "PARA_CODE", "PARA_NAME", "PARA_UNIT", "PARA_TYPE", "REMARK", "IS_VALID", "CREATE_ID", "CREATE_TIME", "EQUIP_CODE", "SET_TAG", "VALUE_TAG", "BUSS_ID", "PATH_NODE" };
string[] value = { txtCode.Text, txtName.Text, txtUnit.Text, getType(), txtDscrp.Text, Convert.ToInt16(rdValid.Checked).ToString(), ((MSYS.Data.SysUser)Session["User"]).id, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listEquip.SelectedValue, txtSetTag.Text, txtValueTag.Text, listApt.SelectedValue, listPathnode.SelectedValue };
string log_message;
if (opt.MergeInto(seg, value, 1, "HT_PUB_TECH_PARA") == "Success")
{
log_message = "保存参数点成功";
tvHtml = InitTree();
string[] procseg = { };
object[] procvalues = { };
opt.ExecProcedures("Create_Online_month_Report", procseg, procvalues);
if (ckQuaAnalyze.Checked && oldepath != listPathnode.SelectedValue)
{
DataSet points = opt.CreateDataSetOra("select distinct path_code,path_name from ht_pub_para_weight t ");
if (points != null && points.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in points.Tables[0].Rows)
{
if (listPathnode.SelectedValue == "")
{
opt.UpDateOra("insert into ht_pub_para_weight(para_code,path_code,weight,path_name)values ('" + txtCode.Text + "','" + row["path_code"].ToString() + "','0.2','" + row["path_name"].ToString() + "')");
}
else
{
DataSet paras = opt.CreateDataSetOra("select r.para_code,t.pathcode from ht_pub_path_prod t left join ht_pub_path_node s on s.is_del = '0' and s.section_code = t.section_code and substr(t.section_path,s.orders,1) = '0' left join ht_pub_tech_para r on r.path_node = s.id and r.is_del = '0' and r.para_type like '______1%' where t.pathcode = '" + row["path_code"].ToString() + "' and t.is_del = '0' and r.para_code = '" + txtCode.Text + "'");
if (paras != null && paras.Tables[0].Rows.Count > 0)
{
opt.UpDateOra("delete from ht_pub_para_weight where para_code = '" + txtCode.Text + "' and path_code = '" + row["path_code"].ToString() + "'");
}
}
}
}
}
// opt.UpDateOra("delete from ht_pub_para_weight where PATH_CODE = '" + listPathAll.SelectedValue + "'");
// opt.UpDateOra("insert into ht_pub_para_weight ( select r.para_code,t.pathcode,'0',0.2,'test1' from ht_pub_path_prod t left join ht_pub_path_node s on s.is_del = '0' and s.section_code = t.section_code and substr(t.section_path,s.orders,1) = '1' left join ht_pub_tech_para r on r.path_node = s.id and r.is_del = '0' and r.para_type like '______1%' where t.pathcode = '" + listPathAll.SelectedValue + "' and t.is_del = '0' and r.para_code is not null union select r.para_code,'" + listPathAll.SelectedValue + "','0',0.2,'test1' from ht_pub_tech_para r where r.para_type like '______1%' and r.path_node is null and r.is_del = '0')");
}
else
{
log_message = "保存参数点失败";
}
log_message += "--数据详情:" + string.Join(",", value);
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "sucess", "initTree();alert('" + log_message + "');", true);
InsertTlog(log_message);
}
else
{
ScriptManager.RegisterStartupScript(UpdatePanel4, this.Page.GetType(), "message", "alert('请确认工艺参数所属工艺段是否正确')", true);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
foreach (GridViewRow row in GridView3.Rows)
{
string[] seg = { "ID", "FIRST", "SECOND", "THIRD" };
string[] value = { ((TextBox)row.FindControl("txtOrder")).Text, ((DropDownList)row.FindControl("listTeam1")).Text, ((DropDownList)row.FindControl("listTeam2")).Text, ((DropDownList)row.FindControl("listTeam3")).Text };
opt.MergeInto(seg, value, 1, "ht_inner_team_schedule");
}
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "PROD_CODE", "PROD_NAME", "PACK_NAME", "HAND_MODE", "TECH_STDD_CODE", "MATER_FORMULA_CODE", "FLA_FORMULA_CODE", "COAT_FORMULA_CODE", "QLT_CODE", "INSPECT_STDD", "SENSOR_SCORE", "REMARK", "CREATE_TIME", "PATH_CODE" };
string[] value = { txtCode.Text, txtName.Text, txtPack.Text, listType.SelectedValue, listTechStd.SelectedValue, listMtrl.SelectedValue, listFla.SelectedValue, listcoat.SelectedValue, listqlt.SelectedValue, listisp.SelectedValue, txtValue.Text, txtDscpt.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), listPathAll.SelectedValue };
string log_message = opt.MergeInto(seg, value, 1, "HT_PUB_PROD_DESIGN") == "Success" ? "保存产品信息成功," : "保存产品信息失败,";
log_message += ",产品信息：" + string.Join(",", value);
InsertTlog(log_message);
bindGrid();
ScriptManager.RegisterStartupScript(UpdatePanel2, this.Page.GetType(), "", " $('.shade').fadeOut(100);", true);
}
protected void btnSave_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView1.Rows)
{
string[] seg = { "INSPECT_CODE", "PROD_CODE", "TEAM_ID", "RECORD_TIME", "SHIFT_ID", "INSPECT_VALUE", "CREAT_ID", "CREATE_TIME" };
string[] value = { GridView1.DataKeys[row.RowIndex].Value.ToString(), listProd.SelectedValue, listTeam.SelectedValue, txtProdTime.Text, listShift.SelectedValue, ((TextBox)row.FindControl("txtPara")).Text, listEditor.SelectedValue, 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, 4, "HT_QLT_INSPECT_RECORD") == "Success" ? "保存过程检测结果成功" : "保存过程检测结果失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
}
}
protected void btnGrid2Save_Click(object sender, EventArgs e)
{
try
{
Button btn = (Button)sender;
GridViewRow row = (GridViewRow)btn.NamingContainer;
int Rowindex = row.RowIndex;//获得行号
string mtr_code = GridView2.DataKeys[Rowindex].Value.ToString();
if (!Regex.IsMatch(hidePlanID.Value, @"^[+-]?/d*$"))
{
hidePlanID.Value = hidePlanID.Value.Substring(hidePlanID.Value.LastIndexOf(',') + 1);
}
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string log_message;
if (!(((TextBox)row.FindControl("txtAmount1")).Text == "" && ((TextBox)row.FindControl("txtAmount2")).Text == "" && ((TextBox)row.FindControl("txtAmount3")).Text == ""))
{
if (((TextBox)row.FindControl("txtAmount1")).Text == "")
{
((TextBox)row.FindControl("txtAmount1")).Text = "0";
}
if (((TextBox)row.FindControl("txtAmount2")).Text == "")
{
((TextBox)row.FindControl("txtAmount2")).Text = "0";
}
if (((TextBox)row.FindControl("txtAmount3")).Text == "")
{
((TextBox)row.FindControl("txtAmount3")).Text = "0";
}
((TextBox)row.FindControl("txtOutput")).Text = (Convert.ToDouble(((TextBox)row.FindControl("txtAmount1")).Text) + Convert.ToDouble(((TextBox)row.FindControl("txtAmount2")).Text) + Convert.ToDouble(((TextBox)row.FindControl("txtAmount3")).Text)).ToString("0.000");
string[] seg = { "QUARTER_PLAN_ID", "ID", "prod_code", "TOTAL_OUTPUT", "plan_output_1", "plan_output_2", "plan_output_3", "IS_DEL", "IS_VALID" };
string[] value = { hidePlanID.Value, GridView2.DataKeys[row.RowIndex].Value.ToString(), ((DropDownList)row.FindControl("listProd")).SelectedValue, ((TextBox)row.FindControl("txtOutput")).Text, ((TextBox)row.FindControl("txtAmount1")).Text, ((TextBox)row.FindControl("txtAmount2")).Text, ((TextBox)row.FindControl("txtAmount3")).Text, "0", "1" };
log_message = opt.MergeInto(seg, value, 2, "ht_prod_season_plan_Detail") == "Success" ? "保存季度生产计划明细成功" : "保存季度生产计划明细失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
if (hideAdjust.Value == "1")
{
opt.UpDateOra("update HT_PROD_SEASON_PLAN set ADJUST_STATUS = '1',MODIFY_ID = '" + ((MSYS.Data.SysUser)Session["User"]).id + "' where ID = '" + hidePlanID.Value + "'");
}
}
bindGrid2(hidePlanID.Value);
bindGrid1();
}
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 = { "F_CODE", "F_NAME", "F_PARENTID", "F_PRITYPE", "F_WEIGHT", "F_KEY", "F_ROLE" };
string[] value = { txtCode.Text, txtName.Text, listParent.SelectedValue, txtType.Text, txtWeight.Text, txtSapID.Text, listRole.SelectedValue };
string log_message = opt.MergeInto(seg, value, 1, "HT_SVR_ORG_GROUP") == "Success" ? "保存部门信息成功" : "保存部门信息失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
bindData();
ScriptManager.RegisterStartupScript(updtpanel1, this.Page.GetType(), "", " $('.shade').fadeOut(200);", true);
}
protected void btnSaveS_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
string[] seg = { "SHIFT_CODE", "SHIFT_NAME", "WORKSHOP_ID", "BEGIN_TIME", "END_TIME", "CREATE_TIME", "INTER_DAY", "IS_DEL" };
string[] value = { txtCodeS.Text, txtNameS.Text, listLineS.SelectedValue, txtStarttime.Text, txtEndtime.Text, System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Convert.ToInt16(ckInter.Checked).ToString(), "0" };
string log_message = opt.MergeInto(seg, value, 1, "ht_sys_shift") == "Success" ? "班时配置保存成功" : "班时配置保存失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
bindGrid2();
}
protected void btnModify_Click(object sender, EventArgs e)
{
MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator();
if (hdType.Value == "1")
{
string[] seg = { "RECORD_ID", "SORT", "STATUS", "REASON", "SCENE", "DEAL", "REMARK" };
string[] value = { txtEventID.Text, listStyle.SelectedValue, "3", txtReason.Text, txtScean.Text, txtDeal.Text, txtPlus.Text };
string log_message = opt.MergeInto(seg, value, 2, "HT_QLT_AUTO_EVENT") == "Success" ? "处理工艺质量事件成功" : "处理工艺质量事件失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
bindgrid1();
}
else
{
string[] seg = { "RECORD_ID", "INSPECT_CODE", "STATUS", "REASON", "SCENE", "DEAL", "REMARK" };
string[] value = { txtEventID.Text, listStyle.SelectedValue, "3", txtReason.Text, txtScean.Text, txtDeal.Text, txtPlus.Text };
string log_message = opt.MergeInto(seg, value, 1, "HT_QLT_INSPECT_EVENT") == "Success" ? "处理工艺质量事件成功" : "处理工艺质量事件失败";
log_message += "--详情:" + string.Join(",", value);
InsertTlog(log_message);
bindgrid2();
}
ScriptManager.RegisterStartupScript(updtpanel1, this.Page.GetType(), "", " $('.shade').fadeOut(200);", true);
}
