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