//库存物料信息
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);
}
