protected void Page_Load(object sender, EventArgs e)
{
_lotno = Request.QueryString["lotno"].ToString();
_para = Request.QueryString["para"].ToString();
if (Request.QueryString["workshop"] != null)
{
_workshop = Request.QueryString["workshop"].ToString();
}
if (Request.QueryString["needno"] != null)
{
_needno = Request.QueryString["needno"].ToString();
}
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
_emp = lu.WorkCode + lu.UserName;
//_emp = "02432何桂勤";
GetData(_lotno, lu.WorkCode);
}
protected void btnStart_Click(object sender, EventArgs e)
{
MES.Model.MES_SB_WX m = new MES.Model.MES_SB_WX();
string wx_dh = Request["dh"];
//txtHidden.Value = wx_dh;
m.wx_dh = wx_dh;
m.wx_begin_date = DateTime.Now;
m.wx_banbie = ""; //txtBanBie.Value;
m.wx_banzhu = ""; //txtBanZu.Value;
m.wx_gonghao = WeiXin.GetCookie("workcode"); //dropWXGongHao.SelectedValue;
m.wx_name = ((LoginUser)WeiXin.GetJsonCookie()).UserName;
m.p_status = "维修中";
MES.DAL.MES_SB_WX dal = new MES.DAL.MES_SB_WX();
try
{
if (DbHelperSQL.GetSingle("select count(1) from MES.[dbo].[MES_SB_wx] where wx_dh='" + wx_dh + "'").ToString() == "0")
{
int result = dal.Add(m);//因经常出现资料未插入事件
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", @"alert('接修成功.');self.location='BXMonitor.aspx'; ", true);
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", @"layer.alert('失败，请重试.[ex:" + ex.Message + "]'); ", true);
}
finally { }
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
_workorder = Request.QueryString["workorder"].ToString();
_workorder_f = Request.QueryString["workorder_f"].ToString();
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
emp_code_name.Text = lu.WorkCode + lu.UserName;
domain.Text = lu.Domain;
//emp_code_name.Text = "02432何桂勤";
//domain.Text = "200";
workorder.Text = _workorder; workorder_f.Text = _workorder_f;
init_data(_workorder, _workorder_f);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["formno"] != null)
{
_formno = Request.QueryString["formno"].ToString();
}
if (Request.QueryString["stepid"] != null)
{
_stepid = Request.QueryString["stepid"].ToString();
}
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
emp_code_name.Text = lu.WorkCode + lu.UserName;
//emp_code_name.Text = "02432何桂勤";
formno.Text = _formno; stepid.Text = _stepid;
if (_formno != "")
{
init_data(_formno, _stepid);
}
}
}
public string uri; //url
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
emp_code_name.Text = lu.WorkCode + lu.UserName;
//emp_code_name.Text = "02432何桂勤";
bind_pgino();
bind_source("");
timestamp = DateTime.Now.Ticks.ToString().Substring(0, 10);
noncestr = new Random().Next(10000).ToString();
uri = Request.Url.ToString().Replace("#", "").Replace(WeiXin.Port, ""); //本地地址
string entAccessTicket = WeiXin.GetEntAccessToken(); //企业AccessTicket
ent_ticket = WeiXin.GetEntJsapi_Ticket(entAccessTicket);
ent_signature = WeiXin.GetSignature(ent_ticket, noncestr, timestamp, uri); //企业签名
}
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString(); // "四车间";
_dh = Request.QueryString["dh"].ToString(); //"W1497589";
dt_append = new DataTable();
dt_append.Columns.Add("sku");
dt_append.Columns.Add("lot_no");
dt_append.Columns.Add("need_off_qty");
dt_append.Columns.Add("need_no");
dt_append.Columns.Add("idno");
dt_append.Columns.Add("ps_qty_per");
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
ViewState["STEPVALUE"] = "";
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
txt_emp.Text = lu.WorkCode;
txt_dh.Text = _dh;
ShowValue(txt_emp.Text);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
wxuserid.Text = WeiXin.GetCookie("userid");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["workshop"] != null)
{
_workshop = Request.QueryString["workshop"].ToString();
}
if (Request.QueryString["dh"] != null)
{
_dh = Request.QueryString["dh"].ToString();
}
if (Request.QueryString["ck"] != null)
{
_ck = Request.QueryString["ck"].ToString();
}
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
emp_code_name.Text = lu.WorkCode + lu.UserName;
//emp_code_name.Text = "02432何桂勤";
}
GetData();
}
protected void Page_Load(object sender, EventArgs e)
{
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
GetData();
}
protected void Page_Load(object sender, EventArgs e)
{
/*
* string year = DateTime.Now.Year.ToString();
* string month = DateTime.Now.Month.ToString();
* string day = DateTime.Now.Day.ToString();
*
* string dn = "白班";
* DateTime t1 = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss"));
* DateTime t2 = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd") + " 07:00:00");
* DateTime t3 = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd") + " 19:00:00");
*
* if (DateTime.Compare(t1, t2) >= 0 && DateTime.Compare(t1, t3) <= 0)
* {
* dn = "白班";
* }
* else
* {
* dn = "夜班";
* }
*
* file = Server.MapPath(@"/file/" + year + @"/" + month + @"月/" + month + "-" + day + dn + @"/");
*/
file = Server.MapPath(@"/file/");
if (Request.QueryString["id"] != null)
{
_id = Request.QueryString["id"].ToString();
}
if (Request.QueryString["dh"] != null)
{
_dh = Request.QueryString["dh"].ToString();
} //扫码进来的
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
emp_code_name.Text = lu.WorkCode + lu.UserName;
domain.Text = lu.Domain;
//emp_code_name.Text = "02432何桂勤";
domain.Text = "200";
txt_dh.Text = _dh;
id.Text = _id;
if (_id != "" || _dh != "")
{
init_data(_id, _dh, connString);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
TraceByDH(Request.QueryString["dh"].ToString());
}
protected void ResetCookie()
{
if (WeiXin.GetCookie("cookiedate") != "")
{
var date = Convert.ToDateTime(WeiXin.GetCookie("cookiedate"));
if (date.AddDays(1) < DateTime.Now)
{
WeiXin.delCookies("userid");
WeiXin.delCookies("workcode");
WeiXin.delCookies("usermodel");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
txt_empname.Value = lu.WorkCode + lu.UserName;
// txt_empname.Value = "01744孙娟";
bind_sb();
}
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
GetData(lu.WorkCode);
//GetData("02432");
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
//if (!IsPostBack)
//{
GetData();
//}
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
emp_code_name.Text = lu.WorkCode + lu.UserName;
domain.Text = lu.Domain;
//登入岗位的域
string strsql_d = "select * from [Mes_App_EmployeeLogin] with(readpast) where emp_code='" + lu.WorkCode + "' and on_date is not null and off_date is null";
var value_login = SQLHelper.reDs(strsql_d).Tables[0];
if (value_login != null && value_login.Rows.Count > 0)
{
if (domain.Text == "100" || domain.Text == "")
{
domain.Text = value_login.Rows[0]["domain"].ToString();
}
}
lbl_emp.Text = lu.Telephone + lu.UserName;
if (string.IsNullOrEmpty(lu.Telephone)) //增加手机号的获取，因为cookIE里的手机号有可能会是空值
{
string strsql = "select * from [172.16.5.26].[Production].[dbo].[Hrm_Emp] with(nolock) where employeeid = '" + lu.WorkCode + "'";
var value_rout = SQLHelper.reDs(strsql).Tables[0];
if (value_rout != null && value_rout.Rows.Count > 0)
{
lbl_emp.Text = value_rout.Rows[0]["tel"].ToString() + lu.UserName;
}
}
//emp_code_name.Text = "02432何桂勤";
//domain.Text = "200";
//lbl_emp.Text = "15850349106何桂勤";
//绑定岗位
ShowValue(lu.WorkCode);
//ShowValue("02432");
}
}
//已完成确认
public void BindWanChengmy(string strWhere = "")
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select bx_date, bx_banbie, bx_gonghao, bx_name, bx_banzhu, bx_dh, bx_moju_no, bx_moju_type, bx_part, bx_mo_no, bx_gz_type, bx_gz_desc, bx_sbno, bx_sbname, status,level,b.cellphone,moju_repair ");
//strSql.Append(" ,cast(datediff(mi,bx_date,getdate())/60 as varchar)+'小时 '+right('00'+cast(datediff(mi,bx_date,getdate())%60 as varchar),2)+' 分' bx_shichang ");
strSql.Append(" ,cast(cast(datediff(ss, bx_date, qr_date) / 3600 as int) as varchar)+':'+right('00' + cast(cast(datediff(ss, bx_date, qr_date) % 3600 / 60 as int) as varchar), 2) bx_shichang ");
//strSql.Append(" ,(select top 1 product_leibie from form3_Sale_Product_MainTable where pgino =(select left(xmh,5) from [172.16.5.6].report.dbo.MoJu where mojuno= bx_moju_no) ) as pd_type ");
strSql.Append(" FROM mes.dbo.MES_SB_BX a join mes.dbo.MES_SB_QR c on a.bx_dh=c.dh join mes.dbo.mes_sb_wx d on a.bx_dh=d.wx_dh join [172.16.5.6].[eHR_DB].dbo.view_hr_emp b on b.employeeid=a.bx_gonghao where dateadd(hh,24,qr_date )>getdate() ");
strSql.Append(" and status = '确认完成' and ( bx_gonghao='" + WeiXin.GetCookie("workcode") + "' or wx_gonghao='" + WeiXin.GetCookie("workcode") + "' or c.qr_gh='" + WeiXin.GetCookie("workcode") + "' ) order by a.id asc");
DataSet ds = DbHelperSQL.Query(strSql.ToString());
listWCmy.DataSource = ds;
listWCmy.DataBind();
}
//入库完成
private void BindData5()
{
string sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "二车间", WeiXin.GetCookie("workcode"), 5);
DataTable dt_data_end_2 = SQLHelper.Query(sql).Tables[0];
ViewState["dt_data_end_2"] = dt_data_end_2;
sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "三车间", WeiXin.GetCookie("workcode"), 5);
DataTable dt_data_end_3 = SQLHelper.Query(sql).Tables[0];
ViewState["dt_data_end_3"] = dt_data_end_3;
sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "四车间", WeiXin.GetCookie("workcode"), 5);
DataTable dt_data_end_4 = SQLHelper.Query(sql).Tables[0];
ViewState["dt_data_end_4"] = dt_data_end_4;
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
//调整中
BindData1();
//检测中
BindData2();
//检测结果待确认
BindData3();
//换夹完成（30天内）
BindData4();
}
protected void Page_Load(object sender, EventArgs e)
{
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
emp_code_name.Text = lu.WorkCode + lu.UserName;
domain.Text = lu.Domain;
//emp_code_name.Text = "02432何桂勤";
domain.Text = "200";
}
}
public static string ruku_Data()
{
string go = "0", end = "0", go_bhg = "0", end_bhg = "0";
//待入库
string sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "二车间", WeiXin.GetCookie("workcode"), 4);
DataTable dt_data_2 = SQLHelper.Query(sql).Tables[0];
sql = sql = string.Format(@"exec [usp_app_YZ_monitor] '{0}','{1}',{2}", "三车间", WeiXin.GetCookie("workcode"), 4);
DataTable dt_data_3 = SQLHelper.Query(sql).Tables[0];
sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "四车间", WeiXin.GetCookie("workcode"), 4);
DataTable dt_data_4 = SQLHelper.Query(sql).Tables[0];
go = (dt_data_2.Rows.Count + dt_data_3.Rows.Count + dt_data_4.Rows.Count).ToString();
//入库完成
sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "二车间", WeiXin.GetCookie("workcode"), 5);
DataTable dt_data_end_2 = SQLHelper.Query(sql).Tables[0];
sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "三车间", WeiXin.GetCookie("workcode"), 5);
DataTable dt_data_end_3 = SQLHelper.Query(sql).Tables[0];
sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "四车间", WeiXin.GetCookie("workcode"), 5);
DataTable dt_data_end_4 = SQLHelper.Query(sql).Tables[0];
end = (dt_data_end_2.Rows.Count + dt_data_end_3.Rows.Count + dt_data_end_4.Rows.Count).ToString();
//不合格
sql = @"exec [usp_app_bhgp_Apply_list_dv_V1_New] '','','','ruku'";
DataSet ds = SQLHelper.Query(sql);
DataTable dt_98_2 = ds.Tables[0]; DataTable dt_98_3 = ds.Tables[1]; DataTable dt_98_4 = ds.Tables[2];
DataTable dt_99_2 = ds.Tables[3]; DataTable dt_99_3 = ds.Tables[4]; DataTable dt_99_4 = ds.Tables[5];
//不合格待入库
go_bhg = (dt_98_2.Rows.Count + dt_98_3.Rows.Count + dt_98_4.Rows.Count).ToString();
//不合格已入库
end_bhg = (dt_99_2.Rows.Count + dt_99_3.Rows.Count + dt_99_4.Rows.Count).ToString();
string res = "[{\"go\":\"" + go + "\",\"end\":\"" + end + "\",\"go_bhg\":\"" + go_bhg + "\",\"end_bhg\":\"" + end_bhg + "\"}]";
return(res);
}
protected void Page_Load(object sender, EventArgs e)
{
//_workshop = Request.QueryString["workshop"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
// ---------0:申请中 1:待检中 2:检测中 3:待取用 9:完成(24Hour)
//申请中
BindData1();
//1:待检中
BindData2();
//检测中
BindData3();
//3:待取用
BindData4();
//9:完成(24Hour)
BindData9();
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
//生产中
// BindData1();
//待终检
BindData2();
//待GP12
BindData3();
//待入库
BindData4();
//入库完成24小时
//BindData5();
}
private void setVisibleState(string status, string dh, string level)
{
string workcode = WeiXin.GetCookie("workcode");
if (status == "报修完成")
{
enableBtn(true, false, false);
VisibleBtn(true, false, false);
}
else if (status == "维修中")
{
BindWX(dh);
enableBtn(false, true, false);
VisibleBtn(false, true, false);
string script = "$('#PageWX').removeAttr('hidden'); ";
ClientScript.RegisterStartupScript(this.GetType(), "show", script, true);
}
else if (status == "维修完成")
{
//DataTable dt = fun.Get_WX_Record(gv.Cells[1].Text);
//txtWX_CS.Value = dt.Rows[0]["wx_cs"].ToString();
//dropResult.Text = dt.Rows[0]["wx_result"].ToString();
//txtMo_Down_cs.Value = dt.Rows[0]["mo_down_cs"].ToString();
BindWX(dh);
enableBtn(false, false, true);
VisibleBtn(false, false, true);
string script = "$('#PageWX').removeAttr('hidden');$('#PageQR').removeAttr('hidden');";
ClientScript.RegisterStartupScript(this.GetType(), "show", script, true);
}
else if (status == "确认完成")
{
BindWX(dh);
BindQR(dh);
string script = "$('#PageWX').removeAttr('hidden');$('#PageQR').removeAttr('hidden');";
ClientScript.RegisterStartupScript(this.GetType(), "show", script, true);
enableBtn(false, false, false);
VisibleBtn(false, false, false);
}
SetRole(workcode, level);
}
protected void Page_Load(object sender, EventArgs e)
{
_workorder = Request.QueryString["workorder"].ToString();
_ruku_dh = Request.QueryString["ruku_dh"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
emp_code_name.Text = lu.WorkCode + lu.UserName;
//emp_code_name.Text = "02432何桂勤";
emp.Text = emp_code_name.Text;
time.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm");
}
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = Request.QueryString["workshop"].ToString();
_lotno = Request.QueryString["lotno"].ToString();
_needno = Request.QueryString["need_no"].ToString();
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
_emp = lu.WorkCode + lu.UserName;
load_data(lu.WorkCode);
}
}
//待GP12
private void BindData3()
{
string sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "二车间", WeiXin.GetCookie("workcode"), 3);
DataSet ds = SQLHelper.Query(sql);
DataTable dt_data = ds.Tables[0];
ViewState["dt_data_gp2"] = dt_data;
sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "三车间", WeiXin.GetCookie("workcode"), 3);
ds = SQLHelper.Query(sql);
dt_data = ds.Tables[0];
ViewState["dt_data_gp3"] = dt_data;
sql = string.Format(@"exec [usp_app_wip_list_Qcc] '{0}','{1}',{2}", "四车间", WeiXin.GetCookie("workcode"), 3);
ds = SQLHelper.Query(sql);
dt_data = ds.Tables[0];
ViewState["dt_data_gp4"] = dt_data;
}
protected void Page_Load(object sender, EventArgs e)
{
_workshop = "四车间"; // Request.QueryString["workshop"].ToString(); // "四车间";//
_dh = "G0051234"; // Request.QueryString["dh"].ToString();// "W0000456";
// lotno = "G0000301";
//_dh = "W0000450";
dt_append = new DataTable();
dt_append.Columns.Add("pgino");
dt_append.Columns.Add("workorder");
dt_append.Columns.Add("need_off_qty");
//dt_append.Columns.Add("need_no");
dt_append.Columns.Add("idno");
if (WeiXin.GetCookie("workcode") == null)
{
Response.Write("<script>layer.alert('登入信息过期，请退出程序重新进入。');window.history.back();location.reload();</script>");
return;
}
string strsql = @"select pgino,emp_name,hege_qty,create_date,qc_dh from Mes_App_WorkOrder_QC_History where qc_dh = '{0}'
UNION ALL
select pgino,emp_name,-1*act_qty,create_date,workorder from Mes_APP_WorkOrder_CKCK_Hege where reason ='成品领用' AND workorder='{0}'" ;
strsql = string.Format(strsql, _dh);
DataTable re_dt = SQLHelper.Query(strsql).Tables[0];
if (re_dt.Rows.Count > 0)
{
Repeater_record.DataSource = re_dt;
Repeater_record.DataBind();
}
if (!IsPostBack)
{
LoginUser lu = (LoginUser)WeiXin.GetJsonCookie();
txt_emp.Text = lu.WorkCode;
txt_dh.Text = _dh;
ViewState["STEPVALUE"] = "";
}
}
protected void list_go_my_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
Repeater detail = (Repeater)e.Item.FindControl("re_go_my");
var item = (string)e.Item.DataItem;
var line = item;//item["line"].ToString();
DataTable dt_all = ViewState["dt_all"] as DataTable;
//var dt_wk = dt_all.Clone();
//dt_wk.Rows.Add( dt_all.Select("line='" + line + "'"));
dt_all.DefaultView.RowFilter = "line='" + line + "' and emp_code='" + WeiXin.GetCookie("workcode") + "'";
dt_all.DefaultView.Sort = "on_date asc";
//string sql = @"exec [usp_app_emp_login_list_dv] '{0}','{1}'";
//sql = string.Format(sql, _workshop, item["line"].ToString());
//dt_wk = SQLHelper.Query(sql).Tables[0];
detail.DataSource = dt_all;
detail.DataBind();
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
MES.Model.MES_SB_QR m = new MES.Model.MES_SB_QR();
string wx_dh = Request["dh"];// GridView1.SelectedRow.Cells[1].Text.Trim();
m.dh = wx_dh;
m.qr_date = DateTime.Now;
m.qr_banbie = ""; // txtBanBie.Value;
m.qr_banzhu = ""; // txtBanZu.Value;
m.qr_gh = WeiXin.GetCookie("workcode");
m.qr_name = ((LoginUser)WeiXin.GetJsonCookie()).UserName;
m.qr_remark = this.txtQr_Remark.Value;
m.p_status = "确认完成";
MES.DAL.MES_SB_WX dal = new MES.DAL.MES_SB_WX();
if (dal.IsExitsQR(m.dh) == 0)//--确认是否重复确认
{
dal.Add(m);
}
string strSQL = "update MES_SB_BX set [status]='" + m.p_status + "' where bx_dh='" + m.dh + "';";
DbHelperSQL.ExecuteSql(strSQL);//因经常会无法更新到状态，固在此重复更新一次
strSQL = "SELECT wx_result FROM MES_SB_WX WHERE wx_dh='" + wx_dh + "' ";
DataTable tbl = DbHelperSQL.Query(strSQL).Tables[0];
if (tbl.Rows[0][0].ToString() == "需下模维修")
{
string str = "alert('维修结果为：需下模维修，请至电脑端进换模页面进行维护信息.');self.location='BXMonitor.aspx';";
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", str, true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('确认成功.');self.location='BXMonitor.aspx';", true);
}
}
