/// <summary>
/// 获取委托书和受检企业关联信息
/// </summary>
/// <param name="tMisContract"></param>
/// <param name="intPageIndex"></param>
/// <param name="intPageSize"></param>
/// <returns></returns>
public DataTable SelectDefineTableContract(TMisContractVo tMisContract, string strCompanyName, string strArea, int intPageIndex, int intPageSize)
{
// 委托书查询
string strSQL = " SELECT A.*,B.AREA,B.COMPANY_NAME,B.INDUSTRY FROM T_MIS_CONTRACT A LEFT JOIN T_MIS_CONTRACT_COMPANY B ON A.TESTED_COMPANY_ID=B.ID WHERE 1=1";
if (!String.IsNullOrEmpty(strCompanyName))
{
strSQL += " AND B.COMPANY_NAME LIKE '%" + strCompanyName + "%'";
}
if (!String.IsNullOrEmpty(strArea))
{
strSQL += " AND B.AREA='" + strArea + "'";
}
if (!String.IsNullOrEmpty(tMisContract.ID))
{
strSQL += " AND A.ID='" + tMisContract.ID + "'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_CODE))
{
strSQL += " AND A.CONTRACT_CODE LIKE '%" + tMisContract.CONTRACT_CODE + "'";
}
if (!String.IsNullOrEmpty(tMisContract.TEST_TYPES))
{
strSQL += " AND A.TEST_TYPES LIKE '%" + tMisContract.TEST_TYPES + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_STATUS))
{
strSQL += " AND A.CONTRACT_STATUS='" + tMisContract.CONTRACT_STATUS + "'";
}
if (!String.IsNullOrEmpty(tMisContract.CCFLOW_ID1))
{
strSQL += " AND A.CCFLOW_ID1='" + tMisContract.CCFLOW_ID1 + "'";
}
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, intPageIndex, intPageSize)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContract_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisContract_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractVo tMisContract_UpdateSet, TMisContractVo tMisContract_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisContract_UpdateSet, TMisContractVo.T_MIS_CONTRACT_TABLE);
strSQL += this.BuildWhereStatement(tMisContract_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取委托书和委托企业关联信息委托书总数
/// </summary>
/// <param name="tMisContract"></param>
/// <param name="intPageIndex"></param>
/// <param name="intPageSize"></param>
/// <returns></returns>
public int SelectByUnionTableResult(TMisContractVo tMisContract)
{
string strSQL = " SELECT A.*,B.COMPANY_NAME FROM T_MIS_CONTRACT A INNER JOIN T_MIS_CONTRACT_COMPANY B ON A.CLIENT_COMPANY_ID=B.ID WHERE 1=1";
if (!String.IsNullOrEmpty(tMisContract.CLIENT_COMPANY_ID))
{
strSQL += " AND B.COMPANY_NAME LIKE '%" + tMisContract.CLIENT_COMPANY_ID + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.ID))
{
strSQL += " AND A.ID='" + tMisContract.ID + "'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_CODE))
{
strSQL += " AND A.CONTRACT_CODE LIKE '%" + tMisContract.CONTRACT_CODE + "'";
}
if (!String.IsNullOrEmpty(tMisContract.TEST_TYPES))
{
strSQL += " AND A.TEST_TYPES LIKE '%" + tMisContract.TEST_TYPES + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_STATUS))
{
strSQL += " AND A.CONTRACT_STATUS='" + tMisContract.CONTRACT_STATUS + "'";
}
if (!String.IsNullOrEmpty(tMisContract.BOOKTYPE))
{
strSQL += " AND A.BOOKTYPE='" + tMisContract.BOOKTYPE + "'";
}
return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContract">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractVo tMisContract)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisContract, TMisContractVo.T_MIS_CONTRACT_TABLE);
strSQL += string.Format(" where ID='{0}' ", tMisContract.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 饼图绑定
/// </summary>
public void FillChart()
{
dt = new DataTable();
TMisContractVo objItems = new TMisContractVo();
objItems.REMARK3 = strYear;
objItems.REMARK4 = strMonth;
objItems.REMARK5 = strQuarter;
objItems.CONTRACT_TYPE = strContractType;
objItems.CONTRACT_CODE = strContractCode;
objItems.TESTED_COMPANY_ID = strCompanyName;
TMisContractFeeVo objItemsFree = new TMisContractFeeVo();
dt = new TMisContractFeeLogic().SelectTableForContractFreeSum(objItems, objItemsFree);
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dr["FINISHSUM"] = "0";
dr["FINISHTYPE"] = "无数据集";
dt.Rows.Add(dr);
dt.AcceptChanges();
}
ReportDataSource rds = new ReportDataSource("DataSet2", dt);
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
this.reportViewer2.LocalReport.DataSources.Add(rds);
this.reportViewer2.LocalReport.Refresh();
}
/// <summary>
/// 获取自送样采样计划
/// </summary>
/// <param name="tMisContract"></param>
/// <returns></returns>
public DataTable GetContractInforUnionSamplePlan(TMisContractVo tMisContract, TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = "SELECT A.ID,A.CONTRACT_CODE,A.CONTRACT_YEAR,A.PROJECT_NAME,A.CONTRACT_TYPE,A.TEST_TYPES,A.CLIENT_COMPANY_ID,A.TESTED_COMPANY_ID,A.ASKING_DATE,A.SAMPLE_FREQ,A.PROJECT_ID,A.SAMPLE_SOURCE," +
" B.ID AS SAMPLE_ID,B.FREQ,B.NUM AS SAMPLENUM,B.IF_PLAN,C.COMPANY_NAME,C.CONTACT_NAME,C.PHONE,D.ID AS TASK_ID,D.TICKET_NUM,D.ASKING_DATE,E.ID AS SUBTASK_ID,F.COMPANY_NAME AS CLIENT_COMPANY_NAME,F.CONTACT_NAME AS CLIENT_CONTACT_NAME,F.PHONE AS CLIENT_PNONE,G.ID AS REPORT_ID,G.REPORT_CODE FROM T_MIS_CONTRACT A " +
" INNER JOIN T_MIS_CONTRACT_SAMPLE_PLAN B ON B.CONTRACT_ID=A.ID" +
" INNER JOIN T_MIS_CONTRACT_COMPANY C ON C.ID=A.CLIENT_COMPANY_ID" +
" INNER JOIN dbo.T_MIS_MONITOR_TASK D ON D.CONTRACT_ID=B.CONTRACT_ID AND D.PLAN_ID=B.ID" +
" INNER JOIN dbo.T_MIS_MONITOR_SUBTASK E ON E.TASK_ID=D.ID" +
" INNER JOIN T_MIS_CONTRACT_COMPANY F ON F.ID=A.CLIENT_COMPANY_ID " +
" INNER JOIN dbo.T_MIS_MONITOR_REPORT G ON G.TASK_ID=D.ID " +
" WHERE 1=1";
if (!String.IsNullOrEmpty(tMisContract.ID))
{
strSQL += String.Format(" AND A.ID='{0}'", tMisContract.ID);
}
if (!String.IsNullOrEmpty(tMisContract.BOOKTYPE))
{
strSQL += String.Format(" AND A.BOOKTYPE='{0}' ", tMisContract.BOOKTYPE);
}
if (!String.IsNullOrEmpty(tMisContractSamplePlan.IF_PLAN))
{
strSQL += String.Format(" AND B.IF_PLAN='{0}' ", tMisContractSamplePlan.IF_PLAN);
}
if (!String.IsNullOrEmpty(tMisContractSamplePlan.ID))
{
strSQL += String.Format(" AND B.ID='{0}' ", tMisContractSamplePlan.ID);
}
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 获取委托书和委托企业关联信息
/// </summary>
/// <param name="tMisContract"></param>
/// <param name="intPageIndex"></param>
/// <param name="intPageSize"></param>
/// <returns></returns>
public DataTable SelectByUnionTable(TMisContractVo tMisContract, int intPageIndex, int intPageSize)
{
string strSQL = " SELECT A.*,B.COMPANY_NAME FROM T_MIS_CONTRACT A INNER JOIN T_MIS_CONTRACT_COMPANY B ON A.CLIENT_COMPANY_ID=B.ID WHERE 1=1";
if (!String.IsNullOrEmpty(tMisContract.CLIENT_COMPANY_ID))
{
strSQL += " AND B.COMPANY_NAME LIKE '%" + tMisContract.CLIENT_COMPANY_ID + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.ID))
{
strSQL += " AND A.ID='" + tMisContract.ID + "'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_CODE))
{
strSQL += " AND A.CONTRACT_CODE LIKE '%" + tMisContract.CONTRACT_CODE + "'";
}
if (!String.IsNullOrEmpty(tMisContract.TEST_TYPES))
{
strSQL += " AND A.TEST_TYPES LIKE '%" + tMisContract.TEST_TYPES + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_STATUS))
{
strSQL += " AND A.CONTRACT_STATUS='" + tMisContract.CONTRACT_STATUS + "'";
}
if (!String.IsNullOrEmpty(tMisContract.BOOKTYPE))
{
strSQL += " AND A.BOOKTYPE='" + tMisContract.BOOKTYPE + "'";
}
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, intPageIndex, intPageSize)));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisContractVo tMisContract)
{
string strSQL = "delete from T_MIS_CONTRACT ";
strSQL += this.BuildWhereStatement(tMisContract);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取统计缴费金额相关信息记录数
/// </summary>
/// <param name="tMisContract"></param>
/// <param name="tMisContractFee"></param>
/// <returns></returns>
public DataTable SelectTableForContractFreeSum(TMisContractVo tMisContract, TMisContractFeeVo tMisContractFee)
{
string StartDate = "", EndDate = "";
string strSQL = String.Format(@"SELECT CASE WHEN B.IF_PAY IS NULL THEN '未缴费' WHEN B.IF_PAY='0' THEN '未缴费' ELSE '已缴费' END AS FINISHTYPE,SUM(CONVERT(INT, CASE WHEN B.INCOME='NULL' THEN '0' WHEN B.INCOME IS NULL THEN '0' ELSE B.INCOME END)) AS FINISHSUM FROM T_MIS_CONTRACT A
LEFT JOIN T_MIS_CONTRACT_FEE B ON A.ID=B.CONTRACT_ID
LEFT JOIN dbo.T_MIS_CONTRACT_COMPANY C ON C.ID=TESTED_COMPANY_ID
LEFT JOIN T_SYS_DICT D ON D.DICT_CODE=A.CONTRACT_TYPE AND D.DICT_TYPE='Contract_Type'
WHERE A.CONTRACT_STATUS!='0'");
if (!String.IsNullOrEmpty(tMisContract.PROJECT_NAME))
{
strSQL += String.Format(" AND A.PROJECT_NAME", tMisContract.PROJECT_NAME);
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_CODE))
{
strSQL += String.Format(" AND A.CONTRACT_CODE LIKE '%{0}%'", tMisContract.CONTRACT_CODE);
}
if (!String.IsNullOrEmpty(tMisContract.TESTED_COMPANY_ID))
{
strSQL += String.Format(" AND C.COMPANY_NAME LIKE '%{0}%'", tMisContract.TESTED_COMPANY_ID);
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_TYPE))
{
strSQL += String.Format(" AND A.CONTRACT_TYPE='{0}'", tMisContract.CONTRACT_TYPE);
}
if (!String.IsNullOrEmpty(tMisContract.REMARK3))
{
//月度
strSQL += String.Format(" AND CONVERT(DATETIME, CONVERT(VARCHAR(100), A.ASKING_DATE,23),111) ");
if (!String.IsNullOrEmpty(tMisContract.REMARK4) && String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-{1}-01", tMisContract.REMARK3, tMisContract.REMARK4);
EndDate = String.Format(" {0}-{1}-31", tMisContract.REMARK3, tMisContract.REMARK4);
}
//季度
if (String.IsNullOrEmpty(tMisContract.REMARK4) && !String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-{1}-01", tMisContract.REMARK3, tMisContract.REMARK5);
DateTime strMonth = DateTime.Parse(StartDate);
EndDate = String.Format(" {0}-{1}-31", tMisContract.REMARK3, strMonth.AddMonths(+2).Month.ToString());
}
//年度
if (String.IsNullOrEmpty(tMisContract.REMARK4) && String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-01-01", tMisContract.REMARK3);
EndDate = String.Format(" {0}-12-31", tMisContract.REMARK3);
}
strSQL += String.Format(" BETWEEN CONVERT(DATETIME, CONVERT(VARCHAR(100),'{0}' ,23),111) AND CONVERT(DATETIME, CONVERT(VARCHAR(100), '{1}' ,23),111) ", StartDate, EndDate);
}
strSQL += " GROUP BY B.IF_PAY";
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 发送时更改委托书提交状态
/// </summary>
protected string ChangeStatusBySend()
{
TMisContractVo objContractVo = new TMisContractVo();
objContractVo.ID = this.CONTRACT_ID.Value;
objContractVo.CONTRACT_STATUS = "9";
new TMisContractLogic().Edit(objContractVo);
return(objContractVo.ID);
}
/// <summary>
/// 自定义查询 数据集
/// </summary>
/// <param name="tMisContract">对象</param>
/// <param name="intPageIndex">页码</param>
/// <param name="intPageSize">单页显示数</param>
/// <returns>数据集</returns>
public DataTable SelectByTableForSearchList(TMisContractVo tMisContract, int intPageIndex, int intPageSize)
{
// 委托书查询
string strSQL = " SELECT A.* from T_MIS_CONTRACT A";
if (!String.IsNullOrEmpty(tMisContract.CLIENT_COMPANY_ID))
{
strSQL += " INNER JOIN T_MIS_CONTRACT_COMPANY B ON A.CLIENT_COMPANY_ID=B.ID AND B.IS_DEL='0' AND B.COMPANY_NAME LIKE '%" + tMisContract.CLIENT_COMPANY_ID + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.TESTED_COMPANY_ID))
{
strSQL += " INNER JOIN T_MIS_CONTRACT_COMPANY B ON A.TESTED_COMPANY_ID=B.ID AND B.IS_DEL='0' AND B.COMPANY_NAME LIKE '%" + tMisContract.TESTED_COMPANY_ID + "%'";
}
strSQL += " WHERE 1=1";
//查询条件构造
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_YEAR))
{
strSQL += " AND A.CONTRACT_YEAR='" + tMisContract.CONTRACT_YEAR + "'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_TYPE))
{
strSQL += " AND A.CONTRACT_TYPE='" + tMisContract.CONTRACT_TYPE + "'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_CODE))
{
strSQL += " AND A.CONTRACT_CODE='" + tMisContract.CONTRACT_CODE + "'";
}
//if (!string.IsNullOrEmpty(tMisContract.CLIENT_COMPANY_ID))
// strSQL += " and CLIENT_COMPANY_ID in (SELECT ID FROM T_MIS_CONTRACT_COMPANY WHERE IS_DEL='0' AND COMPANY_NAME like '%" + tMisContract.CLIENT_COMPANY_ID + "%')";
//if (!string.IsNullOrEmpty(tMisContract.TESTED_COMPANY_ID))
// strSQL += " and TESTED_COMPANY_ID in (SELECT ID FROM T_MIS_CONTRACT_COMPANY WHERE IS_DEL='0' AND COMPANY_NAME like '%" + tMisContract.TESTED_COMPANY_ID + "%')";
if (!String.IsNullOrEmpty(tMisContract.TEST_TYPES))
{
strSQL += " AND A.TEST_TYPES LIKE '%" + tMisContract.TEST_TYPES + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.PROJECT_NAME))
{
strSQL += " AND A.PROJECT_NAME LIKE '%" + tMisContract.PROJECT_NAME + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_STATUS))
{
strSQL += " AND A. CONTRACT_STATUS in (" + tMisContract.CONTRACT_STATUS + ")";
}
if (!String.IsNullOrEmpty(tMisContract.ISQUICKLY))
{
strSQL += "AND A.ISQUICKLY = '" + tMisContract.ISQUICKLY + "'";
}
else
{
strSQL += " AND A.ISQUICKLY IS NULL";
}
strSQL += " order by A.ID DESC";
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, intPageIndex, intPageSize)));
}
/// <summary>
/// 获得委托书信息
/// </summary>
protected void SelectContract()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
//委托年度
string strYear = !string.IsNullOrEmpty(Request.QueryString["SrhYear"]) ? Request.QueryString["SrhYear"].ToString() : "";
//委托类型
string strContractType = !string.IsNullOrEmpty(Request.QueryString["SrhContractType"]) ? Request.QueryString["SrhContractType"].ToString() : "";
//合同号
string strContractCode = !string.IsNullOrEmpty(Request.QueryString["SrhContractCode"]) ? Request.QueryString["SrhContractCode"].ToString() : "";
//任务单号
string strDutyCode = !string.IsNullOrEmpty(Request.QueryString["DutyCode"]) ? Request.QueryString["DutyCode"].ToString() : "";
//报告号
string strReportCode = !string.IsNullOrEmpty(Request.QueryString["ReportCode"]) ? Request.QueryString["ReportCode"].ToString() : "";
//委托客户
string strClientName = !string.IsNullOrEmpty(Request.QueryString["ClientName"]) ? Request.QueryString["ClientName"].ToString() : "";
//合同类别
string strItemType = !string.IsNullOrEmpty(Request.QueryString["ItemType"]) ? Request.QueryString["ItemType"].ToString() : "";
//项目名称
string strProjectName = !string.IsNullOrEmpty(Request.QueryString["SrhProjectName"]) ? Request.QueryString["SrhProjectName"].ToString() : "";
//构造查询对象
TMisContractVo objContract = new TMisContractVo();
TMisContractLogic objContractLogic = new TMisContractLogic();
if (strSortname == null || strSortname.Length == 0)
{
strSortname = TMisContractVo.CONTRACT_CODE_FIELD;
}
//objContract.SORT_FIELD = strSortname;
//objContract.SORT_TYPE = strSortorder;
objContract.SORT_FIELD = "ID";
objContract.SORT_TYPE = "desc";
objContract.CONTRACT_YEAR = strYear;
objContract.CONTRACT_TYPE = "05";
objContract.PROJECT_ID = base.LogInfo.UserInfo.ID;
objContract.CONTRACT_CODE = strContractCode;
objContract.PROJECT_NAME = strProjectName;
objContract.CLIENT_COMPANY_ID = strClientName;
objContract.TEST_TYPE = strItemType;
int intTotalCount = objContractLogic.GetSelectResultCount(objContract);//总计的数据条数
DataTable dt = objContractLogic.SelectByTable(objContract, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
Response.End();
}
/// <summary>
/// 获得委托书信息
/// </summary>
protected string getContractInfo()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
//合同ID
if (!string.IsNullOrEmpty(Request.QueryString["contract_id"]))
{
string strContractId = Request.QueryString["contract_id"].ToString();
//委托年度
string strYear = !string.IsNullOrEmpty(Request.QueryString["SrhYear"]) ? Request.QueryString["SrhYear"].ToString() : "";
//委托类型
string strContractType = !string.IsNullOrEmpty(Request.QueryString["SrhContractType"]) ? Request.QueryString["SrhContractType"].ToString() : "";
//合同号
string strContractCode = !string.IsNullOrEmpty(Request.QueryString["SrhContractCode"]) ? Request.QueryString["SrhContractCode"].ToString() : "";
//任务单号
string strDutyCode = !string.IsNullOrEmpty(Request.QueryString["DutyCode"]) ? Request.QueryString["DutyCode"].ToString() : "";
//报告号
string strReportCode = !string.IsNullOrEmpty(Request.QueryString["ReportCode"]) ? Request.QueryString["ReportCode"].ToString() : "";
//委托客户
string strClientName = !string.IsNullOrEmpty(Request.QueryString["ClientName"]) ? Request.QueryString["ClientName"].ToString() : "";
//合同类别
string strItemType = !string.IsNullOrEmpty(Request.QueryString["ItemType"]) ? Request.QueryString["ItemType"].ToString() : "";
//项目名称
string strProjectName = !string.IsNullOrEmpty(Request.QueryString["SrhProjectName"]) ? Request.QueryString["SrhProjectName"].ToString() : "";
//构造查询对象
TMisContractVo objContract = new TMisContractVo();
TMisContractLogic objContractLogic = new TMisContractLogic();
if (strSortname == null || strSortname.Length == 0)
{
strSortname = TMisContractVo.CONTRACT_CODE_FIELD;
}
objContract.ID = strContractId;
objContract.SORT_FIELD = strSortname;
objContract.SORT_TYPE = strSortorder;
objContract.CONTRACT_YEAR = strYear;
objContract.CONTRACT_TYPE = strContractType;
objContract.CONTRACT_CODE = strContractCode;
objContract.CLIENT_COMPANY_ID = strClientName;
objContract.TEST_TYPE = strItemType;
objContract.PROJECT_NAME = strProjectName;
int intTotalCount = objContractLogic.GetSelectResultCount(objContract);//总计的数据条数
DataTable dt = objContractLogic.SelectByTable(objContract, intPageIdx, intPagesize);
return(CreateToJson(dt, intTotalCount));
}
return("");
}
/// <summary>
/// 自定义查询 总数
/// </summary>
/// <param name="tMisContract">对象</param>
/// <returns>总数</returns>
public int GetSelectResultCountForSearchList(TMisContractVo tMisContract)
{
// 委托书查询
string strSQL = " SELECT A.* from T_MIS_CONTRACT A";
if (!String.IsNullOrEmpty(tMisContract.CLIENT_COMPANY_ID))
{
strSQL += " INNER JOIN T_MIS_CONTRACT_COMPANY B ON A.CLIENT_COMPANY_ID=B.ID AND B.IS_DEL='0' AND B.COMPANY_NAME LIKE '%" + tMisContract.CLIENT_COMPANY_ID + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.TESTED_COMPANY_ID))
{
strSQL += " INNER JOIN T_MIS_CONTRACT_COMPANY B ON A.TESTED_COMPANY_ID=B.ID AND B.IS_DEL='0' AND B.COMPANY_NAME LIKE '%" + tMisContract.TESTED_COMPANY_ID + "%'";
}
strSQL += " WHERE 1=1";
//查询条件构造
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_YEAR))
{
strSQL += " AND A.CONTRACT_YEAR='" + tMisContract.CONTRACT_YEAR + "'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_TYPE))
{
strSQL += " AND A.CONTRACT_TYPE='" + tMisContract.CONTRACT_TYPE + "'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_CODE))
{
strSQL += " AND A.CONTRACT_CODE='" + tMisContract.CONTRACT_CODE + "'";
}
//if (!string.IsNullOrEmpty(tMisContract.CLIENT_COMPANY_ID))
// strSQL += " and CLIENT_COMPANY_ID in (SELECT ID FROM T_MIS_CONTRACT_COMPANY WHERE IS_DEL='0' AND COMPANY_NAME like '%" + tMisContract.CLIENT_COMPANY_ID + "%')";
//if (!string.IsNullOrEmpty(tMisContract.TESTED_COMPANY_ID))
// strSQL += " and TESTED_COMPANY_ID in (SELECT ID FROM T_MIS_CONTRACT_COMPANY WHERE IS_DEL='0' AND COMPANY_NAME like '%" + tMisContract.TESTED_COMPANY_ID + "%')";
if (!String.IsNullOrEmpty(tMisContract.TEST_TYPES))
{
strSQL += " AND A.TEST_TYPES LIKE '%" + tMisContract.TEST_TYPES + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.PROJECT_NAME))
{
strSQL += " AND A.PROJECT_NAME LIKE '%" + tMisContract.PROJECT_NAME + "%'";
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_STATUS))
{
strSQL += " AND A. CONTRACT_STATUS = '" + tMisContract.CONTRACT_STATUS + "'";
}
if (!String.IsNullOrEmpty(tMisContract.ISQUICKLY))
{
strSQL += " AND A.ISQUICKLY = '" + tMisContract.ISQUICKLY + "'";
}
else
{
strSQL += " AND A.ISQUICKLY IS NULL";
}
return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count);
}
/// <summary>
/// 返回企业缴费信息明细记录数
/// </summary>
/// <param name="tMisContract"></param>
/// <returns></returns>
public int SelectGetCompayFreeDetailTableCount(TMisContractVo tMisContract)
{
string StartDate = "", EndDate = "";
string TempSQL = "";
if (!String.IsNullOrEmpty(tMisContract.TESTED_COMPANY_ID))
{
TempSQL += String.Format(" AND C.COMPANY_NAME LIKE '%{0}%'", tMisContract.TESTED_COMPANY_ID);
}
if (!String.IsNullOrEmpty(tMisContract.REMARK3))
{
//月度
TempSQL += String.Format(" AND CONVERT(DATETIME, CONVERT(VARCHAR(100), A.ASKING_DATE,23),111) ");
if (!String.IsNullOrEmpty(tMisContract.REMARK4) && String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-{1}-01", tMisContract.REMARK3, tMisContract.REMARK4);
EndDate = String.Format(" {0}-{1}-31", tMisContract.REMARK3, tMisContract.REMARK4);
}
//季度
if (String.IsNullOrEmpty(tMisContract.REMARK4) && !String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-{1}-01", tMisContract.REMARK3, tMisContract.REMARK5);
DateTime strMonth = DateTime.Parse(StartDate);
EndDate = String.Format(" {0}-{1}-31", tMisContract.REMARK3, strMonth.AddMonths(+2).Month.ToString());
}
//年度
if (String.IsNullOrEmpty(tMisContract.REMARK4) && String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-01-01", tMisContract.REMARK3);
EndDate = String.Format(" {0}-12-31", tMisContract.REMARK3);
}
TempSQL += String.Format(" BETWEEN CONVERT(DATETIME, CONVERT(VARCHAR(100),'{0}' ,23),111) AND CONVERT(DATETIME, CONVERT(VARCHAR(100), '{1}' ,23),111) ", StartDate, EndDate);
}
string strSQL = String.Format(@"SELECT COMPANY_ID AS ID,COMPANY_NAME,
MAX(CASE IF_PAY when '已缴费' THEN CONVERT(DECIMAL(18,2),PAYSUM) ELSE 0 end) PAYED,
MAX(CASE IF_PAY when '未缴费' THEN CONVERT(DECIMAL(18,2),PAYSUM) ELSE 0 end) NOPAY
FROM (SELECT T.COMPANY_ID,T.COMPANY_NAME,T.PAYSUM,T.IF_PAY,SUM(PAYSUM) OVER(PARTITION BY T.COMPANY_ID ) AS SUMTOTAL FROM
(
SELECT A.ID,A.CONTRACT_CODE,A.PROJECT_NAME,A.CONTRACT_YEAR,A.ASKING_DATE,B.TEST_FEE,B.ATT_FEE,BUDGET,CONVERT(DECIMAL(18,2),CASE WHEN B.INCOME IS NULL THEN '0' WHEN B.INCOME='NULL' THEN '0' ELSE B.INCOME END) AS INCOME,CASE WHEN B.IF_PAY IS NULL THEN '未缴费' WHEN B.IF_PAY='0' THEN '未缴费' ELSE '已缴费' END AS IF_PAY,
SUM(CONVERT(INT,CASE WHEN B.INCOME IS NULL THEN '0' WHEN B.INCOME='NULL' THEN '0' ELSE B.INCOME END)) OVER(PARTITION BY C.COMPANY_ID,B.IF_PAY) AS PAYSUM,
C.COMPANY_ID,C.COMPANY_NAME,D.DICT_TEXT AS CONTRACT_TYPE FROM T_MIS_CONTRACT A
LEFT JOIN T_MIS_CONTRACT_FEE B ON A.ID=B.CONTRACT_ID
LEFT JOIN dbo.T_MIS_CONTRACT_COMPANY C ON C.ID=TESTED_COMPANY_ID
LEFT JOIN T_SYS_DICT D ON D.DICT_CODE=A.CONTRACT_TYPE AND D.DICT_TYPE='Contract_Type'
WHERE A.CONTRACT_STATUS!='0' {0} ) T GROUP BY T.COMPANY_ID,T.COMPANY_NAME,T.PAYSUM,T.IF_PAY)tb
GROUP BY COMPANY_ID,COMPANY_NAME", TempSQL);
return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count);
}
/// <summary>
/// 获取委托书导出数据 胡方扬 2013-04-23
/// </summary>
/// <param name="tMisContract"></param>
/// <returns></returns>
public DataTable GetExportInforData(TMisContractVo tMisContract)
{
string strSQL = @" SELECT A.*,B.COMPANY_NAME,B.CONTACT_NAME,B.PHONE,B.CONTACT_ADDRESS,B.POST,C.COMPANY_NAME TESTED_COMPANY_NAME,C.CONTACT_NAME TESTED_CONTACT_NAME,C.PHONE TESTED_PHONE,C.CONTACT_ADDRESS TESTED_CONTACT_ADDRESS,C.POST TESTED_POST,D.BUDGET,D.INCOME
FROM T_MIS_CONTRACT A INNER JOIN T_MIS_CONTRACT_COMPANY B ON A.CLIENT_COMPANY_ID=B.ID
INNER JOIN T_MIS_CONTRACT_COMPANY C ON A.TESTED_COMPANY_ID=C.ID
LEFT JOIN T_MIS_CONTRACT_FEE D ON A.ID=D.CONTRACT_ID
WHERE 1=1 ";
if (!String.IsNullOrEmpty(tMisContract.ID))
{
strSQL += String.Format(" AND A.ID ='{0}'", tMisContract.ID);
}
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 获取指定委托书和监测计划的任务信息 胡方扬 2013-04-24
/// </summary>
/// <returns></returns>
private DataTable GetPendingPlanDataTable()
{
DataTable dt = new DataTable();
if (!String.IsNullOrEmpty(task_id) && !String.IsNullOrEmpty(strPlanId))
{
TMisContractPlanVo objItems = new TMisContractPlanVo();
objItems.ID = strPlanId;
TMisContractVo objItemContract = new TMisContractVo();
objItemContract.ID = task_id;
dt = new TMisContractPlanLogic().SelectByTableContractPlanForPending(objItems, objItemContract);
}
return(dt);
}
/// <summary>
/// 获得查询结果总行数，用于分页 Create By : weilin 2014-09-17
/// </summary>
/// <param name="tMisContract">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCountEx(TMisContractVo tMisContract, string strStatus)
{
string strSQL = "select Count(*) from T_MIS_CONTRACT " + this.BuildWhereStatement(tMisContract);
if (strStatus == "0")
{
strSQL += "and ((exists(SELECT * FROM T_MIS_MONITOR_TASK WHERE T_MIS_MONITOR_TASK.CONTRACT_ID=T_MIS_CONTRACT.ID AND TASK_STATUS<>'11') and CONTRACT_STATUS='9') OR CONTRACT_STATUS<>'9')";
}
else if (strStatus == "1")
{
strSQL += "and exists(SELECT * FROM T_MIS_MONITOR_TASK WHERE T_MIS_MONITOR_TASK.CONTRACT_ID=T_MIS_CONTRACT.ID AND TASK_STATUS='11')";
}
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 获取非快捷模式委托书的总计数,用于该类委托书单号生成
/// </summary>
/// <param name="tMisContract"></param>
/// <returns></returns>
public int GetContractCodeCount(TMisContractVo tMisContract)
{
string strSQL = " SELECT ID,PROJECT_NAME,CONTRACT_CODE FROM T_MIS_CONTRACT WHERE 1=1 ";
strSQL += " AND CONTRACT_CODE IS NOT NULL";
if (!String.IsNullOrEmpty(tMisContract.ISQUICKLY))
{
strSQL += String.Format(" AND ISQUICKLY='{0}'", tMisContract.ISQUICKLY);
}
if (String.IsNullOrEmpty(tMisContract.ISQUICKLY))
{
strSQL += String.Format(" AND ISQUICKLY IS NULL OR ISQUICKLY =''");
}
return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count);
}
/// <summary>
/// 发送时更改委托书提交状态
/// </summary>
protected string ChangeStatusBySend()
{
TMisContractVo objContractVo = new TMisContractVo();
objContractVo.ID = this.CONTRACT_ID.Value;
objContractVo.CONTRACT_STATUS = "9";
new TMisContractLogic().Edit(objContractVo);
//委托书信息
objContractVo = new TMisContractLogic().Details(this.CONTRACT_ID.Value);
wfControl.ServiceCode = objContractVo.CONTRACT_CODE;
wfControl.ServiceName = objContractVo.PROJECT_NAME;
return(objContractVo.ID);
}
/// <summary>
/// 获得受检企业信息
/// </summary>
/// <returns></returns>
protected string GetTestedCompanyInfo()
{
//委托书信息
TMisContractVo objContractInfo = new TMisContractVo();
objContractInfo.ID = this.hdnContracID.Value;
objContractInfo.CONTRACT_STATUS = "9";
objContractInfo = new TMisContractLogic().Details(objContractInfo);
//受检企业
TMisContractCompanyVo objTestedInfo = new TMisContractCompanyVo();
objTestedInfo.ID = objContractInfo.TESTED_COMPANY_ID;
objTestedInfo.IS_DEL = "0";
objTestedInfo = new TMisContractCompanyLogic().Details(objTestedInfo);
return(ToJson(objTestedInfo));
}
/// <summary>
/// 获取对象DataTable Create By : weilin 2014-09-17
/// </summary>
/// <param name="tMisContract">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTableEx(TMisContractVo tMisContract, string strStatus, int iIndex, int iCount)
{
string strSQL = " select * from T_MIS_CONTRACT {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tMisContract));
if (strStatus == "0")
{
strSQL += "and ((exists(SELECT * FROM T_MIS_MONITOR_TASK WHERE T_MIS_MONITOR_TASK.CONTRACT_ID=T_MIS_CONTRACT.ID AND TASK_STATUS<>'11') and CONTRACT_STATUS='9') OR CONTRACT_STATUS<>'9')";
}
else if (strStatus == "1")
{
strSQL += "and exists(SELECT * FROM T_MIS_MONITOR_TASK WHERE T_MIS_MONITOR_TASK.CONTRACT_ID=T_MIS_CONTRACT.ID AND TASK_STATUS='11')";
}
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(tMisContract, strSQL, iIndex, iCount)));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisContract">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisContractVo tMisContract, int iIndex, int iCount)
{
//string strSQL = "";
//if (tMisContract.REMARK5 == "0")
//{
// strSQL = " select * from T_MIS_CONTRACT WHERE exists(SELECT * FROM T_MIS_MONITOR_TASK WHERE T_MIS_MONITOR_TASK.CONTRACT_ID=T_MIS_CONTRACT.ID AND TASK_STATUS<>'11') OR CONTRACT_STATUS<>'9' {0} ";
//}
//else if (tMisContract.REMARK5 == "1")
//{
// strSQL = " select * from T_MIS_CONTRACT WHERE exists(SELECT * FROM T_MIS_MONITOR_TASK WHERE T_MIS_MONITOR_TASK.CONTRACT_ID=T_MIS_CONTRACT.ID AND TASK_STATUS='11') {0} ";
//}
string strSQL = " select * from T_MIS_CONTRACT {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tMisContract));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(tMisContract, strSQL, iIndex, iCount)));
}
/// <summary>
/// 获取企业收费记录明细记录列表
/// </summary>
public string GetContractFreeDetialList()
{
string result = "";
dt = new DataTable();
TMisContractVo objItems = new TMisContractVo();
objItems.REMARK3 = strYear;
objItems.REMARK4 = strMonth;
objItems.REMARK5 = strQuarter;
objItems.TESTED_COMPANY_ID = strCompanyId;
dt = new TMisContractFeeLogic().SelectGetCompanyDetailListInfor(objItems, PageIndex, PageSize);
int CountNum = new TMisContractFeeLogic().SelectGetCompanyDetailListInforCount(objItems);
result = LigerGridDataToJson(dt, CountNum);
return(result);
}
/// <summary>
/// 获取委托书费用明细导出数据 魏林 2014-02-25(清远)
/// </summary>
/// <param name="tMisContract"></param>
/// <returns></returns>
public DataTable GetContractFreeData(TMisContractVo tMisContract)
{
string strSQL = @" select A.ID,B.MONITOR_ID,E.MONITOR_TYPE_NAME,F.ITEM_NAME,D.PRETREATMENT_FEE,D.TEST_ANSY_FEE,D.TEST_NUM,D.FREQ,D.TEST_POINT_NUM,D.TEST_POWER_PRICE,D.TEST_PRICE,D.FEE_COUNT,A.PROJECT_NAME,A.TEST_TYPES,G.TEST_FEE,G.ATT_FEE,G.BUDGET from
T_MIS_CONTRACT A INNER JOIN T_MIS_CONTRACT_POINT B on(A.ID=B.CONTRACT_ID)
INNER JOIN T_MIS_CONTRACT_POINTITEM C on(B.ID=C.CONTRACT_POINT_ID)
INNER JOIN T_MIS_CONTRACT_TESTFEE D on(A.ID=D.CONTRACT_ID and C.ID=D.CONTRACT_POINTITEM_ID)
LEFT JOIN T_BASE_MONITOR_TYPE_INFO E on(B.MONITOR_ID=E.ID)
LEFT JOIN T_BASE_ITEM_INFO F on(C.ITEM_ID=F.ID)
LEFT JOIN T_MIS_CONTRACT_FEE G on(A.ID=G.CONTRACT_ID)
WHERE 1=1 ";
if (!String.IsNullOrEmpty(tMisContract.ID))
{
strSQL += String.Format(" AND A.ID ='{0}'", tMisContract.ID);
}
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 获取企业收费记录的明细记录列表
/// </summary>
/// <param name="tMisContract"></param>
/// <returns></returns>
public DataTable SelectGetCompanyDetailListInfor(TMisContractVo tMisContract, int iIndex, int iCount)
{
string StartDate = "", EndDate = "";
string strSQL = String.Format(@"SELECT A.ID,A.CONTRACT_CODE,A.PROJECT_NAME,A.CONTRACT_YEAR,A.ASKING_DATE,B.TEST_FEE,B.ATT_FEE,BUDGET,CONVERT(DECIMAL(18,2),CASE WHEN B.INCOME IS NULL THEN '0' WHEN B.INCOME='NULL' THEN '0' ELSE B.INCOME END) AS INCOME,CASE WHEN B.IF_PAY IS NULL THEN '未缴费' WHEN B.IF_PAY='0' THEN '未缴费' ELSE '已缴费' END AS IF_PAY,
SUM(CONVERT(INT,CASE WHEN B.INCOME IS NULL THEN '0' WHEN B.INCOME='NULL' THEN '0' ELSE B.INCOME END)) OVER(PARTITION BY C.COMPANY_ID,B.IF_PAY) AS PAYSUM,
C.COMPANY_ID,C.COMPANY_NAME,D.DICT_TEXT AS CONTRACT_TYPE FROM T_MIS_CONTRACT A
LEFT JOIN T_MIS_CONTRACT_FEE B ON A.ID=B.CONTRACT_ID
LEFT JOIN dbo.T_MIS_CONTRACT_COMPANY C ON C.ID=TESTED_COMPANY_ID
LEFT JOIN T_SYS_DICT D ON D.DICT_CODE=A.CONTRACT_TYPE AND D.DICT_TYPE='Contract_Type'
WHERE A.CONTRACT_STATUS!='0' ");
if (!String.IsNullOrEmpty(tMisContract.TESTED_COMPANY_ID))
{
strSQL += String.Format(" AND C.COMPANY_ID='{0}'", tMisContract.TESTED_COMPANY_ID);
}
if (!String.IsNullOrEmpty(tMisContract.REMARK3))
{
//月度
strSQL += String.Format(" AND CONVERT(DATETIME, CONVERT(VARCHAR(100), A.ASKING_DATE,23),111) ");
if (!String.IsNullOrEmpty(tMisContract.REMARK4) && String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-{1}-01", tMisContract.REMARK3, tMisContract.REMARK4);
EndDate = String.Format(" {0}-{1}-31", tMisContract.REMARK3, tMisContract.REMARK4);
}
//季度
if (String.IsNullOrEmpty(tMisContract.REMARK4) && !String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-{1}-01", tMisContract.REMARK3, tMisContract.REMARK5);
DateTime strMonth = DateTime.Parse(StartDate);
EndDate = String.Format(" {0}-{1}-31", tMisContract.REMARK3, strMonth.AddMonths(+2).Month.ToString());
}
//年度
if (String.IsNullOrEmpty(tMisContract.REMARK4) && String.IsNullOrEmpty(tMisContract.REMARK5))
{
StartDate = String.Format(" {0}-01-01", tMisContract.REMARK3);
EndDate = String.Format(" {0}-12-31", tMisContract.REMARK3);
}
strSQL += String.Format(" BETWEEN CONVERT(DATETIME, CONVERT(VARCHAR(100),'{0}' ,23),111) AND CONVERT(DATETIME, CONVERT(VARCHAR(100), '{1}' ,23),111) ", StartDate, EndDate);
}
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 获取收费金额明细记录
/// </summary>
public void GetAnalyseFinished()
{
dt = new DataTable();
TMisContractVo objItems = new TMisContractVo();
objItems.REMARK3 = strYear;
objItems.REMARK4 = strMonth;
objItems.REMARK5 = strQuarter;
objItems.CONTRACT_TYPE = strContractType;
objItems.CONTRACT_CODE = strContractCode;
objItems.TESTED_COMPANY_ID = strCompanyName;
TMisContractFeeVo objItemsFree = new TMisContractFeeVo();
dt = new TMisContractFeeLogic().SelectTableForContractFree(objItems, objItemsFree, false);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
}
/// <summary>
/// 获取超时完成的列表
/// </summary>
public void GetAnalyseFinishing()
{
dt = new DataTable();
TMisContractVo objItems = new TMisContractVo();
objItems.CONTRACT_CODE = strContractCode;
objItems.CONTRACT_TYPE = strContractType;
objItems.TESTED_COMPANY_ID = strTestCompany;
objItems.REMARK5 = strDept;
TMisMonitorTaskVo objMvo = new TMisMonitorTaskVo();
objMvo.REMARK3 = strYear;
objMvo.REMARK4 = strMonth;
objMvo.REMARK5 = strQuarter;
dt = new TMisMonitorTaskLogic().SeletByTableReportFinished(objMvo, objItems, false);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
this.reportViewer2.LocalReport.DataSources.Clear();
this.reportViewer2.LocalReport.DataSources.Add(rds);
this.reportViewer2.LocalReport.Refresh();
}
/// <summary>
/// 获取污染源监测列表
/// </summary>
public void GetAnalyseFinished()
{
dt = new DataTable();
TMisContractVo objItems = new TMisContractVo();
objItems.REMARK3 = strMonitor;
objItems.REMARK4 = strContractType;
objItems.REMARK5 = strYear;
TMisMonitorResultAppVo objItemsFree = new TMisMonitorResultAppVo();
objItemsFree.REMARK3 = strCompanyName;
objItemsFree.REMARK4 = strItemName;
objItemsFree.REMARK5 = strPointName;
dt = new TMisMonitorResultAppLogic().GetPollutantSourceReport(objItemsFree, objItems);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
}
/// <summary>
/// 获得委托书信息
/// </summary>
protected void SelectContract()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
//委托年度
string strContract_id = !string.IsNullOrEmpty(Request.QueryString["contract_id"]) ? Request.QueryString["contract_id"].ToString() : "";
if (strContract_id.Trim().Length == 0)
{
Response.Write("");
Response.End();
return;
}
//构造查询对象
TMisContractVo objContract = new TMisContractVo();
TMisContractLogic objContractLogic = new TMisContractLogic();
if (strSortname == null || strSortname.Length == 0)
{
strSortname = TMisContractVo.CONTRACT_CODE_FIELD;
}
objContract.SORT_FIELD = strSortname;
objContract.SORT_TYPE = strSortorder;
objContract.ID = strContract_id;
//int intTotalCount = objContractLogic.GetSelectResultCount(objContract);//总计的数据条数
DataTable dt = objContractLogic.SelectByTable(objContract, 0, 0);
string strJson = CreateToJson(dt, dt.Rows.Count);
Response.Write(strJson);
Response.End();
}
