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