protected void initial() { sqltext = "select a.Id,Marid,NUMBER,b.MNAME as Name,b.GUIGE,b.Caizhi,Length,Width,Weight,TUXING from TBWS_YULIAO_RESTORE as a left join TBMA_MATERIAL as b on a.Marid=b.ID where a.STATE='1'"; DBCallCommon.BindGridView(GridView1, sqltext); sqltext = "update TBWS_YULIAO_RESTORE set STATE='0'"; DBCallCommon.ExeSqlText(sqltext); }
//初始化页面 private void InitInfo() { string action = Request.QueryString["action"]; string[] fields = action.Split(' '); string engid = fields[0].ToString(); string tablename = fields[1].ToString(); //sqlText = "select temp1.MP_PID,temp1.MP_MARID,temp1.MP_NAME,temp1.MP_GUIGE,temp1.MP_CAIZHI,temp1.MP_UNIT,"; //sqlText += "temp1.MP_STANDARD,temp1.MP_KEYCOMS,temp1.MP_WEIGHT-isnull(temp2.MP_WEIGHT,0) AS MP_WEIGHT,"; //sqlText += "temp1.MP_NUMBER-isnull(temp2.MP_NUMBER,0) AS MP_NUMBER,temp1.MP_USAGE,"; //sqlText += "temp1.MP_TYPE,temp1.MP_TIMERQ,temp1.MP_ENVREFFCT,temp1.MP_NOTE FROM "; //sqlText += "(select MP_PID,MP_MARID,MP_NAME,MP_GUIGE,MP_CAIZHI,MP_UNIT,MP_STANDARD,MP_KEYCOMS,"; //sqlText += "MP_WEIGHT,MP_NUMBER,MP_USAGE,MP_TYPE,MP_TIMERQ,MP_ENVREFFCT,MP_NOTE "; //sqlText += "from " + tablename + " where MP_PID in (select MP_ID from TBPM_MPFORALLRVW "; //sqlText += "where MP_ENGID='" + engid + "' and cast(MP_STATE as int)>7 union "; //sqlText += "select MP_ID from TBPM_MPCHANGERVW where MP_ENGID='" + engid + "' "; //sqlText += "and cast(MP_STATE as int)>7)) as temp1 left join "; //sqlText += "(select MP_PID,MP_MARID,MP_NAME,MP_GUIGE,MP_CAIZHI,MP_UNIT,MP_STANDARD,MP_KEYCOMS,"; //sqlText += "sum(MP_WEIGHT) as MP_WEIGHT,sum(MP_NUMBER) as MP_NUMBER from TBPM_MPCHANGE "; //sqlText += "where MP_PID in (select MP_ID from TBPM_MPCHANGERVW where MP_ENGID='" + engid + "' "; //sqlText += "and cast(MP_STATE as int)>7)group by MP_PID,MP_MARID,MP_NAME,MP_GUIGE,MP_CAIZHI,"; //sqlText += "MP_UNIT,MP_STANDARD,MP_KEYCOMS) as temp2 on temp1.MP_MARID=temp2.MP_MARID "; //sqlText += "and temp1.MP_GUIGE=temp2.MP_GUIGE and temp1.MP_KEYCOMS=temp2.MP_KEYCOMS "; //sqlText += "and temp1.MP_PID=temp2.MP_PID order by temp1.MP_PID"; sqlText = "select MP_PID,MP_PJID,MP_PJNAME,MP_ENGID,MP_ENGNAME," + "MP_MARID,MP_NAME,MP_GUIGE,MP_CAIZHI,MP_STANDARD,MP_UNIT,MP_LENGTH,MP_WIDTH,MP_WEIGHT," + "MP_NUMBER,MP_USAGE,MP_TYPE,MP_TIMERQ,MP_ENVREFFCT,MP_TRACKNUM,MP_KEYCOMS,MP_NOTE," + "MP_STATE,MP_FIXEDSIZE,MP_STATUS,MP_ZONGXU,MP_CHGPID,MP_OLDXUHAO,MP_NEWXUHAO from View_TM_MPHZY where MP_STATE='0'"; DBCallCommon.BindGridView(GridView1, sqlText); InitPanel(); }
protected void initial() { sqltext = "select NAME,MODEL,NUMSTORE from TBOM_GDZCSTORE where OUTSTATE='1'"; DBCallCommon.BindGridView(GridView1, sqltext); sqltext = "update TBOM_GDZCSTORE set OUTSTATE=''"; DBCallCommon.ExeSqlText(sqltext); }
//查询不同的材料需用表 private void GetSearchList() { InitList(); sqlText = "select * from " + tablename + " "; sqlText += "where MP_PID='" + mp_no.Text + "' and MP_STATE='5'"; DBCallCommon.BindGridView(GridView1, sqlText); }
//初始化页面 private void InitInfo() { InitVar(); sqlText = "select * from TBPM_MPFORLIB where MP_ENGID='" + tsaid.Text + "' and MP_STATE='0' "; DBCallCommon.BindGridView(GridView1, sqlText); InitPanel(); }
protected void initial() { sqltext = "select TYPE,NAME,MODEL,NUMBER from TBMP_TOOL_RESTORE where STATE='1'"; DBCallCommon.BindGridView(GridView1, sqltext); sqltext = "update TBMP_TOOL_RESTORE set STATE=''"; DBCallCommon.ExeSqlText(sqltext); }
private void InitInfo() { string action = Request.QueryString["action"]; string sqltxt = "select OST_STATE from TBPM_OUTSCHANGERVW where OST_CHANGECODE='" + action + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltxt); if (dr.Read()) { if (dr[0].ToString() == "8") { sqlText = "select OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,OSL_TOTALWGHTL,OSL_NUMBER,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE from View_TM_OUTSOURCELIST WHERE (OSL_MARID is null or OSL_MARID='') AND OSL_OUTSOURCECHGNO='" + action + "'"; sqlText += " UNION ALL "; sqlText += "select OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,'N' as OSL_FIXEDSIZE,SUM(OSL_TOTALWGHTL)AS OSL_TOTALWGHTL,SUM(OSL_NUMBER)AS OSL_NUMBER,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE from View_TM_OUTSOURCELIST WHERE OSL_MARID!='' and OSL_TOTALWGHTL>0 AND OSL_FIXEDSIZE='N' AND OSL_OUTSOURCECHGNO='" + action + "' group by OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE "; sqlText += " UNION ALL "; sqlText += "select OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,'Y' as OSL_FIXEDSIZE,SUM(OSL_TOTALWGHTL)AS OSL_TOTALWGHTL,SUM(OSL_NUMBER)AS OSL_NUMBER,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE from View_TM_OUTSOURCELIST WHERE OSL_MARID!='' and OSL_TOTALWGHTL>0 AND OSL_FIXEDSIZE='Y' AND OSL_OUTSOURCECHGNO='" + action + "' group by OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE "; sqlText += " UNION ALL "; sqlText += " select OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,SUM(OSL_TOTALWGHTL)AS OSL_TOTALWGHTL,SUM(OSL_NUMBER)AS OSL_NUMBER,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE from View_TM_OUTSOURCELIST WHERE OSL_MARID!='' and OSL_TOTALWGHTL=0 AND OSL_OUTSOURCECHGNO='" + action + "' group by OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE "; sqlText += " order by OSL_MARID"; } else { sqlText = "select OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,OSL_TOTALWGHTL,OSL_NUMBER,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE from View_TM_OUTSOURCELIST WHERE (OSL_MARID is null or OSL_MARID='') AND OSL_NEWXUHAO in (select OSL_OLDXUHAO from TBPM_OUTSCHANGE where OST_CHANGECODE='" + action + "') and OSL_STATUS='0'"; sqlText += " UNION ALL "; sqlText += "select OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,'N' as OSL_FIXEDSIZE,SUM(OSL_TOTALWGHTL)AS OSL_TOTALWGHTL,SUM(OSL_NUMBER)AS OSL_NUMBER,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE from View_TM_OUTSOURCELIST WHERE OSL_MARID!='' and OSL_TOTALWGHTL>0 AND OSL_FIXEDSIZE='N' AND OSL_NEWXUHAO in (select OSL_OLDXUHAO from TBPM_OUTSCHANGE where OST_CHANGECODE='" + action + "') and OSL_STATUS='0' group by OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE "; sqlText += " UNION ALL "; sqlText += "select OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,'Y' as OSL_FIXEDSIZE,SUM(OSL_TOTALWGHTL)AS OSL_TOTALWGHTL,SUM(OSL_NUMBER)AS OSL_NUMBER,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE from View_TM_OUTSOURCELIST WHERE OSL_MARID!='' and OSL_TOTALWGHTL>0 AND OSL_FIXEDSIZE='Y' AND OSL_NEWXUHAO in (select OSL_OLDXUHAO from TBPM_OUTSCHANGE where OST_CHANGECODE='" + action + "') and OSL_STATUS='0' group by OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE "; sqlText += " UNION ALL "; sqlText += " select OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,SUM(OSL_TOTALWGHTL)AS OSL_TOTALWGHTL,SUM(OSL_NUMBER)AS OSL_NUMBER,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE from View_TM_OUTSOURCELIST WHERE OSL_MARID!='' and OSL_TOTALWGHTL=0 AND OSL_NEWXUHAO in (select OSL_OLDXUHAO from TBPM_OUTSCHANGE where OST_CHANGECODE='" + action + "') and OSL_STATUS='0' group by OSL_OUTSOURCECHGNO,OSL_TRACKNUM,OSL_MARID,OSL_NAME,OSL_GUIGE,OSL_CAIZHI,OSL_UNITWGHT,OSL_KEYCOMS,OSL_FIXEDSIZE,OSL_WDEPNAME,OSL_REQUEST,OSL_REQDATE,OSL_DELSITE "; sqlText += " order by OSL_MARID"; } } dr.Close(); DBCallCommon.BindGridView(GridView1, sqlText); }
protected void initial() { sqltext = "select ParName,ParType,ParNumSto from EQU_Part_Store where State='1'"; DBCallCommon.BindGridView(GridView1, sqltext); sqltext = "update EQU_Part_Store set State=''"; DBCallCommon.ExeSqlText(sqltext); }
//初始化页面 private void InitInfo() { tsa_id.Text = engid; sqlText = "select TSA_PJID,TSA_PJNAME,TSA_ENGNAME from TBPM_TCTSASSGN "; sqlText += "where TSA_ID='" + engid + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText); if (dr.Read()) { pro_id.Value = dr[0].ToString(); proname.Text = dr[1].ToString(); engname.Text = dr[2].ToString(); } dr.Close(); #region //sqlText = "select MS_PID,MS_INDEX,MS_TUHAO,MS_ZONGXU,MS_NAME,MS_GUIGE,MS_CAIZHI,"; //sqlText += "MS_UNUM,MS_UWGHT,MS_TLWGHT,MS_MASHAPE,MS_MASTATE,MS_STANDARD,"; //sqlText += "MS_PROCESS,MS_TIMERQ,MS_NOTE FROM " + tablename + " "; //sqlText += "where MS_ENGID='" + engid + "' and MS_STATUS='0' union "; //sqlText += "select MS_PID,MS_INDEX,MS_TUHAO,MS_ZONGXU,MS_NAME,MS_GUIGE,MS_CAIZHI,"; //sqlText += "MS_UNUM,MS_UWGHT,MS_TLWGHT,MS_MASHAPE,MS_MASTATE,MS_STANDARD,"; //sqlText += "MS_PROCESS,MS_TIMERQ,MS_NOTE FROM TBPM_MSCHANGE "; //sqlText += "where MS_ENGID='" + engid + "' order by MS_ZONGXU "; #endregion sqlText = "select MS_PID,MS_INDEX,MS_TUHAO,MS_ZONGXU,MS_NAME,MS_GUIGE,MS_CAIZHI,"; sqlText += "MS_UNUM,MS_UWGHT,MS_TLWGHT,MS_MASHAPE,MS_MASTATE,MS_STANDARD,"; sqlText += "MS_PROCESS,MS_TIMERQ,MS_NOTE FROM TBPM_MSOFNEW "; sqlText += "where MS_ENGID='" + engid + "' and MS_STATE='5' "; sqlText += "order by dbo.f_formatstr(MS_INDEX,'.') "; DBCallCommon.BindGridView(GridView1, sqlText); InitPanel(); }
//初始化页面 private void InitInfo() { tsa_id.Text = action; sqlText = "select TSA_PJID,TSA_PJNAME,TSA_ENGNAME from TBPM_TCTSASSGN "; sqlText += "where TSA_ID='" + action + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText); if (dr.Read()) { pro_id.Value = dr[0].ToString(); proname.Text = dr[1].ToString(); engname.Text = dr[2].ToString(); } dr.Close(); sqlText = "select OSL_OUTSOURCENO,OSL_ZONGXU,OSL_NAME,OSL_BIAOSHINO,OSL_GUIGE,"; sqlText += "OSL_CAIZHI,OSL_UNITWGHT,OSL_NUMBER,OSL_TOTALWGHTL,OSL_WDEPNAME,"; sqlText += "OSL_REQUEST,OSL_REQDATE,OSL_DELSITE FROM TBPM_OUTSOURCELIST "; sqlText += "where OSL_ENGID='" + action + "' and OSL_STATUS='0' union "; sqlText += "select OSL_OUTSOURCENO,OSL_ZONGXU,OSL_NAME,OSL_BIAOSHINO,OSL_GUIGE,"; sqlText += "OSL_CAIZHI,OSL_UNITWGHT,OSL_NUMBER,OSL_TOTALWGHTL,OSL_WDEPNAME,"; sqlText += "OSL_REQUEST,OSL_REQDATE,OSL_DELSITE FROM TBPM_OUTSCHANGE "; sqlText += "where OSL_ENGID='" + action + "' order by OSL_OUTSOURCENO "; DBCallCommon.BindGridView(GridView1, sqlText); InitPanel(); }
//查询满足条件的制作明细 private void GetMSData() { InitList(); sqlText = "select count(MS_PID) from " + tablename + " where MS_PID='" + ms_no.Value + "' "; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText); if (dr.Read()) { if (int.Parse(dr[0].ToString()) == 0) { Response.Redirect("TM_MS_TEMP_InitData.aspx?bgid=" + ms_no.Value); } } dr.Close(); sqlText = "select MS_INDEX,MS_TUHAO,MS_ZONGXU,MS_NAME,MS_GUIGE,MS_CAIZHI,MS_UNUM,MS_UWGHT,"; sqlText += "MS_TLWGHT,MS_MASHAPE,MS_MASTATE,MS_STANDARD,MS_PROCESS,MS_NOTE "; sqlText += "from " + tablename + " where MS_PID='" + ms_no.Value + "' "; if (status.Value == "3" || status.Value == "5" || status.Value == "7") { sqlText += "and MS_STATE='4' ";//驳回 } else { sqlText += "and MS_STATE in ('0','1','2','3','5') "; } sqlText += "order by dbo.f_formatstr(MS_INDEX, '.')"; DBCallCommon.BindGridView(GridView1, sqlText); }
protected void bind1() { string sqltext = ""; sqltext = "select marid,marnm,margg,margb,marcz,marunit,num " + "from View_TBPC_PURCHASEPLAN " + "where marid='" + tb_marid.Text + "' and ptcode='" + tb_ptcode.Text + "'"; DBCallCommon.BindGridView(GridView2, sqltext); }
protected void bind() { //string sqltext = "SELECT MARID,MARNM,MARGG,MARCZ,PRICE,shuilv,IRQDATA,SUPPLIERRESNM,picno FROM View_TBPC_IQRCMPPRICE_RVW WHERE MARID ='" + // tb_marid.Text + "' AND IRQDATA <='" + tb_marshijian.Text + "' ORDER BY IRQDATA DESC"; string sqltext = "SELECT MARID,MARNM,MARGG,MARCZ,PRICE,shuilv,IRQDATA,SUPPLIERRESNM,picno FROM View_TBPC_IQRCMPPRICE_RVW WHERE MARID ='" + tb_marid.Text + "' AND totalstate='4' AND price is not null ORDER BY IRQDATA DESC"; DBCallCommon.BindGridView(GridView1, sqltext); }
protected void bind() { string sqltext = ""; sqltext = "SELECT planno, pjid, pjnm, engid, engnm, ptcode, " + "marid, marnm, margg, marcz, margb, marunit,marfzunit,isnull(length,0) as length ,isnull(width,0) as width,isnull(num,0) as num,isnull(fznum,0) as fznum, " + "isnull(rpnum,0) as rpnum, isnull(rpfznum,0) as rpfznum,jstimerq,cgrid, cgrnm, isnull(purstate,0) as purstate, purnote, picno,orderno,PUR_MASHAPE,PUR_CSTATE,PUR_ZYDY,PUR_TUHAO " + "FROM View_TBPC_PURCHASEPLAN_IRQ_ORDER where planno='" + orderno.Text + "' and (PUR_CSTATE='1' or PUR_CSTATE='2') order by ptcode asc"; DBCallCommon.BindGridView(GridView1, sqltext); }
protected void bind() { string sqltext = ""; sqltext = "select marid,marnm,margg,margb,marcz,marunit,marfzunit,length,width," + "sum(num) as num,sum(fznum) as fznum " + "from View_TBPC_STORAGE " + "where marnm='" + tb_marnm.Text + "' and marcz = '" + tb_marcz.Text + "' and ptcode='备库' " + "group by marid,marnm,margg,margb,marcz,marunit,marfzunit,length, width"; DBCallCommon.BindGridView(GridView1, sqltext); }
private void GetPkData() { sqlText = "select * from TBPM_PACKINGLIST "; if (status.Value == "3" || status.Value == "5" || status.Value == "7") { sqlText += "where PL_PACKLISTNO='" + pk_no.Value + "' and PL_STATE='4'"; } else { sqlText += "where PL_PACKLISTNO='" + pk_no.Value + "' and PL_STATE in ('0','1','2','3','5')"; } DBCallCommon.BindGridView(GridView1, sqlText); }
/// <summary> /// 绑定数据 /// </summary> private void GetOutList() { InitList(); sqlText = "select * from " + viewtable + " "; sqlText += "where OSL_OUTSOURCENO='" + outsource_no.Value + "' "; if (ckbShowZero.Checked) { sqlText += "and (case when LOWER(OSL_PURCUNIT)='吨' or LOWER(OSL_PURCUNIT)='t' or LOWER(OSL_PURCUNIT)='kg' or LOWER(OSL_PURCUNIT)='千克' or LOWER(OSL_PURCUNIT)='公斤' THEN OSL_TOTALWGHTL ELSE OSL_NUMBER END)=0 "; } sqlText += " order by dbo.f_FormatSTR(OSL_OLDXUHAO,'.')"; DBCallCommon.BindGridView(GridView1, sqlText); InitDataPanel(GridView1); }
protected void GetDataByID(string id) { sqltext = "select a.DocuNum,a.EquName,a.EquType,a.EquNum,b.ParNumSto from EQU_Need as a,EQU_Part_Store as b where a.EquName=b.ParName and a.DocuNum='" + id + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); if (dt.Rows.Count.ToString() != "0") { DBCallCommon.BindGridView(GridView1, sqltext); } else { sqltext = "select DocuNum,EquName,EquType,EquNum,ParNumSto='0' from EQU_Need where DocuNum='" + id + "'"; DBCallCommon.BindGridView(GridView1, sqltext); } }
//查询满足条件的制作明细 private void GetMSData() { sqlText = "select * from " + tablename + " where MS_ENGID='" + tsa_id.Text + "' and MS_STATE='5' union all "; sqlText = "select * from TBPM_MSCHANGE "; if (status.Value == "3" || status.Value == "5" || status.Value == "7") { sqlText += "where MS_PID='" + ms_no.Value + "' and MS_STATE='4' "; } else { sqlText += "where MS_PID='" + ms_no.Value + "' and MS_STATE in ('0','1','2','3','5') "; } sqlText += "order by dbo.f_formatstr(MS_ZONGXU, '.')"; DBCallCommon.BindGridView(GridView1, sqlText); }
//查询项目、工程下的技术外协 private void GetPackData() { List <string> nos = new List <string>(); if (ddlProName.SelectedValue != "-请选择-" && ddlEngName.SelectedValue == "-请选择-") { sqlText = "select PLT_PACKLISTNO from TBPM_PACKLISTTOTAL "; sqlText += "where PLT_PJID='" + ddlProName.SelectedValue + "'"; } else if (ddlProName.SelectedValue != "-请选择-" && ddlEngName.SelectedValue != "-请选择-") { sqlText = "select PLT_PACKLISTNO from TBPM_PACKLISTTOTAL "; sqlText += "where PLT_ENGID='" + ddlEngName.SelectedValue + "'"; } DataTable dt = DBCallCommon.GetDTUsingSqlText(sqlText); foreach (DataRow row in dt.Rows) { nos.Add(row[0].ToString().Trim()); } string[] col_fields = nos.ToArray(); string pk_no = ""; for (int i = 0; i < col_fields.Length; i++) { pk_no = pk_no + "'" + col_fields[i].ToString() + "'" + ","; } string PLT_NOS = pk_no.Trim(','); if (PLT_NOS != "") { sqlText = "select PL_NO,PL_PACKAGENO,PL_ITEMNO,PL_PACKNAME,PL_MARKINGNO,PL_PACKQLTY,"; sqlText += "PL_PACKTYPE,PL_PACKDIML,PL_PACKDIMW,PL_PACKDIMH,PL_TOTALVOLUME,"; sqlText += "PL_SINGLENETWGHT,PL_SINGLEGROSSWGHT,PL_TOTALGROSSWGHT,PL_DESCRIPTION,"; sqlText += "PL_OUTLINEDRAWING,PL_STATE "; sqlText += "from TBPM_PACKINGLIST where PL_PACKLISTNO in (" + PLT_NOS + ")"; } else { sqlText = "select PL_NO,PL_PACKAGENO,PL_ITEMNO,PL_PACKNAME,PL_MARKINGNO,PL_PACKQLTY,"; sqlText += "PL_PACKTYPE,PL_PACKDIML,PL_PACKDIMW,PL_PACKDIMH,PL_TOTALVOLUME,"; sqlText += "PL_SINGLENETWGHT,PL_SINGLEGROSSWGHT,PL_TOTALGROSSWGHT,PL_DESCRIPTION,"; sqlText += "PL_OUTLINEDRAWING,PL_STATE "; sqlText += "from TBPM_PACKINGLIST where PL_PACKLISTNO=''"; } DBCallCommon.BindGridView(GridView1, sqlText); InitVar(); }
//初始化页面信息 private void InitInfo() { string action = ""; if (Request.QueryString["packlist"] != null) { fields = Request.QueryString["packlist"].ToString().Split('.'); tsa_id.Text = fields[0].ToString(); ms_no.Value = fields[0].ToString() + '.' + fields[1].ToString(); action = fields[2].ToString() + '.' + fields[3].ToString() + '.' + fields[4].ToString(); status.Value = fields[4].ToString(); } else { action = Request.QueryString["pkdetail"]; fields = action.Split('.'); tsa_id.Text = fields[0].ToString(); ms_no.Value = fields[0].ToString() + '.' + fields[1].ToString(); status.Value = fields[2].ToString(); } if (int.Parse(status.Value) > 0) { Response.Redirect("TM_Packing_List.aspx?id=" + action); } else { sqlText = "select TSA_PJID,TSA_PJNAME,TSA_ENGNAME,TSA_ENGSTRTYPE "; sqlText += "from TBPM_TCTSASSGN where TSA_ID='" + tsa_id.Text + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText); if (dr.Read()) { pro_id.Value = dr[0].ToString(); lab_proname.Text = dr[1].ToString(); lab_engname.Text = dr[2].ToString(); ms_list.Value = dr[3].ToString(); } dr.Close(); InitList(); //GetNewMSDate(); //DeleteMSOldData(); sqlText = "select * from " + tablename + " where MS_PID='" + ms_no.Value + "'"; DBCallCommon.BindGridView(GridView1, sqlText); } }
protected void GetDataByID(string id) { sqltext = "select CODE,DEPARTMENT,AGENTID,LINKMAN,PHONE,REASON,NOTE,AGENT,ADDTIME,BC_CONTEXT from TBOM_GDZCPCAPPLY where CODE='" + id + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext); while (dr.Read()) { lblCode.Text = dr["CODE"].ToString(); lblDepartment.Text = dr["DEPARTMENT"].ToString(); txtLinkman.Text = dr["LINKMAN"].ToString(); txtPhone.Text = dr["PHONE"].ToString(); txtReason.Text = dr["REASON"].ToString(); txtNote.Text = dr["NOTE"].ToString(); lblAgent.Text = dr["AGENT"].ToString(); lblAddtime.Text = dr["ADDTIME"].ToString(); lblAgent_id.Text = dr["AGENTID"].ToString(); HiddenFieldContent.Value = dr["BC_CONTEXT"].ToString(); } dr.Close(); sqltext = "select NAME,MODEL,NUM,LOCATION,XQTIME from TBOM_GDZCPCAPPLY where CODE='" + id + "'"; DBCallCommon.BindGridView(GridView1, sqltext); }
private void InitInfo() { //变更后材料计划 string action = Request.QueryString["action"]; lbllotNum.Text = action; mp_no = action; string sqltxt = "select * from View_TM_MPCHANGE where MP_PID='" + action + "' order by dbo.f_FormatSTR(MP_NEWXUHAO,'.') "; DBCallCommon.BindGridView(GridView1, sqltxt); //本批引起计划增加或减少量 GridView2.DataSource = this.GetCurLotIncRedQutyOfMar(action); GridView2.DataBind(); if (GridView2.Rows.Count > 0) { NoDataPanel.Visible = false; } else { NoDataPanel.Visible = true; } }
protected void initial() { sqltext = "SELECT * FROM TBMP_FINISHED_OUT AS A LEFT OUTER JOIN View_CM_FaHuo AS B ON (A.TSA_ID=B.TSA_ID and A.TFO_ENGNAME=B.TSA_ENGNAME and A.TFO_MAP=B.TSA_MAP and A.TFO_ZONGXU=B.ID ) left join TBMP_FINISHED_STORE as c on a.TSA_ID=c.KC_TSA and a.TFO_ZONGXU=KC_ZONGXU where TFO_DOCNUM='" + docnum.Text + "'"; DBCallCommon.BindGridView(GridView1, sqltext); }
protected void GetDataByID(string id) { sqltext = "select DISTINCT(CODE) AS CODE,DEPARTMENT,LINKMAN,PHONE,REASON,NOTE,AGENT,AGENTID,ADDTIME,STATE,BC_CONTEXT from TBOM_GDZCPCAPPLY where CODE='" + id + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext); while (dr.Read()) { lblCode.Text = dr["CODE"].ToString(); lblDepartment.Text = dr["DEPARTMENT"].ToString(); lblLinkman.Text = dr["LINKMAN"].ToString(); lblPhone.Text = dr["PHONE"].ToString(); lblReason.Text = dr["REASON"].ToString(); lblNote.Text = dr["NOTE"].ToString(); lblAgent.Text = dr["AGENT"].ToString(); lblAgent_id.Text = dr["AGENTID"].ToString(); lblAddtime.Text = dr["ADDTIME"].ToString(); lbl_context.Text = dr["BC_CONTEXT"].ToString(); if (dr["STATE"].ToString() != "0") { } //if(Session["UserID"].ToString()==lblAgent_id.Text) //{ // Tab_spxx.Visible = true; //} } dr.Close(); sqltext = "select ID,NAME,MODEL,NUM,LOCATION,XQTIME,UPRICE,TPRICE from TBOM_GDZCPCAPPLY where CODE='" + id + "'"; DBCallCommon.BindGridView(GridView1, sqltext); string sqltext1 = "select CARRVWA,CARRVWAID,CARRVWAADVC,CARRVWATIME,CARRVWB,CARRVWBID,CARRVWBADVC,CARRVWBTIME,CARRVWC,CARRVWCID,CARRVWCADVC,CARRVWCTIME,STATUS from TBOM_GDZCRVW where CODE='" + id + "'"; SqlDataReader dr1 = DBCallCommon.GetDRUsingSqlText(sqltext1); if (dr1.Read()) { txt_first.Text = dr1["CARRVWA"].ToString(); firstid.Value = dr1["CARRVWAID"].ToString(); first_opinion.Text = dr1["CARRVWAADVC"].ToString(); first_time.Text = dr1["CARRVWATIME"].ToString(); txt_second.Text = dr1["CARRVWB"].ToString(); secondid.Value = dr1["CARRVWBID"].ToString(); second_opinion.Text = dr1["CARRVWBADVC"].ToString(); second_time.Text = dr1["CARRVWBTIME"].ToString(); lblState.Text = dr1["STATUS"].ToString(); if (Session["UserID"].ToString() == firstid.Value || Session["UserID"].ToString() == secondid.Value || Session["UserID"].ToString() == lblAgent_id.Text) { Tab_spxx.Visible = true; //if (Session["UserID"].ToString() == firstid.Value || Session["UserID"].ToString() == secondid.Value) //{ // btnLoad.Visible = true; //} } lbl_state.Text = lblState.Text.ToString(); state = lblState.Text; switch (state) { case "1": if (Session["UserID"].ToString() == firstid.Value) { rblfirst.Enabled = true; first_opinion.Enabled = true; hlSelect2.Visible = true; first_time.Text = DateTime.Now.ToString(); } break; case "2": if (Session["UserID"].ToString() == secondid.Value) { hlSelect2.Visible = true; rblsecond.Enabled = true; second_opinion.Enabled = true; rblsecond.SelectedIndex = 0; second_time.Text = DateTime.Now.ToString(); } break; default: break; } } dr1.Close(); }
//初始化页面 private void InitInfo() { btnsubmit.Text = "提 交"; change_id = Request.QueryString["id"]; audit_id = Request.QueryString["ms_change_id"]; if (change_id != null) { ms_no.Text = change_id; } else { ms_no.Text = audit_id; } sqlText = "select MS_PJNAME,MS_ENGNAME,MS_SUBMITNM,MS_SUBMITTM,"; sqlText += "MS_REVIEWANAME,MS_REVIEWAADVC,MS_REVIEWATIME,"; sqlText += "MS_REVIEWBNAME,MS_REVIEWBADVC,MS_REVIEWBTIME,"; sqlText += "MS_REVIEWCNAME,MS_REVIEWCADVC,MS_REVIEWCTIME,"; sqlText += "MS_ADATE,MS_STATE,MS_PJID,MS_ENGID "; sqlText += "from TBPM_MSCHANGERVW where MS_CODE='" + ms_no.Text + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText); while (dr.Read()) { #region lab_proname.Text = dr[0].ToString(); proname.Text = dr[0].ToString(); lab_engname.Text = dr[1].ToString(); engname.Text = dr[1].ToString(); txt_editor.Text = dr[2].ToString(); txt_plandate.Text = dr[3].ToString(); plandate.Text = dr[3].ToString(); txt_first.Text = dr[4].ToString(); first_opinion.Text = dr[5].ToString(); first_time.Text = dr[6].ToString(); txt_second.Text = dr[7].ToString(); second_opinion.Text = dr[8].ToString(); second_time.Text = dr[9].ToString(); txt_third.Text = dr[10].ToString(); third_opinion.Text = dr[11].ToString(); third_time.Text = dr[12].ToString(); txt_approval.Text = dr[13].ToString(); status.Value = dr[14].ToString(); pro_id.Value = dr[15].ToString(); tsa_id.Text = dr[16].ToString(); #endregion if (int.Parse(status.Value) < 2) { btnsave.Visible = true; } #region if (status.Value == "3")//一级审核驳回 { rblfirst.SelectedValue = "3"; btnsubmit.Enabled = false; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status.Value == "5")//二级审核驳回 { rblfirst.SelectedValue = "4"; rblsecond.SelectedValue = "5"; btnsubmit.Enabled = false; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status.Value == "7")//三级审核驳回 { rblfirst.SelectedValue = "4"; rblsecond.SelectedValue = "6"; rblthird.SelectedValue = "7"; btnsubmit.Enabled = false; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status.Value == "4")//一级审核通过 { rblfirst.SelectedValue = "4"; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; } if (status.Value == "6")//二级审核通过 { rblfirst.SelectedValue = "4"; rblsecond.SelectedValue = "6"; btnsubmit.Text = "确 定"; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; } if (status.Value == "8" || status.Value == "9")//三级审核通过 { rblfirst.SelectedValue = "4"; rblsecond.SelectedValue = "6"; rblthird.SelectedValue = "8"; ImageVerify.Visible = true; btnsubmit.Text = "确 定"; btnsubmit.Enabled = false; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } #endregion } dr.Close(); sqlText = "select * from TBPM_MSCHANGE where MS_PID='" + ms_no.Text + "' and MS_STATE='0'"; DBCallCommon.BindGridView(GridView2, sqlText); if (status.Value == "0" || status.Value == "1") { Panel4.Visible = false; sqlText = "select * from TBPM_MSCHANGE where MS_PID='" + ms_no.Text + "' and MS_STATE='" + status.Value + "'"; DBCallCommon.BindGridView(GridView1, sqlText); } else { Panel1.Visible = false; sqlText = "select * from TBPM_MSCHANGE where MS_PID='" + ms_no.Text + "' and MS_STATE in ('2','3','4','5')"; DBCallCommon.BindGridView(GridView3, sqlText); } }
private void InitInfo() { btnsubmit.Text = "提 交"; string PLT_NO = ""; string status = ""; pk_id = Request.QueryString["id"]; pk_no = Request.QueryString["pk_audit_id"]; if (pk_id != null) { PLT_NO = pk_id; } else { PLT_NO = pk_no; } sqlText = "select PLT_PACKLISTNO,PLT_CONTRACTOR,PLT_OWNER,PLT_SHIPNO,"; sqlText += "PLT_DELIVERYDATE,PLT_SYSTEMNUM,PLT_GOODSNAME,PLT_SUBMITNM,"; sqlText += "PLT_SUBMITTM,PLT_REVIEWANAME,PLT_REVIEWAADVC,PLT_REVIEWATIME,"; sqlText += "PLT_REVIEWBNAME,PLT_REVIEWBADVC,PLT_REVIEWBTIME,PLT_REVIEWCNAME,"; sqlText += "PLT_REVIEWCADVC,PLT_REVIEWCTIME,PLT_ADATE,PLT_STATE,PLT_PJNAME,"; sqlText += "PLT_ENGNAME,PLT_ENGID from TBPM_PACKLISTTOTAL "; sqlText += "where PLT_PACKLISTNO='" + PLT_NO + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText); #region if (dr.Read()) { packlist_no.Value = dr[0].ToString(); Gen_Contractor.Text = dr[1].ToString(); Owner.Text = dr[2].ToString(); Ship_No.Text = dr[3].ToString(); Con_Date.Text = dr[4].ToString(); Sys_No.Text = dr[5].ToString(); Goods_Name.Text = dr[6].ToString(); Signature.Text = dr[7].ToString(); txt_editor.Text = dr[7].ToString(); txt_plandate.Text = dr[8].ToString(); txt_first.Text = dr[9].ToString(); first_opinion.Text = dr[10].ToString(); first_time.Text = dr[11].ToString(); txt_second.Text = dr[12].ToString(); second_opinion.Text = dr[13].ToString(); second_time.Text = dr[14].ToString(); txt_third.Text = dr[15].ToString(); third_opinion.Text = dr[16].ToString(); third_time.Text = dr[17].ToString(); status = dr[19].ToString(); lab_proname.Text = dr[20].ToString(); lab_engname.Text = dr[21].ToString(); tsa_id.Text = dr[22].ToString(); if (Session["UserGroup"].ToString().Contains("技术员")) { first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status == "2") { txt_first.Enabled = false; hlSelect1.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status == "3") { rblfirst.SelectedValue = "3"; btnsubmit.Enabled = false; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status == "5") { rblfirst.SelectedValue = "4"; rblsecond.SelectedValue = "5"; btnsubmit.Enabled = false; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status == "7") { rblfirst.SelectedValue = "4"; rblsecond.SelectedValue = "6"; rblthird.SelectedValue = "7"; btnsubmit.Enabled = false; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status == "4") { rblfirst.SelectedValue = "4"; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } if (status == "6") { rblfirst.SelectedValue = "4"; rblsecond.SelectedValue = "6"; btnsubmit.Text = "确 定"; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; } if (status == "8" || status == "9") { rblfirst.SelectedValue = "4"; rblsecond.SelectedValue = "6"; rblthird.SelectedValue = "8"; ImageVerify.Visible = true; btnsubmit.Text = "确 定"; btnsubmit.Enabled = false; txt_first.Enabled = false; hlSelect1.Enabled = false; first_opinion.Enabled = false; rblfirst.Enabled = false; txt_second.Enabled = false; hlSelect2.Enabled = false; second_opinion.Enabled = false; rblsecond.Enabled = false; txt_third.Enabled = false; hlSelect3.Enabled = false; third_opinion.Enabled = false; rblthird.Enabled = false; } } dr.Close(); #endregion if (status == "0") { sqlText = "select * from TBPM_PACKINGLIST "; sqlText += "where PL_PACKLISTNO='" + PLT_NO + "' and PL_STATE='0'"; } else { sqlText = "select * from TBPM_PACKINGLIST "; sqlText += "where PL_PACKLISTNO='" + PLT_NO + "' and PL_STATE!='0'"; } DBCallCommon.BindGridView(GridView1, sqlText); }
protected void BindTestData() { string strsql = "select * from TBPM_HZYSTRINFO order by dbo.f_formatstr(HZY_ZONGXU, '.')"; DBCallCommon.BindGridView(GridView1, strsql); }
//查询不同的制作明细表 private void GetSearchList() { GetListName(); sqlText = "select * from " + mstable + " where MS_PID='" + ms_no.Text + "' and MS_STATE='5'"; DBCallCommon.BindGridView(GridView1, sqlText); }
private void GetOutChange() { sqlText = "select * from TBPM_OUTSOURCELIST "; sqlText += "where OSL_OUTSOURCENO='" + out_no.Text + "' and OSL_STATE='5'"; DBCallCommon.BindGridView(GridView1, sqlText); }