//库存物料信息 private void tbpc_marrepkumrepeaterdatabind() { string marnm = YMARNAME.Text; string state = YSTATE.Text; string ptcode = YPTCODE.Text; string sqltext = ""; string caizhi = YCAIZHI.Text; if (state == "0")//未保存时显示汇总库存相似物料 { sqltext = "select marid as MARID,marnm as MARNAME,margg as GUIGE,margb as GUOBIAO," + "marcz as CAIZHI,marunit as NUNIT,marfzunit as FZUNIT,length as LENGTH," + "width as WIDTH,sum(num) as NUM,sum(fznum) as FZNUM,SQCODE='' " + "from View_TBPC_STORAGE " + "where marnm='" + marnm + "' and ptcode='备库' and marcz='" + caizhi + "' and marid not in (select detailmarid from View_TBPC_MARREPLACE_detail where detailoldptcode='" + ptcode + "')" + "group by marid,marnm,margg,margb,marcz,marunit,marfzunit,length,width"; DBCallCommon.BindRepeater(tbpc_marrepkumrepeater, sqltext); if (tbpc_marrepkumrepeater.Items.Count == 0) { NoDataPane3.Visible = true; } else { NoDataPane3.Visible = false; } } }
private void tbpc_marrepallbzjdetailRepeaterdatabind() { string sqltext = ""; string marid = ""; marid = gloabid; string ptcode = gloabpt; if (glostate == "1")//已经保存此时只能查看不能保存 { sqltext = "SELECT NUM,LOTNUM,WAREHOUSE as WAREHOUSEID,LOCATION as POSITIONID," + "STATE='1',detailmarid as MARID,detailmarnm as MARNAME,detailusenum as USENUM," + "newsqcode as NEWSQCODE,oldsqcode as SQCODE " + "FROM View_TBPC_MARSTOUSEALLDETAIL_STO " + "where (ptcode = '" + ptcode + "')"; } else { sqltext = "SELECT sqcode as SQCODE,NEWSQCODE='',marid as MARID, marnm as MARNAME," + "lotnum AS LOTNUM,warehouse AS WAREHOUSEID, location AS POSITIONID, " + "num AS NUM, USENUM='0',STATE='0' " + "FROM View_TBPC_STORAGE where marid='" + marid + "' and ptcode = '备库' order by num asc"; } DBCallCommon.BindRepeater(tbpc_marrepallbzjdetailRepeater, sqltext); }
private void Marreplace_edit_repeaterbind() { string pcode = Tb_Code.Text; string sqltext = ""; sqltext = "SELECT marid, num, ptcode, usenum, allstate, allshstate, alloption, allnote, marnm, " + "marguige, marguobiao, marcaizhi, marcgunit, mpcode, plancode, zdreson, zdrid, " + "zdtime, shraid, shratime, shrayj, shrbid, shrbtime, shrbyj, totalstate, totalnote, zdrnm, " + "shranm, shrbnm, engid, pjnm, engnm, detailmarnm, detailmarguige, " + "detailmarguobiao, detailmarcaizhi, detailmarunit, detailmpcode, detailmarid, " + "detailmarnuma, detailmarnumb, detailnote, detailoldsqcode, detailnewsqcode, " + "detailstate, fzunit, length, width, detaillength, detailwidth, detailfzunit, fznum, " + "usefznum, pjid, zdwctime " + "FROM View_TBPC_MARREPLACE_total_all_detail " + "WHERE mpcode='" + pcode + "' order by ptcode asc"; DBCallCommon.BindRepeater(Marreplace_edit_repeater, sqltext); if (Marreplace_edit_repeater.Items.Count == 0) { NoDataPane.Visible = true; } else { NoDataPane.Visible = false; } }
private void tbpc_otherpurbill_lookRepeaterdatabind() { string sqltext = "SELECT * FROM View_TM_WXDetail WHERE MS_WSID='" + tb_doc.Text.Trim() + "'"; //string sqltext = "SELECT * FROM View_TM_WXDetail WHERE MS_WSID='" + tb_doc.Text.Trim() + "'"; DBCallCommon.BindRepeater(tbpc_otherpurbill_lookRepeater, sqltext); }
private void InitInfo() { if (Request.QueryString["id"] != null) { action = Request.QueryString["action"]; id = Request.QueryString["id"]; } sqlText = "select PS_ID,CM_PROJ,PS_PJID,TSA_ENGNAME,PS_PAINTBRAND,PS_SUBMITNM,"; sqlText += "PS_SUBMITTM,PS_REVIEWANM,PS_REVIEWAADVC,PS_REVIEWATIME,"; sqlText += "PS_REVIEWBNM,PS_REVIEWBADVC,PS_REVIEWBTIME,PS_REVIEWCNM,"; sqlText += "PS_REVIEWCADVC,PS_REVIEWCTIME,PS_STATE,PS_CHECKLEVEL,PS_PJID,PS_SUBMITID "; sqlText += "from VIEW_TM_PAINTSCHEME where PS_ID='" + id + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText); if (dr.Read()) { ps_no.Text = dr["PS_ID"].ToString(); proname.Text = dr["CM_PROJ"].ToString(); tsaid.Text = dr["PS_PJID"].ToString(); engname.Text = dr["TSA_ENGNAME"].ToString(); paint_brand.Text = dr["PS_PAINTBRAND"].ToString(); plandate.Text = dr["PS_SUBMITTM"].ToString(); status = dr["PS_STATE"].ToString(); ViewState["status"] = dr["PS_STATE"].ToString(); ViewState["level"] = dr["PS_CHECKLEVEL"].ToString(); level = dr["PS_CHECKLEVEL"].ToString(); proid.Value = dr["PS_PJID"].ToString(); } dr.Close(); sqlText = "select * from View_TM_PAINTSCHEMEDETAIL where PS_PID='" + ps_no.Text + "' "; DBCallCommon.BindRepeater(Repeater1, sqlText); }
private void Purchaseplan_startcontentRepeaterdatabind() { string sqltext = ""; sqltext = "SELECT PUR_PCODE, PUR_PJID, PUR_PJNAME, PUR_ENGID, PUR_ENGNAME, PUR_PTCODE, " + "PUR_MARID, PUR_MARNAME, PUR_MARNORM, PUR_MARTERIAL, PUR_GUOBIAO, PUR_FIXEDSIZE, PUR_NUM, " + "PUR_NUNIT, PUR_USTNUM, PUR_RPNUM, PUR_PUNIT, PUR_STDATE, PUR_PFDATE, PUR_RFDATE, PUR_VICLERK, " + "PUR_VICLERKNM, PUR_CGMAN, PUR_CGMANNM, PUR_PRONODE, PUR_STATE, PUR_NOTE " + "FROM TBPC_PURCHASEPLAN where PUR_PCODE='" + Tb_mpid.Text + "'"; DBCallCommon.BindRepeater(Purchaseplan_startcontentRepeater, sqltext); }
private void initinfo() { string sqltext = ""; sqltext = "select ST_ID,ST_NAME from TBDS_STAFFINFO WHERE ST_DEPID='" + Session["UserDeptID"].ToString() + "'and ST_PD='0'order by ST_ID DESC"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); cob_fuziren.DataSource = dt; cob_fuziren.DataTextField = "ST_NAME"; cob_fuziren.DataValueField = "ST_ID"; cob_fuziren.DataBind(); cob_fuziren.SelectedIndex = 0; cob_sqren.DataSource = dt; cob_sqren.DataTextField = "ST_NAME"; cob_sqren.DataValueField = "ST_ID"; cob_sqren.DataBind(); cob_sqren.SelectedValue = Session["UserID"].ToString(); if (Request.QueryString["action"].ToString() == "add") { if (Request.QueryString["Type"].ToString() != null) { type = Request.QueryString["Type"].ToString(); } string pi_id = generatecode(); Tb_shijian.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); tb_dep.Text = Session["UserDept"].ToString(); tb_depid.Text = Session["UserDeptID"].ToString(); TextBoxexecutor.Text = Session["UserName"].ToString(); TextBoxexecutorid.Text = Session["UserID"].ToString(); TextBox_pid.Text = pi_id; CreateNewRow(); } else { TextBox_pid.Enabled = false; TextBox_pid.Text = Request.QueryString["id"].ToString(); sqltext = "select * from View_EQUNeed_RVW where DocuNum='" + TextBox_pid.Text + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext); while (dr.Read()) { tb_dep.Text = dr["USEDEPNAME"].ToString(); tb_depid.Text = dr["USEDEPID"].ToString(); Tb_shijian.Text = dr["SQtime"].ToString(); cob_fuziren.SelectedValue = dr["REVIEWA"].ToString(); cob_sqren.SelectedValue = dr["SQRID"].ToString(); TextBoxexecutor.Text = dr["DocuPerson"].ToString(); TextBoxexecutorid.Text = dr["DocuPersonID"].ToString(); } dr.Close(); sqltext = "select EquName,EquType,EquNum,XQtime,Reason from View_EQUNeed_RVW where DocuNum='" + TextBox_pid.Text + "'"; DBCallCommon.BindRepeater(EQU_Need_List_Repeater, sqltext); } }
private void tbpc_purbgyclRepeaterdatabind(string str) { DataTable dt = DBCallCommon.GetDTUsingSqlText(str); DBCallCommon.BindRepeater(tbpc_purbgyclRepeater, str); if (tbpc_purbgyclRepeater.Items.Count == 0) { NoDataPanep.Visible = true; } else { NoDataPanep.Visible = false; } }
private void repeaterdatabind() { string sqltext; if (DropDownList_TY.SelectedValue.ToString() == "00") { sqltext = "SELECT a.PUR_PJID,a.PUR_ENGID,a.PUR_PTCODE,a.PUR_MARID,a.PUR_MARNAME,a.PUR_MARNORM,a.PUR_MARTERIAL,a.PUR_FIXEDSIZE,a.PUR_RPNUM,a.PUR_NUNIT,a.PUR_CGMAN AS PUR_CGMANCODE,a.PUR_CGMANNM AS PUR_CGMANNAME,a.PUR_PRONODE,a.PUR_NOTE FROM TBPC_PURCHASEPLAN AS a WHERE PUR_PCODE='" + TextBox_pid.Text.ToString() + "'"; } else { sqltext = "SELECT a.PUR_PJID,a.PUR_ENGID,a.PUR_PTCODE,a.PUR_MARID,a.PUR_MARNAME,a.PUR_MARNORM,a.PUR_MARTERIAL,a.PUR_FIXEDSIZE,a.PUR_RPNUM,a.PUR_NUNIT,a.PUR_CGMAN AS PUR_CGMANCODE,a.PUR_CGMANNM AS PUR_CGMANNAME,a.PUR_PRONODE,a.PUR_NOTE FROM TBPC_PURCHASEPLAN AS a WHERE PUR_PCODE='" + TextBox_pid.Text.ToString() + "' AND PUR_MARID LIKE'" + DropDownList_TY.SelectedValue + "%'"; } DBCallCommon.BindRepeater(tbpc_purshaseplanrealityRepeater, sqltext); }
private void allrepeaterbind() { string sqltext = ""; sqltext = "SELECT planno, pjid, pjnm, engid, engnm, ptcode, marid, marnm, margg, margb, marcz, " + "marunit, marfzunit, length, width, num, fznum, usenum, usefznum, allstata, " + "allshstate, allnote " + "FROM View_TBPC_MARSTOUSEALL where planno='" + TextBox_pid.Text + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext); while (dr.Read()) { gloabid = dr["marid"].ToString(); } dr.Close(); DBCallCommon.BindRepeater(tbpc_manmodmarrepallRepeater, sqltext); }
//采购计划repeater private void tbpc_purbgycldetailRepeaterdatabind() { string sqltext = "SELECT planno as PUR_PCODE,pjid as PUR_PJID,pjnm as PUR_PJNAME,engid as PUR_ENGID,engnm as PUR_ENGNAME,marid as PUR_MARID," + "marnm as PUR_MARNAME,margg as PUR_MARNORM,marcz as PUR_MARTERIAL,margb as PUR_GUOBIAO,num as PUR_NUM,rpnum as PUR_RPNUM," + "marunit as PUR_NUNIT,length as PUR_LENGTH,width as PUR_WIDTH,ptcode as PUR_PTCODE,purnote as PUR_NOTE,cgrid as PUR_CGMAN,picno,orderno," + "cgrnm as PUR_CGMANNM,purstate as PUR_STATE,PUR_CSTATE,PUR_MASHAPE FROM View_TBPC_PURCHASEPLAN_IRQ_ORDER " + "WHERE ptcode like '%" + tsa + "%' and marid='" + tb_marid.Text + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); DBCallCommon.BindRepeater(tbpc_purbgyclRepeater, sqltext); if (tbpc_purbgyclRepeater.Items.Count == 0) { NoDataPanep.Visible = true; } else { NoDataPanep.Visible = false; } //DBCallCommon.BindRepeater(tbpc_purbgyclRepeater, sqltext); }
private void tbpc_marrepallRepeaterdatabind() { string pcode = TextBox_pid.Text; string sqltext = ""; sqltext = "select ptcode as YPTCODE, marid as YMARID, marnm as YMARNAME, marguige as YGUIGE," + " marcaizhi as YCAIZHI, marguobiao as YGUOBIAO, num as YNUM,fznum as YFZNUM, " + "marcgunit as YNUNIT,length as YLENGTH,width as YWIDTH,fzunit as YFZUNIT, allstate as STATE,allshstate,alloption,allnote as NOTE " + "from View_TBPC_MARREPLACE_all " + "where mpcode='" + pcode + "'"; DBCallCommon.BindRepeater(tbpc_marrepallRepeater, sqltext); if (tbpc_marrepallRepeater.Items.Count == 0) { NoDataPane.Visible = true; } else { NoDataPane.Visible = false; } }
private void tbpc_puryclRepeaterdatabind()//采购计划repeater { //现在应该从View_TBPC_PURCHASEPLAN_RVW这个视图中查找 string sqltext = "SELECT planno as PUR_PCODE,pjid as PUR_PJID,pjnm as PUR_PJNAME,engid as PUR_ENGID,engnm as PUR_ENGNAME,marid as PUR_MARID," + "marnm as PUR_MARNAME,margg as PUR_MARNORM,marcz as PUR_MARTERIAL,margb as PUR_GUOBIAO,num as PUR_NUM,rpnum as PUR_RPNUM," + "marunit as PUR_NUNIT,length as PUR_LENGTH,width as PUR_WIDTH,ptcode as PUR_PTCODE,purnote as PUR_NOTE,cgzgid as PUR_CGMAN," + "cgrnm as PUR_CGMANNM,purstate as PUR_STATE FROM View_TBPC_PURCHASEPLAN_RVW " + "WHERE ptcode='" + pt_code.Text + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); DBCallCommon.BindRepeater(tbpc_puryclRepeater, sqltext); if (tbpc_puryclRepeater.Items.Count == 0) { Panel1.Visible = true; } else { Panel1.Visible = false; } }
private void tbpc_purbgclRepeaterdatabind()//变更信息repeater { //应该从这个View_TBPC_MPTEMPCHANGE视图中查找 string sqltext = "select chpcode as BG_PCODE,chptcode as BG_PTCODE,marid as BG_MARID, marnm as BG_MARNAME, " + "pjid as MP_PJID,pjnm as MP_PJNAME,engid as MP_ENGID,engnm as MP_ENGNAME,margg as BG_MARNORM, marcz as BG_MARTERIAL, " + "unit as BG_NUNIT,length as LENGTH,width as WIDTH,chfznum as BG_FZNUM, chnum as BG_NUM, chcgid as MP_CGID,chcgnm as MP_CGNAME, " + "margb as BG_GUOBIAO, chstate as MP_STATE, chnote as BG_NOTE " + "from View_TBPC_MPTEMPCHANGE " + "where chptcode='" + pt_code.Text + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); DBCallCommon.BindRepeater(tbpc_purbgclRepeater, sqltext); if (tbpc_purbgclRepeater.Items.Count == 0) { NoDataPane2.Visible = true; } else { NoDataPane2.Visible = false; } }
private void tbpc_purbgclallRepeaterdatabind()//上面的那个repeater { string sqltext = ""; string ptc = hfdptc.Value; sqltext = "select a.chpcode as MP_NEWPID,a.chptcode as BG_PTCODE,a.pjid as MP_PJID,a.pjnm as MP_PJNAME,a.engid as MP_ENGID,a.engnm as MP_ENGNAME,a.marid as BG_MARID, a.marnm as BG_MARNAME, " + " a.margg as BG_MARNORM, a.marcz as BG_MARTERIAL, " + "a.unit as BG_NUNIT, a.chnum as BG_NUM,a.fzunit,a.chfznum as BG_FZNUM,a.length as LENGTH,a.width as WIDTH,a.chcgid as BG_ZXRENID, " + "a.chcgnm as BG_ZXRENNM, a.margb as BG_GUOBIAO, a.chstate as BG_STATE,a.chnote as MP_NOTE,a.zxnum as BG_ZXNUM,a.zxfznum as BG_ZXFZNUM , " + " b.chsubmitnm as jsy,left(b.chsubmittime,10) as jhtime from View_TBPC_MPTEMPCHANGE as a LEFT OUTER JOIN View_TBPC_MPCHANGETOTAL as b on a.chpcode=b.chpcode where a.chptcode='" + ptc + "'"; DBCallCommon.BindRepeater(tbpc_purbgclallRepeater, sqltext); if (tbpc_purbgclallRepeater.Items.Count == 0) { NoDataPanebg.Visible = true; } else { NoDataPanebg.Visible = false; } }
//代用物料信息 private void tbpc_puralldydetailRepeaterdatabind() { string ptcode = YPTCODE.Text; string state = YSTATE.Text; string sqltext = ""; if (state == "1")//已经保存此时只能查看不能保存 { sqltext = "SELECT sum(NUM) AS KUNUM, sum(FZNUM) AS KUFZNUM,LOTNUM='',LENGTH AS LENGTH, WIDTH AS WIDTH," + "WAREHOUSEID='',POSITIONID='',detailmarnm AS XMARNAME," + "detailmarguige AS XGUIGE, detailmarguobiao AS XGUOBIAO, detailmarunit AS XNUNIT, " + "detailmarcaizhi AS XCAIZHI,detailfzunit,sum(detailmarnuma) AS XUSENUM,detailmpcode," + "sum(detailmarnumb) AS XUSEFZNUM,detailoldptcode,detailmarid AS XMARID,detailnote," + "detailoldsqcode as OLDSQCODE, detailnewsqcode as NEWSQCODE,STATE='1' " + "FROM View_TBPC_MARREPLACE_detail_STO where (detailoldptcode = '" + ptcode + "') " + "group by LENGTH,WIDTH,detailmarnm,detailmarguige,detailmarguobiao,detailmarunit," + "detailmarcaizhi,detailfzunit,detailmpcode,detailoldptcode,detailmarid,detailnote,detailoldsqcode,detailnewsqcode"; } else { sqltext = "SELECT detailnewsqcode as NEWSQCODE,detailoldsqcode as OLDSQCODE, a.SQ_MARID as XMARID,a.MNAME as XMARNAME," + "b.detailmarcaizhi as XCAIZHI, b.detailmarguobiao as XGUOBIAO, " + "b.detailmarguige as XGUIGE,b.detailmarunit AS XNUNIT," + "sumnum as KUNUM,sumfznum as KUFZNUM,sumnum as XUSENUM," + "sumfznum as XUSEFZNUM,LOTNUM='',WAREHOUSEID=''," + "POSITIONID='',SQ_LENGTH as LENGTH,SQ_WIDTH as WIDTH,STATE='0' " + "FROM View_TBPC_STOSUM as a inner join View_TBPC_MARREPLACE_detail as b " + "on a.SQ_MARID=b.detailmarid AND a.SQ_LENGTH = b.detaillength AND a.SQ_WIDTH = b.detailwidth " + "where (b.detailoldptcode = '" + ptcode + "')"; } DBCallCommon.BindRepeater(tbpc_puralldydetailRepeater, sqltext); if (tbpc_puralldydetailRepeater.Items.Count == 0) { NoDataPane2.Visible = true; } else { NoDataPane2.Visible = false; } }
private void initinfo() { if (Request.QueryString["action"].ToString() == "add") { txt_docunum.Text = newdocunum(); CreateNewRow(); } else { string sqltext; txt_docunum.Text = Request.QueryString["id"].ToString(); sqltext = "select a.*,b.CM_CONTR,b.TSA_MAP,c.CM_CUSNAME from TBMP_GS_LIST AS a LEFT JOIN TBCM_FHBASIC AS b ON a.TSA_ID=b.TSA_ID LEFT JOIN TBCM_APPLICA AS c ON b.CM_CONTR=c.CM_CONTR where a.DOCUNUM='" + txt_docunum.Text.ToString() + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext); while (dr.Read()) { ddlgongshiyear.SelectedValue = dr["DATEYEAR"].ToString(); ddlgongshimonth.SelectedValue = dr["DATEMONTH"].ToString(); } dr.Close(); DBCallCommon.BindRepeater(PM_GongShi_List_Repeater, sqltext); } }
private void tbpc_purbgclallRepeaterdatabind()//上面的那个repeater { string sqltext = ""; pcode = TextBox_pid.Text; sqltext = "select MP_ID,chpcode as MP_NEWPID,chptcode as BG_PTCODE,marid as BG_MARID, marnm as BG_MARNAME,pjid as MP_PJID, " + "pjnm as MP_PJNAME,engnm as MP_ENGNAME, margg as BG_MARNORM, marcz as BG_MARTERIAL, " + "unit as BG_NUNIT, chnum as BG_NUM,chfznum as BG_FZNUM,length as LENGTH,width as WIDTH,chcgid as BG_ZXRENID, " + "chcgnm as BG_ZXRENNM, margb as BG_GUOBIAO, chstate as BG_STATE,chnote as MP_NOTE,zxnum as BG_ZXNUM,zxfznum as BG_ZXFZNUM " + "from View_TBPC_MPTEMPCHANGE where chpcode='" + pcode + "'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); DBCallCommon.BindRepeater(tbpc_purbgclallRepeater, sqltext); if (tbpc_purbgclallRepeater.Items.Count == 0) { NoDataPanebg.Visible = true; } else { NoDataPanebg.Visible = false; } }
private void EQU_Need_lookRepeaterdatabind() { string sqltext = "select EquName,EquType,EquNum,XQtime,Reason from View_EQUneed_Audit_List where DocuNum='" + TextBox_pid.Text.ToString() + "'"; DBCallCommon.BindRepeater(EQU_Need_lookRepeater, sqltext); }
private void EQU_Repair_lookRepeaterdatabind() { string sqltext = "select EquName,EquType,Type,Reason from View_EQU_Repair where DocuNum='" + TextBox_pid.Text.ToString() + "'"; DBCallCommon.BindRepeater(EQU_Repair_lookRepeater, sqltext); }
private void initinfo() { string sqltext = ""; sqltext = "select ST_NAME as ST_NAME,ST_ID from TBDS_STAFFINFO WHERE ST_DEPID='" + Session["UserDeptID"].ToString() + "' and ST_PD='0'"; DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext); cob_fuziren.DataSource = dt; cob_fuziren.DataTextField = "ST_NAME"; cob_fuziren.DataValueField = "ST_ID"; cob_fuziren.DataBind(); cob_fuziren.SelectedIndex = 0; if (Session["UserDeptID"].ToString()=="12") { ListItem list1 = new ListItem("陈永秀", "69"); cob_fuziren.Items.Add(list1); } cob_sqren.DataSource = dt; cob_sqren.DataTextField = "ST_NAME"; cob_sqren.DataValueField = "ST_ID"; cob_sqren.DataBind(); cob_sqren.SelectedValue = Session["UserID"].ToString(); if (Request.QueryString["action"].ToString() == "add") { gloabnum = "0"; gloabcsnum = "0"; Tb_shijian.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); tb_dep.Text = Session["UserDept"].ToString(); tb_depid.Text = Session["UserDeptID"].ToString(); TextBoxexecutor.Text = Session["UserName"].ToString(); TextBoxexecutorid.Text = Session["UserID"].ToString(); //TextBox_pid.Enabled = true; tb_pjinfo.Enabled = true; tb_enginfo.Enabled = true; tb_note.Enabled = true; CreateNewRow(10); //如果从TM_Paint_Collect按钮没有传入pId数值则按原方式添加采购,否则直接导入油漆物品采购件 if (String.IsNullOrEmpty(Request.QueryString["pId"].ToString())) { if (Request.QueryString["Type"].ToString() != null) { gloabtype = Request.QueryString["Type"].ToString(); } else { gloabtype = ""; } if (Request.QueryString["shape"].ToString() != null) { gloabshape = Request.QueryString["shape"].ToString(); } else { gloabshape = ""; } lb_shape.Text = gloabshape; } else { gloabtype = "ZC"; gloabshape = "油漆"; lb_shape.Text = gloabshape; string pId = Request.QueryString["pId"].ToString(); string sql = "select PS_ENGID,PS_BOTMARID,sumYL from (select PS_BOTMARID,sum(cast(PS_BOTYONGLIANG as float)) as sumYL,PS_ENGID from (select PS_BOTMARID,PS_BOTYONGLIANG,PS_ENGID from dbo.TBPM_PAINTSCHEMELIST where PS_PID='" + pId + "' and PS_BOTMARID<>''union all select PS_MIDMARID,PS_MIDYONGLIANG,PS_ENGID from dbo.TBPM_PAINTSCHEMELIST where PS_PID='" + pId + "' and PS_MIDMARID<>''union all select PS_TOPMARID,PS_TOPYONGLIANG,PS_ENGID from dbo.TBPM_PAINTSCHEMELIST where PS_PID='" + pId + "' and PS_TOPMARID<>'')a group by PS_BOTMARID,PS_ENGID)b left join dbo.TBMA_MATERIAL as c on b.PS_BOTMARID=c.ID"; SqlDataReader ZCdtrd = DBCallCommon.GetDRUsingSqlText(sql); int i = 0; while (ZCdtrd.Read()) { tb_pjinfo.Text = ZCdtrd["PS_ENGID"].ToString().Trim(); RepeaterItem Reitem = tbpc_otherpurbillRepeater.Items[i]; ((TextBox)Reitem.FindControl("MP_MARID")).Text = ZCdtrd["PS_BOTMARID"].ToString().Trim(); ((TextBox)Reitem.FindControl("MP_NUMBER")).Text = ZCdtrd["sumYL"].ToString().Trim(); i++; } } } else { tb_pjinfo.Enabled = false; tb_enginfo.Enabled = false; TextBox_pid.Text = Request.QueryString["mp_id"].ToString(); sqltext = "select PCODE,PJID,PJNM,ENGID,ENGNM,SQRID,SQRNM,TJRID,TJRNM," + "TJDATE,SHRID,SHRNM,DEPID,DEPNM,NOTE,MP_SHAPE,MP_YFBG,MP_IFFAST " + "from View_TBPC_OTPURRVW where PCODE='" + TextBox_pid.Text + "'"; SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext); while (dr.Read()) { tb_dep.Text = dr["DEPNM"].ToString(); tb_depid.Text = dr["DEPID"].ToString(); Tb_shijian.Text = dr["TJDATE"].ToString(); tb_enginfo.Text = dr["ENGID"].ToString(); tb_pj.Text = dr["PJNM"].ToString(); tb_pjid.Text = dr["PJID"].ToString(); tb_pjinfo.Text = tb_pjid.Text; cob_fuziren.SelectedValue = dr["SHRID"].ToString(); cob_sqren.SelectedValue = dr["SQRID"].ToString(); TextBoxexecutor.Text = dr["TJRNM"].ToString(); TextBoxexecutorid.Text = dr["TJRID"].ToString(); lb_shape.Text = dr["MP_SHAPE"].ToString(); if (dr["MP_YFBG"].ToString() == "1") { cb_bg.Checked = true; } if (dr["MP_IFFAST"].ToString().Trim() == "1") { chkiffast.Checked = true; } else { chkiffast.Checked = false; } } dr.Close(); sqltext = "SELECT PTCODE AS MP_PTCODE,MARID AS MP_MARID,MARNM AS MP_MARNAME,MARGG AS MP_MARNORM," + "MARCZ AS MP_MARTERIAL,MARGB AS MP_MARGUOBIAO,WIDTH AS MP_WIDTH,LENGTH AS MP_LENGTH," + "NUM AS MP_NUMBER,FZNUM AS MP_FZNUM,TIMERQ AS MP_TIMERQ,UNIT AS MP_NUNIT,FZUNIT AS MP_FZNUNIT," + " NOTE AS MP_NOTE,DETAILSTATE AS MP_STATE ,MP_TUHAO,MWEIGHT " + "FROM View_TBPC_OTPURPLAN WHERE PCODE='" + TextBox_pid.Text + "'"; DBCallCommon.BindRepeater(tbpc_otherpurbillRepeater, sqltext); } }
private void PM_Finished_lookRepeaterdatabind() { string sqltext = "select B.CM_ID, B.CM_PROJ,B.CM_FHNUM,B.CM_BIANHAO,B.CM_FID,B.CM_CONTR,A.TSA_ID,B.TSA_MAP,B.TSA_ENGNAME,B.TSA_NUMBER,B.CM_JHTIME,A.*,c.* 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_FID=B.CM_FID 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 A.TFO_DOCNUM='" + txt_docnum.Text.ToString() + "'"; DBCallCommon.BindRepeater(PM_Finished_lookRepeater, sqltext); }
private void PM_GongShi_List_Repeaterdatabind() { string sqltext = "select a.*,b.CM_CONTR,b.TSA_MAP,c.CM_CUSNAME from TBMP_GS_LIST AS a LEFT JOIN TBCM_FHBASIC AS b ON a.TSA_ID=b.TSA_ID LEFT JOIN TBCM_APPLICA AS c ON b.CM_CONTR=c.CM_CONTR where a.DOCUNUM='" + txt_docunum.Text.ToString() + "'"; DBCallCommon.BindRepeater(PM_GongShi_List_Repeater, sqltext); }