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);
}
