protected void Page_Load(object sender, EventArgs e)
{
Delete.Click += new EventHandler(Delete_Click);
Delete.Attributes.Add("OnClick", "Javascript:return confirm('你确定删除吗?');");
if (!IsPostBack)
{
GetParent();
if (Request.QueryString["ID"] != null)
{
string pid = "";
string sql = "SELECT WS_FATHERID FROM TBWS_WAREHOUSE WHERE WS_ID='" + Request.QueryString["ID"] + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sql);
if (dr.Read())
{
pid = dr["WS_FATHERID"].ToString();
}
dr.Close();
DDLParent.Items.FindByValue(pid).Selected = true;
}
GetData();
}
CheckUser(ControlFinder);
}
/*********************得到我的质检修改审批任务的数量*************************/
//private void Getshnum()
//{
// string userid = Session["UserID"].ToString();
// string strid = userid.Substring(0, 2);
// if (strid == "05")
// {
// string sqltext = "select count(*) from View_ZJXGSH_APLYFORINSPECT where AFI_STATUS='0' AND AFI_FIR_PERID='" + userid + "' and AFI_FIR_JG is null ";
// SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext);
// if (dr.Read())
// {
// string num = dr[0].ToString();
// if (num == "0")
// {
// lb_shnum.Visible = false;
// }
// else
// {
// lb_shnum.Visible = true;
// lb_shnum.Text = "(" + num + ")";
// }
// }
// dr.Close();
// }
// if (strid == "07")
// {
// string sqltext2 = "select count(*) from View_ZJXGSH_APLYFORINSPECT where AFI_STATUS='0' AND AFI_SEC_PERID='" + userid + "' and AFI_SEC_JG is null ";
// SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext2);
// if (dr.Read())
// {
// string num = dr[0].ToString();
// if (num == "0")
// {
// lb_shnum.Visible = false;
// }
// else
// {
// lb_shnum.Visible = true;
// lb_shnum.Text = "(" + num + ")";
// }
// }
// dr.Close();
// }
//}
private void GetMyBaoJian()
{
string sqlText = "";
string aa_js = "select r_name from TBDS_STAFFINFO where st_id='" + Session["UserID"].ToString() + "' ";
DataTable dt_r_js = DBCallCommon.GetDTUsingSqlText(aa_js);
if (Session["UserDeptID"].ToString() != "12" && dt_r_js.Rows[0]["R_NAME"].ToString() != "'质量通用角色'")
{
//如果此人不是质量部的，也就是报检人，那么他默认看到的就是他自己报检之后的不合格的。
sqlText = "select count(*) from TBQM_APLYFORINSPCT where AFI_STATE='1' AND AFI_MAN='" + Session["UserID"].ToString() + "' and AFI_ENDRESLUT='不合格' and AFI_ID not in(select AFI_ID from (select count(*) as countresult,AFI_ID from (select distinct * from (select case when RESULT='合格' then '让步接收' else RESULT end as RESULT,AFI_ID from (select * from TBQM_APLYFORINSPCT where UNIQUEID in(select UNIQUEID from TBQM_APLYFORITEM where RESULT='让步接收')) as a left join TBQM_APLYFORITEM as b on a.UNIQUEID=b.UNIQUEID)s)t group by AFI_ID)m where countresult=1)";
//pager.StrWhere = "AFI_STATE='0' AND AFI_MAN='" + Session["UserID"].ToString() + "'";
}
else
{ //如果此人是质量部的，那个他看到的是全部未质检的
sqlText = "select count(*) from TBQM_APLYFORINSPCT where AFI_STATE='0' and AFI_QCMAN='" + Session["UserID"].ToString() + "'";
}
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
if (dr[0].ToString() == "0")
{
lb_baojian.Visible = false;
}
else
{
lb_baojian.Visible = true;
lb_baojian.Text = "(" + dr[0].ToString() + ")";
}
}
dr.Close();
}
private void GetTotalAmount(string strWhere)
{
string sql = string.Empty;
if (string.IsNullOrEmpty(strWhere))
{
sql = "select cast(sum(num) as float) as num,cast(sum(ordernum) as float) as ordernum,cast(sum(innum) as float) as innum,cast(sum(outnum) as float) as outnum,cast(sum(isnull(outnum,0)-isnull(num,0)) as float) as difnum from View_SM_MaterialFlow ";
}
else
{
sql = "select cast(sum(num) as float) as num,cast(sum(ordernum) as float) as ordernum,cast(sum(innum) as float) as innum,cast(sum(outnum) as float) as outnum,cast(sum(isnull(outnum,0)-isnull(num,0)) as float) as difnum from View_SM_MaterialFlow where " + strWhere;
}
SqlDataReader sdr = DBCallCommon.GetDRUsingSqlText(sql);
if (sdr.Read())
{
HiddenFieldNum.Value = sdr["num"].ToString();
HiddenFieldOrderNum.Value = sdr["ordernum"].ToString();
HiddenFieldInNum.Value = sdr["innum"].ToString();
HiddenFieldOutNum.Value = sdr["outnum"].ToString();
HiddenFieldDifNum.Value = sdr["difnum"].ToString();
}
sdr.Close();
}
//通过发票记录编号获取数据
private void BindDataEdit(string BillCode)
{
string sqlstr = "select OB_CODE,OB_DDCODE,OB_DDZJE,OB_BILLCODE,OB_BILLNUM,OB_BILLJE,OB_KPDATE,OB_SPDATE,OB_CSCODE,OB_CSNAME,OB_JBR,OB_PZ,OB_PZH,OB_NOTE from TBPM_ORDER_Bill where OB_CODE='" + OBCode + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlstr);
if (dr.HasRows)
{
dr.Read();
txtJLID.Text = dr["OB_CODE"].ToString().Trim();
txtKPRQ.Text = Convert.ToDateTime(dr["OB_KPDATE"].ToString()).ToShortDateString();
//txtDDQKRQ.Text = Convert.ToDateTime(dr["DQ_DATA"].ToString()).ToShortDateString();
txtDDCode.Text = dr["OB_DDCODE"].ToString().Trim();
txtDDZJE.Text = dr["OB_DDZJE"].ToString().Trim();
txtCSCode.Text = dr["OB_CSCODE"].ToString().Trim();
txtCSName.Text = dr["OB_CSNAME"].ToString().Trim();
txtFPDH.Text = dr["OB_BILLCODE"].ToString().Trim();
txtFPSL.Text = dr["OB_BILLNUM"].ToString().Trim();
txtKPJE.Text = dr["OB_BILLJE"].ToString().Trim();
txtJBR.Text = dr["OB_JBR"].ToString().Trim();
//txtSPRQ.Text = Convert.ToDateTime(dr["OB_SPDATE"].ToString()).ToShortDateString();
txtSPRQ.Text = (dr["OB_SPDATE"].ToString().Trim() == "" ? "" : Convert.ToDateTime(dr["OB_SPDATE"].ToString().Trim()).ToShortDateString());
foreach (ListItem li in rblPZ.Items)
{
if (dr["OB_PZ"].ToString() == li.Value.ToString())
{
li.Selected = true; break;
}
}
txtNote.Text = dr["OB_NOTE"].ToString().Trim();
dr.Close();
}
}
/// <summary>
/// 初始化页面(基本信息)
/// </summary>
private void InitInfo()
{
string tsa_id = "";
string[] fields;
string sqlText = "";
tsa_id = Request.QueryString["action"];
fields = tsa_id.Split('-');
sqlText = "select CM_PROJ,TSA_ENGNAME,TSA_ENGSTRTYPE,TSA_PJID ";
sqlText += "from View_TM_TaskAssign where TSA_ID='" + tsa_id + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
tsaid.Text = tsa_id;
proname.Text = dr[0].ToString();
engname.Text = dr[1].ToString();
eng_type.Value = dr[2].ToString();
}
dr.Close();
this.GetListName();
this.BindLastFive();
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString["FLAG"] == "ADD")
{
Confirm.Text = "添加";
}
else
{
Confirm.Text = "修改";
}
if (!IsPostBack)
{
GetParent();
if (Request.QueryString["FLAG"].ToString() == "MODI")
{
string id = Request.QueryString["ID"];
string sql = "SELECT * FROM TBWS_LOCATION WHERE WL_ID='" + id + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sql);
if (dr.Read())
{
TextBoxName.Text = dr["WL_NAME"].ToString();
DropDownListParent.Items.FindByValue(dr["WL_WSID"].ToString()).Selected = true;
DropDownListParent.Enabled = false;
TextBoxNote.Text = dr["WL_NOTE"].ToString();
}
dr.Close();
}
}
}
protected void delete_Click(object sender, EventArgs e)
{
List <string> bpId = new List <string>();
string sqlText = "";
string strID = "";
//int rowEffected = 0;
foreach (RepeaterItem labID in Repeater1.Items)
{
CheckBox chk = (CheckBox)labID.FindControl("CheckBox1");
if (chk.Checked)
{
//查找该CheckBox所对应纪录的id号,在labID中
strID = ((Label)labID.FindControl("bp_ID")).Text;
bpId.Add(strID);
}
}
lbl_Info.Text += strID;
foreach (string id in bpId)
{
sqlText = "DELETE FROM TBBS_BIDPRICEINFO WHERE BP_ID = '" + id + "' ";
DBCallCommon.GetDRUsingSqlText(sqlText);
//rowEffected++;
}
//防止刷新
Response.Redirect("CM_Bus_Contract.aspx?q=1");
}
void showcurrentBP_INFO(string id)
{
string cmdStr = "SELECT BP_BIDTYPE, BP_PRONAME, BP_DEVICENAME, BP_DVCNORM, BP_NUM, BP_CUSTMID, BP_BSCGCLERK, BP_TCCGCLERK, BP_ACPDATE, BP_YEAR, BP_BIDDATE, BP_BIDSTYLE,BP_ISSUER , BP_STATUS, BP_NOTE FROM TBBS_BIDPRICEINFO WHERE BP_ID=" + id;
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(cmdStr);
while (dr.Read())
{
ddl_lx.SelectedItem.Value = dr["BP_BIDTYPE"].ToString();
bp_PRONAME.Text = dr["BP_PRONAME"].ToString();
bp_DEVICENAME.Text = dr["BP_DEVICENAME"].ToString();
bp_DVCNORM.Text = dr["BP_DVCNORM"].ToString();
bp_NUM.Text = dr["BP_NUM"].ToString();
bp_CUSTMID.Text = dr["BP_CUSTMID"].ToString();
buperson.Value = dr["BP_BSCGCLERK"].ToString();
bp_CUSTMTeL.Text = dr["BP_TCCGCLERK"].ToString();
bp_ACPDATE.Value = dr["BP_ACPDATE"].ToString();
bp_YEAR.Value = dr["BP_YEAR"].ToString();
bp_BIDDATE.Value = dr["BP_BIDDATE"].ToString();
bp_BIDSTYLE.Text = dr["BP_BIDSTYLE"].ToString();
bp_ISSUER.Text = dr["BP_ISSUER"].ToString();
bp_STATUS.SelectedValue = dr["BP_STATUS"].ToString();
bp_NOTE.Text = dr["BP_NOTE"].ToString();
}
dr.Close();
}
//生成请款单号 2013年1月10日 09:10:15
//格式为：ZCZJ.CG.DDQK.2013.01.0001
private string Encode()
{
string DQ_ID = "";
string str_time = DateTime.Now.ToString("yyyy.MM");
string str = "select top 1 DQ_ID from TBPM_Order_CheckRequest where DQ_ID like '%" + str_time + "%' order by DQ_ID desc";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(str);
string lsh = "";
string ID = "";
if (dr.HasRows)
{
dr.Read();
ID = dr["DQ_ID"].ToString();
string[] pr = ID.Split('-');
lsh = (Convert.ToInt16(pr[pr.Length - 1].ToString()) + 1).ToString();
lsh = lsh.PadLeft(4, '0');
dr.Close();
}
else
{
lsh = "0001";
}
DQ_ID = "ZCZJ.CG.DDQK." + str_time + "-" + lsh;
return(DQ_ID);
}
/// <summary>
/// 对当前数据能否拆分的检查
/// </summary>
/// <returns></returns>
protected string CheckCurernt()
{
/*************
* 1、已提交明细部件不能拆分
* 2、变更删除部件不能拆分
* ***********/
string sql_1 = "select BM_XUHAO from " + ViewState["view_table"] + " where BM_TASKID='" + ViewState["TaskIDSplit"].ToString() + "' AND BM_XUHAO='" + ViewState["Xuhao"].ToString() + "' AND BM_MSSTATE='1'";
System.Data.SqlClient.SqlDataReader dr_1 = DBCallCommon.GetDRUsingSqlText(sql_1);
if (dr_1.HasRows)
{
return(@"alert('序号【" + ViewState["Xuhao"].ToString() + "】明细已提交，无法拆分！！！')");
}
dr_1.Close();
string sql_2 = "select BM_XUHAO from " + ViewState["view_table"] + " where BM_TASKID='" + ViewState["TaskIDSplit"].ToString() + "' AND BM_XUHAO='" + ViewState["Xuhao"].ToString() + "' AND (BM_MSSTATUS='1' or BM_MPSTATUS='1' or BM_OSSTATUS='1')";
System.Data.SqlClient.SqlDataReader dr_2 = DBCallCommon.GetDRUsingSqlText(sql_2);
if (dr_2.HasRows)
{
return(@"alert('序号【" + ViewState["Xuhao"].ToString() + "】为变更删除记录，无法拆分！！！')");
}
dr_2.Close();
return("OK");
}
private void bind_info2()
{
string sqltext = "select CODE,APPLYNAME,APPLYID,APPLYDATE,APPLYPHONE,BUMENID,BUMENNAME,SHENHEID,SHENHENAME,STATE,SHITANGID,SHITANGNAME,USETIME,PEOPLENUM,PEOPLEGUIGE,NOTE,ALLMONEY,SHENHENOTE,YCTYPE from TBOM_EAT where CODE='" + id + "' AND TYPE='JL'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext);
if (dr.Read())
{
applyname_jl = dr["APPLYNAME"].ToString();
applydate_jl = dr["APPLYDATE"].ToString();
fzr_jl = dr["SHENHENAME"].ToString();
fzrid_jl = dr["SHENHEID"].ToString();
applyphone_jl = dr["APPLYPHONE"].ToString();
peopleguige_jl = dr["PEOPLEGUIGE"].ToString();
peoplenum_jl = dr["PEOPLENUM"].ToString();
usetime_jl = dr["USETIME"].ToString();
note_jl = dr["NOTE"].ToString();
allmoney_jl = dr["ALLMONEY"].ToString();
state_jl = dr["STATE"].ToString();
//zhaungtai.Text = dr["STATE"].ToString();
//shenehnote_jl = dr["SHENHENOTE"].ToString();
shenhenote3.Text = dr["SHENHENOTE"].ToString();
rblfirst2.SelectedValue = dr["STATE"].ToString();
txt_fankuiren.Text = dr["SHENHENAME"].ToString();
txt_fankuirenid.Value = dr["SHENHEID"].ToString();
YCTP_JL = dr["YCTYPE"].ToString();
}
dr.Close();
}
//生成MTO单号
protected string generateCode()
{
string Code = "";
string sql = "SELECT MAX(MTO_CODE) AS MaxCode FROM TBWS_MTO WHERE LEN(MTO_CODE)=10";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sql);
if (dr.Read())
{
if (dr["MaxCode"] != DBNull.Value)
{
Code = dr["MaxCode"].ToString();
}
}
dr.Close();
if (Code == "")
{
return("MTO0000001");
}
else
{
int tempnum = Convert.ToInt32((Code.Substring(3, 7)));
tempnum++;
Code = "MTO" + tempnum.ToString().PadLeft(7, '0');
return(Code);
}
}
/// <summary>
/// 检验物料编码与数据是否重复
/// </summary>
/// <param name="array_check"></param>
/// <param name="capacity"></param>
/// <returns></returns>
private string CheckMarReapteInDB(string[,] array_check, int capacity)
{
string retVal = "False";//没有重复的
string sql = "";
string typeid = "";
for (int i = 0; i < capacity; i++)
{
switch (array_check[i, 5])
{
case "1": typeid = "01.08";
break;
default:
typeid = "01.11";
break;
}
sql = "select * from TBMA_MATERIAL where TYPEID='" + typeid + "' and MNAME='" + array_check[i, 0] + "' AND GUIGE='" + array_check[i, 1] + "' AND CAIZHI='" + array_check[i, 2] + "' AND GB='" + array_check[i, 3] + "' and STATE='1'";//在用的物料中是否存在与添加物料重复的
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sql);
if (dr.HasRows)
{
dr.Read();
retVal = "TrueMarDB-第" + array_check[i, 4] + "行输入将导致物料重复\\r已存在物料信息>>\\r物料编码:" + dr["ID"].ToString() + " 名称:" + dr["MNAME"].ToString() + " 助记码:" + dr["HMCODE"].ToString();
dr.Close();
break;
}
}
return(retVal);
}
private void Initpagemess()
{
string sqltext = "";
string pcode = Server.UrlDecode(Request.QueryString["pcode"].ToString());
sqltext = "SELECT PR_PCODE, PR_PJID, PJ_NAME, PR_ENGID, TSA_ENGNAME," +
"PR_REVIEWA, PR_REVIEWANM, PR_REVIEWATIME, PR_REVIEWB, PR_REVIEWBNM, " +
"PR_REVIEWBTIME, PR_REVIEWBADVC, PR_STATE, PR_NOTE " +
"FROM View_TBPC_MARSTOUSETOTAL where PR_PCODE='" + pcode + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext);
while (dr.Read())
{
TextBox_pid.Text = dr["PR_PCODE"].ToString();
tb_pjid.Text = dr["PR_PJID"].ToString();
tb_pjname.Text = dr["PJ_NAME"].ToString();
tb_pjinfo.Text = tb_pjid.Text + tb_pjname.Text;
tb_engid.Text = dr["PR_ENGID"].ToString();
tb_engname.Text = dr["TSA_ENGNAME"].ToString();
tb_enginfo.Text = tb_engid.Text + tb_engname.Text;
tb_peoid.Text = dr["PR_REVIEWA"].ToString();
tb_peoname.Text = dr["PR_REVIEWANM"].ToString();
Tb_shijian.Text = dr["PR_REVIEWATIME"].ToString();
tb_zh.Text = dr["PR_ENGID"].ToString();
}
dr.Close();
}
/// <summary>
/// 初始化页面(基本信息)
/// </summary>
private void InitInfo()
{
string tsa_id = "";
string sqlText = "";
tsa_id = Request.QueryString["action"];
sqlText = "select CM_PROJ,TSA_ENGNAME,TSA_ENGSTRTYPE,TSA_PJID ";
sqlText += "from View_TM_TaskAssign where TSA_ID='" + tsa_id + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
tsaid.Text = tsa_id;
proname.Text = dr[0].ToString();
engname.Text = dr[1].ToString();
eng_type.Value = dr[2].ToString();
pro_id.Value = dr[3].ToString();
}
dr.Close();
//读取台数
string sql = "select TSA_NUMBER from View_TM_TaskAssign where TSA_ID='" + tsa_id.Split('-')[0] + "'";
SqlDataReader dr_number = DBCallCommon.GetDRUsingSqlText(sql);
if (dr_number.HasRows)
{
dr_number.Read();
lblNumber.Text = dr_number["TSA_NUMBER"].ToString();
dr_number.Close();
}
}
private void databind()
{
string sqltext = "";
string[] Arry;
Arry = Request.QueryString["ptcode_rcode"].Split(',');
//string[] stringSeparators = new string[] {"//"};
//string ptcodercode = ptcode_rcode;
string providerid = "";
string ptcode1 = Arry[0].ToString();
string rcode = Arry[Arry.Length - 1].ToString();//制单人ID
sqltext = "SELECT supplierresid from View_TBMP_IQRCMPPRICE_RVW1 where PIC_ID='" + ptcode1 + "'";
SqlDataReader dr2 = DBCallCommon.GetDRUsingSqlText(sqltext);
while (dr2.Read())
{
providerid = dr2[0].ToString();
}
dr2.Close();
sqltext = "SELECT distinct TO_DOCNUM, TO_SUPPLYID, TO_SUPPLYNAME,TO_ZDR, TO_ZDRNAME,TO_ZDTIME " +
"FROM View_TBMP_Order " +
"where TO_ZDR='" + rcode + "' and TO_SUPPLYID='" + providerid + "'";
DataTable dt = DBCallCommon.GetDTUsingSqlText(sqltext);
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void HTBH_Textchanged(object sender, EventArgs e)
{
string htbh = "";
if (HTBH.Text.ToString().Contains("|"))
{
htbh = HTBH.Text.Substring(0, HTBH.Text.ToString().IndexOf("|"));
HTBH.Text = htbh;
string a = "select PCON_BCODE,PCON_PJNAME,PCON_ENGNAME from TBPM_CONPCHSINFO where PCON_BCODE='" + HTBH.Text.ToString() + "'";
SqlDataReader dr2 = DBCallCommon.GetDRUsingSqlText(a);
if (dr2.HasRows)
{
dr2.Read();
txtXMMC.Text = dr2["PCON_PJNAME"].ToString();
txtGCMC.Text = dr2["PCON_ENGNAME"].ToString();
//索赔单号
this.GreatCode(HTBH.Text);
dr2.Close();
}
}
else
{
txtXMMC.Text = "";
txtGCMC.Text = "";
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "", "alert('请填写有效的合同号！');", true); return;
}
}
protected void delete_Click(object sender, EventArgs e)
{
List <string> eng_ID = new List <string>();
string strID = "";
int rowEffected = 0;
string sql_checkEngidUsed = "";
foreach (RepeaterItem labID in Reproject1.Items)
{
CheckBox chk = (CheckBox)labID.FindControl("CheckBox1");
if (chk.Checked)
{
//查找该CheckBox所对应纪录的id号,在labID中
strID = ((Label)labID.FindControl("eng_ID")).Text;
sql_checkEngidUsed = "select TSA_STFORCODE from TBPM_TCTSASSGN where TSA_STFORCODE='" + strID + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sql_checkEngidUsed);
if (dr.HasRows)
{
Response.Write("<script>alert('工程代号:【" + strID + "】已被引用,无法删除！！！')</script>");
return;
}
eng_ID.Add(strID);
}
}
lbl_Info.Text += strID;
foreach (string id in eng_ID)
{
DBCallCommon.DeleteENGByENG_ID(id);
rowEffected++;
}
//防止刷新
Response.Redirect("enginfo.aspx?q=1");
Response.Write("<script>alert('数据已删除！！！\\r\\r提示:共删除" + rowEffected + "条记录')</script>");
}
protected string generateCode()
{
string Datestring = DateTime.Now.ToString("yyyyMMdd");
string Code = "";
string sql = "SELECT MAX(PD_CODE) AS MaxCode FROM TBWS_INVENTORYSCHEMA " +
"WHERE CHARINDEX('" + Datestring + "',PD_CODE)>0";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sql);
if (dr.Read())
{
if (dr["MaxCode"] != DBNull.Value)
{
Code = dr["MaxCode"].ToString();
}
}
dr.Close();
if (Code == "")
{
return(Datestring + "01");
}
else
{
int codenum = Convert.ToInt32(Code);
codenum++;
Code = codenum.ToString().PadLeft(10, '0');
return(Code);
}
}
/*********************得到我的报检任务的数量*************************/
private void GetMyBaoJian()
{
if (Session["UserDept"].ToString() == " ")
{
//如果此人不是质量部的，也就是报检人，那么他默认看到的就是他自己报检之后的未质检的。
//string sqlText = "select count(*) from TBQM_APLYFORINSPCT where AFI_STATE='1' AND AFI_MAN='" + Session["UserID"].ToString() + "'";
//pager.StrWhere = "AFI_STATE='0' AND AFI_MAN='" + Session["UserID"].ToString() + "'";
}
else
{ //如果此人是质量部的，那个他看到的是全部未质检的
string sqlText = "select count(*) from TBQM_APLYFORINSPCT where AFI_STATE='0' and AFI_QCMAN='" + Session["UserID"].ToString() + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
if (dr[0].ToString() == "0")
{
lb_baojian.Visible = false;
}
else
{
lb_baojian.Visible = true;
lb_baojian.Text = "(" + dr[0].ToString() + ")";
}
}
dr.Close();
}
}
//生成发票记录编号
private string EnDDBillCode()
{
string OB_CODE = "";
string str_time = DateTime.Now.ToString("yyyy.MM");
string str = "select top 1 OB_CODE from TBPM_Order_BILL where OB_CODE like '%" + str_time + "%' order by OB_CODE desc";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(str);
string lsh = "";
string ID = "";
if (dr.HasRows)
{
dr.Read();
ID = dr["OB_CODE"].ToString();
string[] pr = ID.Split('-');
lsh = (Convert.ToInt16(pr[pr.Length - 1].ToString()) + 1).ToString();
lsh = lsh.PadLeft(4, '0');
dr.Close();
}
else
{
lsh = "0001";
}
OB_CODE = "ZCZJ.CG.BILL." + str_time + "-" + lsh;
return(OB_CODE);
}
//绑定基本信息
private void BindBaseData()
{
//基本信息
string sqltext = "select a.*,b.CRD_NOTE from TBCM_ADDCON as a,TBCR_CONTRACTREVIEW_DETAIL as b" +
" where a.CR_ID='" + id + "' and a.CR_ID=b.CRD_ID and b.CRD_PID='" + Session["UserID"].ToString() + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext);
if (dr.HasRows)
{
dr.Read();
LBpsdh.Text = dr["CR_ID"].ToString();
tb_conid.Text = dr["CON_ID"].ToString();
TextXMMC.Text = dr["CON_XMMC"].ToString();
TextSBMC.Text = dr["CON_SBMC"].ToString();
TextJE.Text = dr["CON_JIN"].ToString();
txt_zdrYJ.Text = dr["CRD_NOTE"].ToString();
TextFBS.Text = dr["CON_FBSMC"].ToString();
TextFBFW.Text = dr["CON_FBFW"].ToString();
txt_BZ.Text = dr["CON_NOTE"].ToString();
ddl_htlx.SelectedValue = dr["CON_TYPE"].ToString();
dr.Close();
}
}
protected void rptProNumCost_OnItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
System.Web.UI.WebControls.Label lbprojname = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbprojname");
System.Web.UI.WebControls.Label lbprojid = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbprojid");
System.Web.UI.WebControls.Label lbrwh = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbrwh");
System.Web.UI.WebControls.Label lbth = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbth");
System.Web.UI.WebControls.Label lbsbname = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbsbname");
System.Web.UI.WebControls.Label lbsl = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbsl");
System.Web.UI.WebControls.Label lbbymymoney = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbbymymoney");
System.Web.UI.WebControls.Label lbbyrealmoney = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbbyrealmoney");
System.Web.UI.WebControls.Label lbyear = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbyear");
System.Web.UI.WebControls.Label lbmonth = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbmonth");
System.Web.UI.WebControls.Label lbtype = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbtype");
}
if (e.Item.ItemType == ListItemType.Footer)
{
string sqlhj = "select cast(isnull(CAST(sum(CNFB_BYMYMONEY) AS FLOAT),0) as decimal(12,2)) as BYMYMONEYHJ,cast(isnull(CAST(sum(CNFB_BYREALMONEY) AS FLOAT),0) as decimal(12,2)) as BYREALMONEYHJ from TBMP_CNFB_LIST where " + ViewState["StrWhere"].ToString();
SqlDataReader drhj = DBCallCommon.GetDRUsingSqlText(sqlhj);
if (drhj.Read())
{
myjehj = Convert.ToDouble(drhj["BYMYMONEYHJ"]);
sjjehj = Convert.ToDouble(drhj["BYREALMONEYHJ"]);
}
drhj.Close();
System.Web.UI.WebControls.Label lbmyjehj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbmyjehj");
System.Web.UI.WebControls.Label lbsjjehj = (System.Web.UI.WebControls.Label)e.Item.FindControl("lbsjjehj");
lbmyjehj.Text = myjehj.ToString();
lbsjjehj.Text = sjjehj.ToString();
}
}
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);
}
private void InitInfo()
{
if (Request.QueryString["action"] != null)
{
pk_no.Value = Request.QueryString["action"];
status.Value = "0";
}
else
{
string[] fields = Request.QueryString["id"].ToString().Split('.');
pk_no.Value = fields[0].ToString() + '.' + fields[1].ToString();
status.Value = fields[2].ToString();
if (int.Parse(status.Value) > 1)
{
Response.Redirect("TM_Packing_List_Audit.aspx?id=" + pk_no.Value);
}
}
sqlText = "select PLT_CONTRACTOR,PLT_OWNER,PLT_SHIPNO,PLT_SYSTEMNUM,PLT_GOODSNAME,";
sqlText += "PLT_DELIVERYDATE,PLT_SUBMITNM from TBPM_PACKLISTTOTAL ";
sqlText += "where PLT_PACKLISTNO='" + pk_no.Value + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
Gen_Contractor.Value = dr[0].ToString();
Owner.Value = dr[1].ToString();
Ship_No.Value = dr[2].ToString();
Sys_No.Value = dr[3].ToString();
Goods_Name.Value = dr[4].ToString();
Con_Date.Value = dr[5].ToString();
Signature.Value = dr[6].ToString();
}
dr.Close();
GetPkData();
}
/// <summary>
/// 初始化页面(基本信息)
/// </summary>
private void InitInfo()
{
string tsa_id = "";
string[] fields;
string sqlText = "";
tsa_id = Request.QueryString["action"];
fields = tsa_id.Split('-');
sqlText = "select TSA_PJNAME,TSA_ENGNAME,TSA_ENGSTRTYPE,TSA_PJID ";
sqlText += "from View_TM_TaskAssign where TSA_ID='" + tsa_id + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
tsaid.Text = tsa_id;
proname.Text = dr[0].ToString();
engname.Text = dr[1].ToString();
eng_type.Value = dr[2].ToString();
pro_id.Value = dr[3].ToString();
}
dr.Close();
this.GetListName();
string arry = Request.QueryString["arry"];
if (arry != "undefined")
{
txtItem.Text = arry;
this.ClickButton();
}
}
protected void engid_SelectedIndexChanged(object sender, EventArgs e)
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
GridViewRow gr = GridView1.Rows[i];
engid = (ComboBox)gr.FindControl("engid");
string SeleText = engid.SelectedValue;
int SeleIndex = engid.SelectedIndex;
BindEng(gr);
engid.SelectedIndex = SeleIndex;
if (SeleText != "-请选择-")
{
fields = SeleText.Split('‖');
engcode = fields[0].ToString();
engid.SelectedItem.Text = engcode;
sqlText = "select ENG_NAME,ENG_STRTYPE from TBPM_ENGINFO ";
sqlText += "where ENG_ID='" + engcode + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
gr.Cells[5].Text = dr[1].ToString();
}
dr.Close();
}
}
}
/// <summary>
/// 初始化页面
/// </summary>
protected void InitPage()
{
string tsa_id = "";
string[] fields;
string sqlText = "";
tsa_id = Request.QueryString["TaskID"].ToString();
ViewState["Marid"] = Request.QueryString["Marid"].ToString();
fields = tsa_id.Split('-');
sqlText = "select CM_PROJ,TSA_ENGNAME,TSA_PJID ";
sqlText += "from View_TM_TaskAssign where TSA_ID='" + tsa_id + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqlText);
if (dr.Read())
{
tsaid.Text = tsa_id;
proname.Text = dr[0].ToString();
engname.Text = dr[1].ToString();
}
dr.Close();
this.GetListName();
this.AbleToReplace();
this.UnalbeToReplace();
}
protected string generateTempCode()
{
List <string> lt = new List <string>();
string sql = "SELECT Code FROM TBOM_BGYP_INCODE WHERE len(Code)=11 and left(Code,2)='CO'";
SqlDataReader sdr = DBCallCommon.GetDRUsingSqlText(sql);
if (sdr.HasRows)
{
while (sdr.Read())
{
lt.Add(sdr["Code"].ToString());
}
}
sdr.Close();
string[] wsidlist = lt.ToArray();
if (wsidlist.Count <string>() == 0)
{
return("CO000000001");
}
else
{
string tempstr = wsidlist.Max <string>();
int tempnum = Convert.ToInt32((tempstr.Substring(2, 9)));
tempnum++;
tempstr = "CO" + tempnum.ToString().PadLeft(9, '0');
return(tempstr);
}
}
private void initpagemess()
{
string sqltext = "";
TextBox_pid.Text = Request.QueryString["mpcode"].ToString();//相似代用单号
sqltext = "select pjid AS MP_PJID,pjnm AS MP_PJNAME,engid AS MP_ENGID,engnm AS MP_ENGNAME," +
"zdrid AS MP_FILLFMID,zdrnm as MP_FILLFMNM,zdtime as MP_FILLFMTIME,zdwctime " +
"from View_TBPC_MARREPLACE_total_planrvw where mpcode='" + TextBox_pid.Text + "'";
SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sqltext);
while (dr.Read())
{
tb_pjid.Text = dr["MP_PJID"].ToString();
tb_pjname.Text = dr["MP_PJNAME"].ToString();
tb_pjinfo.Text = tb_pjid.Text + tb_pjname.Text;
tb_engid.Text = dr["MP_ENGID"].ToString();
tb_engname.Text = dr["MP_ENGNAME"].ToString();
tb_enginfo.Text = tb_engid.Text + tb_engname.Text;
tb_peoid.Text = dr["MP_FILLFMID"].ToString();
tb_peoname.Text = dr["MP_FILLFMNM"].ToString();
Tb_shijian.Text = dr["MP_FILLFMTIME"].ToString();
tb_zh.Text = dr["MP_ENGID"].ToString();
}
dr.Close();
tbpc_marrepallRepeaterdatabind();
}
