private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "" }; string[] sparas = { "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_rpt585102dx141st3_factidFilter"); sparasname[1] = "@infactid"; sparas[1] = str[0]; //日期 str = Request.Form.GetValues("ui_rpt585102dx141st3_sdateFilter"); sparasname[2] = "@insdate"; string[] datestrs = str[0].Split(new char[] { '-' }); string strYear = "0000" + datestrs[0]; string strMonth = "00" + datestrs[1]; string strDay = "00" + datestrs[2]; sparas[2] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); sparasname[3] = "@inuser"; sparas[3] = ""; DataTable dt = new ZGZY.BLL.Report().rpt585102dx141("sp_webp585102_dx141_3_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "" }; string[] sparas = { "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590209_st1_factidFilter"); sparasname[1] = "@infactid"; sparas[1] = str[0]; //shipid str = Request.Form.GetValues("ui_cqcp590209_st1_shipidFilter"); sparasname[2] = "@inshipid"; sparas[2] = str[0]; try { DataTable dt = new ZGZY.BLL.Report().cqcp590209_st1("sp_cqcp590209_st1_web_new", sparasname, sparas); return(dt); } catch { //关闭加载提示 Response.Write("<script type='text/javascript'>top.dclose_cqcp590209_st1();</script>"); } return(null); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "" }; string[] sparas = { "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590102_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //强度 str = Request.Form.GetValues("ui_cqcp590102_strengthFilter"); sparasname[2] = "@instrength"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[2] = sparas[2] + str[i] + "|"; } } } else { sparas[2] = "ZZ"; } //不使用 sparasname[3] = "@inupdid"; sparas[3] = "0"; DataTable dt = new ZGZY.BLL.Report().cqcp590102("sp_cqcp590102_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "" }; string[] sparas = { "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590206_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //查询年月 sparasname[2] = "@inyyyymm"; str = Request.Form.GetValues("ui_cqcp590206_yymmFilter"); string[] datestrs = str[0].Split(new char[] { '-' }); string strYear = "0000" + datestrs[0]; string strMonth = "00" + datestrs[1]; sparas[2] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2); //不使用 sparasname[3] = "@inupdid"; sparas[3] = ""; DataTable dt = new ZGZY.BLL.Report().cqcp590206("sp_cqcp590206_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "" }; string[] sparas = { "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590101_st1_factidFilter"); sparasname[1] = "@infactid"; sparas[1] = str[0]; DataTable dt = new ZGZY.BLL.Report().cqcp590101_st1("sp_cqcp590101_st1_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "", "", "", "" }; string[] sparas = { "", "", "", "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590405_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //日期 str = Request.Form.GetValues("ui_cqcp590405_begdateFilter"); sparasname[2] = "@inbegdate"; string[] datestrs = str[0].Split(new char[] { '-' }); string strYear = "0000" + datestrs[0]; string strMonth = "00" + datestrs[1]; string strDay = "00" + datestrs[2]; sparas[2] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); str = Request.Form.GetValues("ui_cqcp590405_enddateFilter"); sparasname[3] = "@inenddate"; datestrs = str[0].Split(new char[] { '-' }); strYear = "0000" + datestrs[0]; strMonth = "00" + datestrs[1]; strDay = "00" + datestrs[2]; sparas[3] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); //排序 str = Request.Form.GetValues("ui_cqcp590405_sortFilter"); sparasname[4] = "@insort"; if (str != null) { sparas[4] = str[0]; if (string.IsNullOrEmpty(sparas[4].Trim())) { sparas[4] = "1"; } } else { sparas[4] = "1"; } //用户 sparasname[5] = "@inuserid"; HttpContext _context = HttpContext.Current; ZGZY.Model.User user = ZGZY.Common.UserHelper.GetUser(_context); //获取cookie里的用户对象 sparas[5] = user.UserId;; //机别 str = Request.Form.GetValues("ui_cqcp590405_bujinoFilter"); sparasname[6] = "@inbujino"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[6] = sparas[6] + str[i] + "|"; } } } else { sparas[6] = "ZZ"; } DataTable dt = new ZGZY.BLL.Report().cqcp590405("sp_cqcp590405_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "", "", "", "", "", "", "" }; string[] sparas = { "", "", "", "", "", "", "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590401_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //日期 str = Request.Form.GetValues("ui_cqcp590401_begdateFilter"); sparasname[2] = "@inbegdatetime"; sparas[2] = str[0]; str = Request.Form.GetValues("ui_cqcp590401_enddateFilter"); sparasname[3] = "@inenddatetime"; sparas[3] = str[0]; //强度 str = Request.Form.GetValues("ui_cqcp590401_strengthFilter"); sparasname[4] = "@instrength"; if (str != null) { sparas[4] = str[0]; if (string.IsNullOrEmpty(sparas[4].Trim())) { sparas[4] = "ZZ"; } } else { sparas[4] = "ZZ"; } //工程名称 str = Request.Form.GetValues("ui_cqcp590401_engnameFilter"); sparasname[5] = "@inengname"; if (str != null) { sparas[5] = str[0]; if (string.IsNullOrEmpty(sparas[5].Trim())) { sparas[5] = "ZZ"; } } else { sparas[5] = "ZZ"; } //施工部位 str = Request.Form.GetValues("ui_cqcp590401_workpartFilter"); sparasname[6] = "@inworkpart"; if (str != null) { sparas[6] = str[0]; if (string.IsNullOrEmpty(sparas[6].Trim())) { sparas[6] = "ZZ"; } } else { sparas[6] = "ZZ"; } //车号 str = Request.Form.GetValues("ui_cqcp590401_caridFilter"); sparasname[7] = "@incarid"; if (str != null) { sparas[7] = str[0]; if (string.IsNullOrEmpty(sparas[7].Trim())) { sparas[7] = "ZZ"; } } else { sparas[7] = "ZZ"; } //客户名称 str = Request.Form.GetValues("ui_cqcp590401_custnameFilter"); sparasname[8] = "@incustname"; if (str != null) { sparas[8] = str[0]; if (string.IsNullOrEmpty(sparas[8].Trim())) { sparas[8] = "ZZ"; } } else { sparas[8] = "ZZ"; } sparasname[9] = "@inuserid"; HttpContext _context = HttpContext.Current; ZGZY.Model.User user = ZGZY.Common.UserHelper.GetUser(_context); //获取cookie里的用户对象 sparas[9] = user.UserId;; DataTable dt = new ZGZY.BLL.Report().cqcp590401("sp_cqcp590401_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; string[] sparas = { "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590209_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //证明书编号 str = Request.Form.GetValues("ui_cqcp590209_shipidFilter"); sparasname[2] = "@inshipid"; if (str != null) { sparas[2] = str[0]; if (string.IsNullOrEmpty(sparas[2].Trim())) { sparas[2] = "zzzzzzzzzz"; } } else { sparas[2] = "zzzzzzzzzz"; } //日期 str = Request.Form.GetValues("ui_cqcp590209_begdateFilter"); sparasname[3] = "@inbegdate"; string[] datestrs = str[0].Split(new char[] { '-' }); string strYear = "0000" + datestrs[0]; string strMonth = "00" + datestrs[1]; string strDay = "00" + datestrs[2]; sparas[3] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); str = Request.Form.GetValues("ui_cqcp590209_enddateFilter"); sparasname[4] = "@inenddate"; datestrs = str[0].Split(new char[] { '-' }); strYear = "0000" + datestrs[0]; strMonth = "00" + datestrs[1]; strDay = "00" + datestrs[2]; sparas[4] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); //混凝土标记 str = Request.Form.GetValues("ui_cqcp590209_specFilter"); sparasname[5] = "@inspec"; if (str != null) { sparas[5] = str[0]; if (string.IsNullOrEmpty(sparas[5].Trim())) { sparas[5] = "zzzzzzzzzz"; } } else { sparas[5] = "zzzzzzzzzz"; } //购货单位 sparasname[6] = "@incustname"; sparas[6] = "zzzzzzzzzz"; //工程名称 str = Request.Form.GetValues("ui_cqcp590209_engnameFilter"); sparasname[7] = "@inengname"; if (str != null) { sparas[7] = str[0]; if (string.IsNullOrEmpty(sparas[7].Trim())) { sparas[7] = "zzzzzzzzzz"; } } else { sparas[7] = "zzzzzzzzzz"; } //不用 sparasname[8] = "@inworkpart"; sparas[8] = "zzzzzzzzzz"; //差异量关系 str = Request.Form.GetValues("ui_cqcp590209_typeFilter"); sparasname[9] = "@intype"; if (str != null) { sparas[9] = str[0]; if (string.IsNullOrEmpty(sparas[9].Trim())) { sparas[9] = "0"; } } else { sparas[9] = "0"; } //组合关系 str = Request.Form.GetValues("ui_cqcp590209_relationFilter"); sparasname[10] = "@inrelation"; if (str != null) { sparas[10] = str[0]; if (string.IsNullOrEmpty(sparas[10].Trim())) { sparas[10] = "1"; } } else { sparas[10] = "1"; } //差异比关系 str = Request.Form.GetValues("ui_cqcp590209_type2Filter"); sparasname[11] = "@intype2"; if (str != null) { sparas[11] = str[0]; if (string.IsNullOrEmpty(sparas[11].Trim())) { sparas[11] = "0"; } } else { sparas[11] = "0"; } //差异比 str = Request.Form.GetValues("ui_cqcp590209_ph18percentFilter"); sparasname[12] = "@inph18percent"; if (str != null) { sparas[12] = str[0]; if (string.IsNullOrEmpty(sparas[12].Trim())) { sparas[12] = "0"; } } else { sparas[12] = "0"; } //差异量 str = Request.Form.GetValues("ui_cqcp590209_ph18Filter"); sparasname[13] = "@inph18"; if (str != null) { sparas[13] = str[0]; if (string.IsNullOrEmpty(sparas[13].Trim())) { sparas[13] = "0"; } } else { sparas[13] = "0"; } //泵送否 str = Request.Form.GetValues("ui_cqcp590209_pondFilter"); sparasname[14] = "@inpond"; if (str != null) { sparas[14] = str[0]; if (string.IsNullOrEmpty(sparas[14].Trim())) { sparas[14] = "zzzzzzzzzz"; } } else { sparas[14] = "zzzzzzzzzz"; } sparasname[15] = "@inupdid"; sparas[15] = ""; sparasname[16] = "@inmd5"; sparas[16] = ""; DataTable dt = new ZGZY.BLL.Report().cqcp590209("sp_cqcp590209_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "", "", "", "" }; string[] sparas = { "", "", "", "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590101_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //职位 str = Request.Form.GetValues("ui_cqcp590101_posidFilter"); sparasname[2] = "@inposid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[2] = sparas[2] + str[i] + "|"; } } } else { sparas[2] = "ZZ"; } //姓名 str = Request.Form.GetValues("ui_cqcp590101_empnameFilter"); sparasname[3] = "@inempname"; if (str != null) { sparas[3] = str[0]; if (string.IsNullOrEmpty(sparas[3].Trim())) { sparas[3] = "zzzzzzzzzz"; } } else { sparas[3] = "zzzzzzzzzz"; } //updid sparasname[4] = "@inupdid"; sparas[4] = ""; //身份证号 str = Request.Form.GetValues("ui_cqcp590101_identitynoFilter"); sparasname[5] = "@inidentityno"; if (str != null) { sparas[5] = str[0]; if (string.IsNullOrEmpty(sparas[5].Trim())) { sparas[5] = "zzzzzzzzzz"; } } else { sparas[5] = "zzzzzzzzzz"; } //上岗证号 str = Request.Form.GetValues("ui_cqcp590101_emp60Filter"); sparasname[6] = "@inemp60"; if (str != null) { sparas[6] = str[0]; if (string.IsNullOrEmpty(sparas[6].Trim())) { sparas[6] = "zzzzzzzzzz"; } } else { sparas[6] = "zzzzzzzzzz"; } DataTable dt = new ZGZY.BLL.Report().cqcp590101("sp_cqcp590101_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "", "", "", "", "", "", "" }; string[] sparas = { "", "", "", "", "", "", "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590301_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //日期 str = Request.Form.GetValues("ui_cqcp590301_begdateFilter"); sparasname[2] = "@inbegdate"; string[] datestrs = str[0].Split(new char[] { '-' }); string strYear = "0000" + datestrs[0]; string strMonth = "00" + datestrs[1]; string strDay = "00" + datestrs[2]; sparas[2] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); str = Request.Form.GetValues("ui_cqcp590301_enddateFilter"); sparasname[3] = "@inenddate"; datestrs = str[0].Split(new char[] { '-' }); strYear = "0000" + datestrs[0]; strMonth = "00" + datestrs[1]; strDay = "00" + datestrs[2]; sparas[3] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); //工程名称 str = Request.Form.GetValues("ui_cqcp590301_engnameFilter"); sparasname[4] = "@inst0112"; if (str != null) { sparas[4] = str[0]; if (string.IsNullOrEmpty(sparas[4].Trim())) { sparas[4] = "zzzzzzzzzz"; } } else { sparas[4] = "zzzzzzzzzz"; } //强度 str = Request.Form.GetValues("ui_cqcp590301_strengthFilter"); sparasname[5] = "@instrength"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[5] = sparas[5] + str[i] + "|"; } } } else { sparas[5] = "ZZ"; } //配比 str = Request.Form.GetValues("ui_cqcp590301_formulaidFilter"); sparasname[6] = "@informulaid"; if (str != null) { sparas[6] = str[0]; if (string.IsNullOrEmpty(sparas[6].Trim())) { sparas[6] = "zzzzzzzzzz"; } } else { sparas[6] = "zzzzzzzzzz"; } //龄期 str = Request.Form.GetValues("ui_cqcp590301_daysFilter"); sparasname[7] = "@indays"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[7] = sparas[7] + str[i] + "|"; } } } else { sparas[7] = "ZZ"; } //日期类型 str = Request.Form.GetValues("ui_cqcp590301_typeFilter"); sparasname[8] = "@intype"; if (str != null) { sparas[8] = str[0]; if (string.IsNullOrEmpty(sparas[8].Trim())) { sparas[8] = "1"; } } else { sparas[8] = "1"; } //updid sparasname[9] = "@inupdid"; sparas[9] = ""; DataTable dt = new ZGZY.BLL.Report().cqcp590301("sp_cqcp590301_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "", "", "", "", "", "" }; string[] sparas = { "", "", "", "", "", "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590205_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //工程名称 str = Request.Form.GetValues("ui_cqcp590205_ordh12Filter"); sparasname[2] = "@inordh12"; if (str != null) { sparas[2] = str[0]; if (string.IsNullOrEmpty(sparas[2].Trim())) { sparas[2] = "zzzzzzzzzz"; } } else { sparas[2] = "zzzzzzzzzz"; } //日期 str = Request.Form.GetValues("ui_cqcp590205_begdateFilter"); sparasname[3] = "@inbegdate"; string[] datestrs = str[0].Split(new char[] { '-' }); string strYear = "0000" + datestrs[0]; string strMonth = "00" + datestrs[1]; string strDay = "00" + datestrs[2]; sparas[3] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); str = Request.Form.GetValues("ui_cqcp590205_enddateFilter"); sparasname[4] = "@inenddate"; datestrs = str[0].Split(new char[] { '-' }); strYear = "0000" + datestrs[0]; strMonth = "00" + datestrs[1]; strDay = "00" + datestrs[2]; sparas[4] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); //合同备案号 str = Request.Form.GetValues("ui_cqcp590205_ordidFilter"); sparasname[5] = "@inordid"; if (str != null) { sparas[5] = str[0]; if (string.IsNullOrEmpty(sparas[5].Trim())) { sparas[5] = "zzzzzzzzzz"; } } else { sparas[5] = "zzzzzzzzzz"; } //updid sparasname[6] = "@inupdid"; sparas[6] = ""; //是否到期 str = Request.Form.GetValues("ui_cqcp590205_daoqiFilter"); sparasname[7] = "@indaoqi"; if (str != null) { if (str[0] == "on") { sparas[7] = "Y"; } else { sparas[7] = "N"; } } else { sparas[7] = "N"; } //百分比 str = Request.Form.GetValues("ui_cqcp590205_percentFilter"); sparasname[8] = "@inpercent"; if (str != null) { sparas[8] = str[0]; if (string.IsNullOrEmpty(sparas[8].Trim())) { sparas[8] = "0"; } } else { sparas[8] = "0"; } DataTable dt = new ZGZY.BLL.Report().cqcp590205("sp_cqcp590205_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "", "", "", "", "", "", "", "", "" }; string[] sparas = { "", "", "", "", "", "", "", "", "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590302_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //日期 str = Request.Form.GetValues("ui_cqcp590302_begdateFilter"); sparasname[2] = "@inbegdate"; string[] datestrs = str[0].Split(new char[] { '-' }); string strYear = "0000" + datestrs[0]; string strMonth = "00" + datestrs[1]; string strDay = "00" + datestrs[2]; sparas[2] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); str = Request.Form.GetValues("ui_cqcp590302_enddateFilter"); sparasname[3] = "@inenddate"; datestrs = str[0].Split(new char[] { '-' }); strYear = "0000" + datestrs[0]; strMonth = "00" + datestrs[1]; strDay = "00" + datestrs[2]; sparas[3] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2) + strDay.Substring(strDay.Length - 2, 2); //检测类别 str = Request.Form.GetValues("ui_cqcp590302_typeFilter"); sparasname[4] = "@intype"; if (str != null) { if (str[0] == "砂检测") { sparas[4] = "1"; } else { sparas[4] = str[0]; } if (string.IsNullOrEmpty(sparas[4].Trim())) { sparas[4] = "1"; } } else { sparas[4] = "1"; } switch (sparas[4]) { case "1": ReportViewer1.LocalReport.ReportPath = "admin\\report\\cqcp590302.rdlc"; break; case "2": ReportViewer1.LocalReport.ReportPath = "admin\\report\\cqcp590302_s2.rdlc"; break; case "3": ReportViewer1.LocalReport.ReportPath = "admin\\report\\cqcp590302_s3.rdlc"; break; case "4": ReportViewer1.LocalReport.ReportPath = "admin\\report\\cqcp590302_s4.rdlc"; break; case "5": ReportViewer1.LocalReport.ReportPath = "admin\\report\\cqcp590302_s5.rdlc"; break; case "6": ReportViewer1.LocalReport.ReportPath = "admin\\report\\cqcp590302_s6.rdlc"; break; default: break; } //updid sparasname[5] = "@inupdid"; sparas[5] = ""; //inmd5 sparasname[6] = "@inmd5"; sparas[6] = ""; //供应商 str = Request.Form.GetValues("ui_cqcp590302_sac157Filter"); sparasname[7] = "@insac157"; if (str != null) { sparas[7] = str[0]; if (string.IsNullOrEmpty(sparas[7].Trim())) { sparas[7] = "ZZ"; } } else { sparas[7] = "ZZ"; } //品种 str = Request.Form.GetValues("ui_cqcp590302_mattype2Filter"); sparasname[8] = "@inmattype2"; if (str != null) { sparas[8] = str[0]; if (string.IsNullOrEmpty(sparas[8].Trim())) { sparas[8] = "ZZ"; } } else { sparas[8] = "ZZ"; } //规格 str = Request.Form.GetValues("ui_cqcp590302_mattype3Filter"); sparasname[9] = "@inmattype3"; if (str != null) { sparas[9] = str[0]; if (string.IsNullOrEmpty(sparas[9].Trim())) { sparas[9] = "ZZ"; } } else { sparas[9] = "ZZ"; } //合格否 str = Request.Form.GetValues("ui_cqcp590302_resultFilter"); sparasname[10] = "@inresult"; if (str != null) { if (str[0] == "on") { sparas[10] = "1"; } else { sparas[10] = "ZZ"; } } else { sparas[10] = "ZZ"; } //检测类型 str = Request.Form.GetValues("ui_cqcp590302_cktypeFilter"); sparasname[11] = "@incktype"; if (str != null) { sparas[11] = str[0]; if (string.IsNullOrEmpty(sparas[11].Trim())) { sparas[11] = "ZZ"; } } else { sparas[11] = "ZZ"; } DataTable dt = new ZGZY.BLL.Report().cqcp590302("sp_cqcp590302_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname = { "", "", "", "", "", "", "", "" }; string[] sparas = { "", "", "", "", "", "", "", "" }; sparasname[0] = "@incompid"; sparas[0] = "01"; //企业 str = Request.Form.GetValues("ui_cqcp590103_factidFilter"); sparasname[1] = "@infactid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[1] = sparas[1] + str[i] + "|"; } } } else { sparas[1] = "ZZ"; } //设备名称 str = Request.Form.GetValues("ui_cqcp590103_equnameFilter"); sparasname[2] = "@inequname"; if (str != null) { sparas[2] = str[0]; if (string.IsNullOrEmpty(sparas[2].Trim())) { sparas[2] = "zzzzzzzzzz"; } } else { sparas[2] = "zzzzzzzzzz"; } //不使用 sparasname[3] = "@inbegdate"; sparas[3] = ""; sparasname[4] = "@inenddate"; sparas[4] = ""; sparasname[5] = "@intype"; sparas[5] = "0"; //检测类别 str = Request.Form.GetValues("ui_cqcp590103_subcategoryidFilter"); sparasname[6] = "@insubcategoryid"; if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[6] = sparas[6] + str[i] + "|"; } } } else { sparas[6] = "ZZ"; } sparasname[7] = "@inupdid"; sparas[7] = "0"; DataTable dt = new ZGZY.BLL.Report().cqcp590103("sp_cqcp590103_web_new", sparasname, sparas); return(dt); }
private DataTable GetData() { //-----获取查询条件------ string[] str; string[] sparasname; string[] sparas; sparasname = new string[25]; sparas = new string[25]; sparasname[0] = "@incompid"; sparas[0] = "01"; //查询年月 sparasname[1] = "@inyymm"; str = Request.Form.GetValues("ui_rpt585202dx141_yymmFilter"); string[] datestrs = str[0].Split(new char[] { '-' }); string strYear = "0000" + datestrs[0]; string strMonth = "00" + datestrs[1]; sparas[1] = strYear.Substring(strYear.Length - 4, 4) + strMonth.Substring(strMonth.Length - 2, 2); //客户类别 sparasname[2] = "@incusttype"; sparas[2] = "ZZ"; //客户代号 sparasname[3] = "@incustid"; sparas[3] = "ZZ"; //合同代号 sparasname[4] = "@inordh12"; sparas[4] = "ZZ"; //结案否 sparasname[5] = "@inclosed"; str = Request.Form.GetValues("ui_rpt585202dx141_rdltypeFilter"); sparas[5] = str[0]; //合同类别 sparasname[6] = "@inordtype"; str = Request.Form.GetValues("ui_rpt585202dx141_ordtypeFilter"); sparas[6] = str[0]; //报表别 sparasname[7] = "@intype"; sparas[7] = "1"; //企业 sparasname[8] = "@infactid"; str = Request.Form.GetValues("ui_rpt585202dx141_factidFilter"); if (str != null) { if (str.Length > 0) { for (int i = 0; i < str.Length; i++) { sparas[8] = sparas[8] + str[i] + "|"; } } } else { sparas[8] = "ZZ"; } //业务员代号 sparasname[9] = "@inempid"; sparas[9] = "ZZ"; //当月方量 sparasname[10] = "@inyymmqty"; sparas[10] = "0"; //当月金额 sparasname[11] = "@inyymmamt"; sparas[11] = "0"; //收款进度 sparasname[12] = "@inljqty"; sparas[12] = "0"; //累计方量 sparasname[13] = "@inljamt"; sparas[13] = "0"; //累计金额 sparasname[14] = "@inljowamt"; sparas[14] = "0"; //累计欠款 sparasname[15] = "@inproper"; sparas[15] = "0"; //工程名称模糊 sparasname[16] = "@inordh12a"; str = Request.Form.GetValues("ui_rpt585202dx141_ordh12Filter"); if (str != null) { sparas[16] = str[0]; if (string.IsNullOrEmpty(sparas[16].Trim())) { sparas[16] = "ZZ"; } } else { sparas[16] = "ZZ"; } //客户模糊 sparasname[17] = "@incustname"; str = Request.Form.GetValues("ui_rpt585202dx141_custidFilter"); if (str != null) { sparas[17] = str[0]; if (string.IsNullOrEmpty(sparas[17].Trim())) { sparas[17] = "ZZ"; } } else { sparas[17] = "ZZ"; } //业务员模糊 sparasname[18] = "@inbegname"; str = Request.Form.GetValues("ui_rpt585202dx141_empidFilter"); if (str != null) { sparas[18] = str[0]; if (string.IsNullOrEmpty(sparas[18].Trim())) { sparas[18] = "ZZ"; } } else { sparas[18] = "ZZ"; } sparasname[19] = "@inuser"; sparas[19] = "admin"; //合同代号new sparasname[20] = "@inordid"; str = Request.Form.GetValues("ui_rpt585202dx141_ordidFilter"); if (str != null) { sparas[20] = str[0]; if (string.IsNullOrEmpty(sparas[20].Trim())) { sparas[20] = "ZZ"; } } else { sparas[20] = "ZZ"; } //收款进度new sparasname[21] = "@inskjdMark"; str = Request.Form.GetValues("ui_rpt585202dx141_skjdMarkFilter"); sparas[21] = str[0]; sparasname[22] = "@inskjdAmt"; str = Request.Form.GetValues("ui_rpt585202dx141_skjdAmtFilter"); if (str != null) { sparas[22] = str[0]; if (string.IsNullOrEmpty(sparas[22].Trim())) { sparas[22] = "999999"; } } else { sparas[22] = "999999"; } //累计欠款new sparasname[23] = "@inljqkMark"; str = Request.Form.GetValues("ui_rpt585202dx141_ljqkMarkFilter"); sparas[23] = str[0]; sparasname[24] = "@inljqkAmt"; str = Request.Form.GetValues("ui_rpt585202dx141_ljqkAmtFilter"); if (str != null) { sparas[24] = str[0]; if (string.IsNullOrEmpty(sparas[24].Trim())) { sparas[24] = "999999"; } } else { sparas[24] = "999999"; } DataTable dt = new ZGZY.BLL.Report().rpt585202dx141("sp_webp585202_dx141_new", sparasname, sparas); return(dt); }