/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractCompany_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisContractCompany_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractCompanyVo tMisContractCompany_UpdateSet, TMisContractCompanyVo tMisContractCompany_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisContractCompany_UpdateSet, TMisContractCompanyVo.T_MIS_CONTRACT_COMPANY_TABLE);
strSQL += this.BuildWhereStatement(tMisContractCompany_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractCompany">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractCompanyVo tMisContractCompany)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisContractCompany, TMisContractCompanyVo.T_MIS_CONTRACT_COMPANY_TABLE);
strSQL += string.Format(" where ID='{0}' ", tMisContractCompany.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisContractCompany">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisContractCompanyVo tMisContractCompany, int iIndex, int iCount)
{
string strSQL = " select * from T_MIS_CONTRACT_COMPANY {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tMisContractCompany));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisContractCompanyVo tMisContractCompany)
{
string strSQL = "delete from T_MIS_CONTRACT_COMPANY ";
strSQL += this.BuildWhereStatement(tMisContractCompany);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <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));
}
public TMisContractCompanyLogic(TMisContractCompanyVo _tMisContractCompany)
{
tMisContractCompany = _tMisContractCompany;
access = new TMisContractCompanyAccess();
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisContractCompany">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisContractCompanyVo tMisContractCompany)
{
return(access.GetSelectResultCount(tMisContractCompany));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractCompany_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisContractCompany_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractCompanyVo tMisContractCompany_UpdateSet, TMisContractCompanyVo tMisContractCompany_UpdateWhere)
{
return(access.Edit(tMisContractCompany_UpdateSet, tMisContractCompany_UpdateWhere));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisContractCompanyVo tMisContractCompany)
{
return(access.Delete(tMisContractCompany));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisContractCompanyVo tMisContractCompany)
{
return(access.Create(tMisContractCompany));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractCompany">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractCompanyVo tMisContractCompany)
{
return(access.Edit(tMisContractCompany));
}
public int SelectContractPlanInforCount(TMisContractPointFreqVo tMisContractPointFreq, TMisContractVo tMisContract, TMisContractCompanyVo tMisContractCompany)
{
string strSQL = String.Format("SELECT A.*,E.COMPANY_NAME,F.DICT_TEXT AS AREA FROM dbo.T_MIS_CONTRACT A " +
" INNER JOIN " +
" (SELECT * FROM (SELECT DISTINCT (B.CONTRACT_ID) FROM dbo.T_MIS_CONTRACT_POINT_FREQ B WHERE IF_PLAN='{0}')T) D" +
" ON D.CONTRACT_ID=A.ID" +
" LEFT JOIN T_MIS_CONTRACT_COMPANY E ON E.ID=A.TESTED_COMPANY_ID" +
" LEFT JOIN dbo.T_SYS_DICT F ON F.DICT_TYPE='administrative_area' AND F.DICT_CODE=E.AREA WHERE 1=1 ", tMisContractPointFreq.IF_PLAN);
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_TYPE))
{
strSQL += String.Format(" AND A.CONTRACT_TYPE = '{0}'", tMisContract.CONTRACT_TYPE);
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_CODE))
{
strSQL += String.Format(" AND A.CONTRACT_CODE LIKE '%{0}%'", tMisContract.CONTRACT_CODE);
}
if (!String.IsNullOrEmpty(tMisContract.TEST_TYPES))
{
strSQL += String.Format(" AND A.TEST_TYPES LIKE '%{0}%'", tMisContract.TEST_TYPES);
}
if (!String.IsNullOrEmpty(tMisContractCompany.COMPANY_NAME))
{
strSQL += String.Format(" AND E.COMPANY_NAME LIKE '%{0}%'", tMisContractCompany.COMPANY_NAME);
}
if (!String.IsNullOrEmpty(tMisContractCompany.AREA))
{
strSQL += String.Format(" AND E.AREA = '{0}'", tMisContractCompany.AREA);
}
if (!String.IsNullOrEmpty(tMisContract.CONTRACT_STATUS))
{
strSQL += String.Format(" AND A.CONTRACT_STATUS = '{0}'", tMisContract.CONTRACT_STATUS);
}
return(SqlHelper.ExecuteDataTable(strSQL).Rows.Count);
}
public int SelectContractPlanInforCount(TMisContractPointFreqVo tMisContractPointFreq, TMisContractVo tMisContract, TMisContractCompanyVo tMisContractCompany)
{
return(access.SelectContractPlanInforCount(tMisContractPointFreq, tMisContract, tMisContractCompany));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisContractCompany">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisContractCompanyVo> SelectByObject(TMisContractCompanyVo tMisContractCompany, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_MIS_CONTRACT_COMPANY " + this.BuildWhereStatement(tMisContractCompany));
return(SqlHelper.ExecuteObjectList(tMisContractCompany, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisContractCompany">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisContractCompanyVo tMisContractCompany, int iIndex, int iCount)
{
return(access.SelectByTable(tMisContractCompany, iIndex, iCount));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisContractCompany">对象条件</param>
/// <returns>对象</returns>
public TMisContractCompanyVo Details(TMisContractCompanyVo tMisContractCompany)
{
string strSQL = String.Format("select * from T_MIS_CONTRACT_COMPANY " + this.BuildWhereStatement(tMisContractCompany));
return(SqlHelper.ExecuteObject(new TMisContractCompanyVo(), strSQL));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisContractCompany">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisContractCompanyVo tMisContractCompany)
{
string strSQL = "select Count(*) from T_MIS_CONTRACT_COMPANY " + this.BuildWhereStatement(tMisContractCompany);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tMisContractCompany"></param>
/// <returns></returns>
public string BuildWhereStatement(TMisContractCompanyVo tMisContractCompany)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tMisContractCompany)
{
//ID
if (!String.IsNullOrEmpty(tMisContractCompany.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisContractCompany.ID.ToString()));
}
//合同ID
if (!String.IsNullOrEmpty(tMisContractCompany.CONTRACT_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONTRACT_ID = '{0}'", tMisContractCompany.CONTRACT_ID.ToString()));
}
//企业ID
if (!String.IsNullOrEmpty(tMisContractCompany.COMPANY_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_ID = '{0}'", tMisContractCompany.COMPANY_ID.ToString()));
}
//企业法人代码
if (!String.IsNullOrEmpty(tMisContractCompany.COMPANY_CODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_CODE = '{0}'", tMisContractCompany.COMPANY_CODE.ToString()));
}
//企业名称
if (!String.IsNullOrEmpty(tMisContractCompany.COMPANY_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_NAME = '{0}'", tMisContractCompany.COMPANY_NAME.ToString()));
}
//拼音编码
if (!String.IsNullOrEmpty(tMisContractCompany.PINYIN.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PINYIN = '{0}'", tMisContractCompany.PINYIN.ToString()));
}
//主管部门
if (!String.IsNullOrEmpty(tMisContractCompany.DIRECTOR_DEPT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DIRECTOR_DEPT = '{0}'", tMisContractCompany.DIRECTOR_DEPT.ToString()));
}
//经济类型
if (!String.IsNullOrEmpty(tMisContractCompany.ECONOMY_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ECONOMY_TYPE = '{0}'", tMisContractCompany.ECONOMY_TYPE.ToString()));
}
//所在区域
if (!String.IsNullOrEmpty(tMisContractCompany.AREA.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND AREA = '{0}'", tMisContractCompany.AREA.ToString()));
}
//企业规模
if (!String.IsNullOrEmpty(tMisContractCompany.SIZE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SIZE = '{0}'", tMisContractCompany.SIZE.ToString()));
}
//污染源类型
if (!String.IsNullOrEmpty(tMisContractCompany.POLLUTE_TYPE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND POLLUTE_TYPE = '{0}'", tMisContractCompany.POLLUTE_TYPE.ToString()));
}
//行业类别
if (!String.IsNullOrEmpty(tMisContractCompany.INDUSTRY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND INDUSTRY = '{0}'", tMisContractCompany.INDUSTRY.ToString()));
}
//废气控制级别
if (!String.IsNullOrEmpty(tMisContractCompany.GAS_LEAVEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND GAS_LEAVEL = '{0}'", tMisContractCompany.GAS_LEAVEL.ToString()));
}
//废水控制级别
if (!String.IsNullOrEmpty(tMisContractCompany.WATER_LEAVEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WATER_LEAVEL = '{0}'", tMisContractCompany.WATER_LEAVEL.ToString()));
}
//开业时间
if (!String.IsNullOrEmpty(tMisContractCompany.PRACTICE_DATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PRACTICE_DATE = '{0}'", tMisContractCompany.PRACTICE_DATE.ToString()));
}
//联系人
if (!String.IsNullOrEmpty(tMisContractCompany.CONTACT_NAME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONTACT_NAME = '{0}'", tMisContractCompany.CONTACT_NAME.ToString()));
}
//联系部门
if (!String.IsNullOrEmpty(tMisContractCompany.LINK_DEPT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LINK_DEPT = '{0}'", tMisContractCompany.LINK_DEPT.ToString()));
}
//电子邮件
if (!String.IsNullOrEmpty(tMisContractCompany.EMAIL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND EMAIL = '{0}'", tMisContractCompany.EMAIL.ToString()));
}
//联系电话
if (!String.IsNullOrEmpty(tMisContractCompany.LINK_PHONE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LINK_PHONE = '{0}'", tMisContractCompany.LINK_PHONE.ToString()));
}
//委托代理人
if (!String.IsNullOrEmpty(tMisContractCompany.FACTOR.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND FACTOR = '{0}'", tMisContractCompany.FACTOR.ToString()));
}
//办公电话
if (!String.IsNullOrEmpty(tMisContractCompany.PHONE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND PHONE = '{0}'", tMisContractCompany.PHONE.ToString()));
}
//移动电话
if (!String.IsNullOrEmpty(tMisContractCompany.MOBAIL_PHONE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MOBAIL_PHONE = '{0}'", tMisContractCompany.MOBAIL_PHONE.ToString()));
}
//传真号码
if (!String.IsNullOrEmpty(tMisContractCompany.FAX.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND FAX = '{0}'", tMisContractCompany.FAX.ToString()));
}
//邮政编码
if (!String.IsNullOrEmpty(tMisContractCompany.POST.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND POST = '{0}'", tMisContractCompany.POST.ToString()));
}
//联系地址
if (!String.IsNullOrEmpty(tMisContractCompany.CONTACT_ADDRESS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONTACT_ADDRESS = '{0}'", tMisContractCompany.CONTACT_ADDRESS.ToString()));
}
//监测地址
if (!String.IsNullOrEmpty(tMisContractCompany.MONITOR_ADDRESS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MONITOR_ADDRESS = '{0}'", tMisContractCompany.MONITOR_ADDRESS.ToString()));
}
//企业网址
if (!String.IsNullOrEmpty(tMisContractCompany.WEB_SITE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WEB_SITE = '{0}'", tMisContractCompany.WEB_SITE.ToString()));
}
//经度
if (!String.IsNullOrEmpty(tMisContractCompany.LONGITUDE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LONGITUDE = '{0}'", tMisContractCompany.LONGITUDE.ToString()));
}
//纬度
if (!String.IsNullOrEmpty(tMisContractCompany.LATITUDE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND LATITUDE = '{0}'", tMisContractCompany.LATITUDE.ToString()));
}
//使用状态(0为启用、1为停用)
if (!String.IsNullOrEmpty(tMisContractCompany.IS_DEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IS_DEL = '{0}'", tMisContractCompany.IS_DEL.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tMisContractCompany.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisContractCompany.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tMisContractCompany.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisContractCompany.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tMisContractCompany.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisContractCompany.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tMisContractCompany.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tMisContractCompany.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tMisContractCompany.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tMisContractCompany.REMARK5.ToString()));
}
//企业级别
if (!String.IsNullOrEmpty(tMisContractCompany.COMPANY_LEVEL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_LEVEL = '{0}'", tMisContractCompany.COMPANY_LEVEL.ToString()));
}
//法人代表
if (!String.IsNullOrEmpty(tMisContractCompany.COMPANY_MAN.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND COMPANY_MAN = '{0}'", tMisContractCompany.COMPANY_MAN.ToString()));
}
//废水最终排放去向
if (!String.IsNullOrEmpty(tMisContractCompany.WATER_FOLLOW.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WATER_FOLLOW = '{0}'", tMisContractCompany.WATER_FOLLOW.ToString()));
}
//现有工程环评批复时间及文号
if (!String.IsNullOrEmpty(tMisContractCompany.CHECK_TIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CHECK_TIME = '{0}'", tMisContractCompany.CHECK_TIME.ToString()));
}
//现有工程竣工环境保护验收时间
if (!String.IsNullOrEmpty(tMisContractCompany.ACCEPTANCE_TIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ACCEPTANCE_TIME = '{0}'", tMisContractCompany.ACCEPTANCE_TIME.ToString()));
}
//执行标准
if (!String.IsNullOrEmpty(tMisContractCompany.STANDARD.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND STANDARD = '{0}'", tMisContractCompany.STANDARD.ToString()));
}
//主要环保设施名称、数量
if (!String.IsNullOrEmpty(tMisContractCompany.MAIN_APPARATUS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MAIN_APPARATUS = '{0}'", tMisContractCompany.MAIN_APPARATUS.ToString()));
}
//环保设施运行情况
if (!String.IsNullOrEmpty(tMisContractCompany.APPARATUS_STATUS.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND APPARATUS_STATUS = '{0}'", tMisContractCompany.APPARATUS_STATUS.ToString()));
}
//主要产品名称
if (!String.IsNullOrEmpty(tMisContractCompany.MAIN_PROJECT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MAIN_PROJECT = '{0}'", tMisContractCompany.MAIN_PROJECT.ToString()));
}
//主要生产原料
if (!String.IsNullOrEmpty(tMisContractCompany.MAIN_GOOD.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND MAIN_GOOD = '{0}'", tMisContractCompany.MAIN_GOOD.ToString()));
}
//设计生产能力
if (!String.IsNullOrEmpty(tMisContractCompany.DESIGN_ANBILITY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND DESIGN_ANBILITY = '{0}'", tMisContractCompany.DESIGN_ANBILITY.ToString()));
}
//实际生产能力
if (!String.IsNullOrEmpty(tMisContractCompany.ANBILITY.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ANBILITY = '{0}'", tMisContractCompany.ANBILITY.ToString()));
}
//监测期间生产负荷（%）
if (!String.IsNullOrEmpty(tMisContractCompany.CONTRACT_PER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONTRACT_PER = '{0}'", tMisContractCompany.CONTRACT_PER.ToString()));
}
//全年平均生产负荷（%）
if (!String.IsNullOrEmpty(tMisContractCompany.AVG_PER.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND AVG_PER = '{0}'", tMisContractCompany.AVG_PER.ToString()));
}
//废水排放量
if (!String.IsNullOrEmpty(tMisContractCompany.WATER_COUNT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND WATER_COUNT = '{0}'", tMisContractCompany.WATER_COUNT.ToString()));
}
//年运行时间
if (!String.IsNullOrEmpty(tMisContractCompany.YEAR_TIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND YEAR_TIME = '{0}'", tMisContractCompany.YEAR_TIME.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisContractCompany">对象条件</param>
/// <returns>对象</returns>
public TMisContractCompanyVo Details(TMisContractCompanyVo tMisContractCompany)
{
return(access.Details(tMisContractCompany));
}
public DataTable SelectContractPlanInfor(TMisContractPointFreqVo tMisContractPointFreq, TMisContractVo tMisContract, TMisContractCompanyVo tMisContractCompany, int iIndex, int iCount)
{
return(access.SelectContractPlanInfor(tMisContractPointFreq, tMisContract, tMisContractCompany, iIndex, iCount));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisContractCompany">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisContractCompanyVo> SelectByObject(TMisContractCompanyVo tMisContractCompany, int iIndex, int iCount)
{
return(access.SelectByObject(tMisContractCompany, iIndex, iCount));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tMisContractCompany">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisContractCompanyVo tMisContractCompany)
{
string strSQL = SqlHelper.BuildInsertExpress(tMisContractCompany, TMisContractCompanyVo.T_MIS_CONTRACT_COMPANY_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisContractCompany"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisContractCompanyVo tMisContractCompany)
{
return(access.SelectByTable(tMisContractCompany));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisContractCompany"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisContractCompanyVo tMisContractCompany)
{
string strSQL = "select * from T_MIS_CONTRACT_COMPANY " + this.BuildWhereStatement(tMisContractCompany);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tMisContractCompany">对象</param>
/// <returns></returns>
public TMisContractCompanyVo SelectByObject(TMisContractCompanyVo tMisContractCompany)
{
return(access.SelectByObject(tMisContractCompany));
}
protected void ShowData()
{
#region//任务数量
//待办任务
strTaskHasCount = new TWfInstTaskDetailLogic().GetSelectResultCountForUserTaskList(LogInfo.UserInfo.ID, TWfCommDict.StepState.StateNormal, "", "", "", "").ToString();
//今日待办
//strTodayTaskHasCount = new TWfInstTaskDetailLogic().GetSelectResultCountForDayTaskList(new TWfInstTaskDetailVo() { OBJECT_USER = LogInfo.UserInfo.ID, INST_TASK_STATE = i3.ValueObject.Sys.WF.TWfCommDict.StepState.StateNormal }, DateTime.Now.Date.ToShortDateString(), DateTime.Now.Date.ToShortDateString()).ToString();
//已办总数
//strTaskFinishCount = new TWfInstTaskDetailLogic().GetSelectResultCount(new TWfInstTaskDetailVo() { OBJECT_USER = LogInfo.UserInfo.ID, INST_TASK_STATE = i3.ValueObject.Sys.WF.TWfCommDict.StepState.StateDown }).ToString();
//退回任务
//strTaskBackCount = new TWfInstTaskDetailLogic().GetSelectResultCount(new TWfInstTaskDetailVo() { OBJECT_USER = LogInfo.UserInfo.ID, INST_TASK_DEAL_STATE = i3.ValueObject.Sys.WF.TWfCommDict.StepDealState.ForBack }).ToString();
//报告办理
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo(); //监测任务对象
objTask.TASK_STATUS = "09";
if (!base.LogInfo.UserInfo.REAL_NAME.Contains("管理员"))
{
objTask.REPORT_HANDLE = LogInfo.UserInfo.ID;
}
objTask.COMFIRM_STATUS = "0";
ReportCount = new TMisMonitorTaskLogic().GetSelectResultCount(objTask).ToString();
////收文办理
//strSwTaskAllCount = new TOaSwInfoLogic().GetSwResultCount(LogInfo.UserInfo.ID);
////发文待办
//strFwTaskAllCount = new TWfInstTaskDetailLogic().Get_FW_Count(LogInfo.UserInfo.ID, TWfCommDict.StepState.StateNormal);
////发文退回
//strFwTaskBackCount = new TWfInstTaskDetailLogic().Get_FW_Count(LogInfo.UserInfo.ID, TWfCommDict.StepDealState.ForBack);
//采样预约
objTask = new TMisMonitorTaskVo();
TMisContractPlanVo objItems = new TMisContractPlanVo();
TMisContractVo objItemContract = new TMisContractVo();
objItemContract.CONTRACT_STATUS = "9";
TaskPlanCount = new TMisContractPlanLogic().GetSelectByTablePlanForTaskCount(objItems, objItemContract, objTask, false).ToString();
//监督性(国控)预约
TMisContractPointFreqVo objFreq = new TMisContractPointFreqVo();
TMisContractVo objCv = new TMisContractVo();
TMisContractCompanyVo objCom = new TMisContractCompanyVo();
objCv.CONTRACT_STATUS = "9";
objFreq.IF_PLAN = "0";
objCv.CONTRACT_TYPE = "10";
TaskPlan10Count = new TMisContractPointFreqLogic().SelectContractPlanInforCount(objFreq, objCv, objCom).ToString();
//监督性(省控)预约
objCv.CONTRACT_TYPE = "11";
TaskPlan11Count = new TMisContractPointFreqLogic().SelectContractPlanInforCount(objFreq, objCv, objCom).ToString();
//监督性(重金属)预约
objCv.CONTRACT_TYPE = "12";
TaskPlan12Count = new TMisContractPointFreqLogic().SelectContractPlanInforCount(objFreq, objCv, objCom).ToString();
//监督性预约
objCv.CONTRACT_TYPE = "13";
TaskPlan13Count = new TMisContractPointFreqLogic().SelectContractPlanInforCount(objFreq, objCv, objCom).ToString();
//年度委托预约
objCv.CONTRACT_TYPE = "14";
TaskPlan14Count = new TMisContractPointFreqLogic().SelectContractPlanInforCount(objFreq, objCv, objCom).ToString();
//预约办理
objTask.QC_STATUS = "2|3";
TaskDoPlanCount = new TMisContractPlanLogic().GetSelectByTablePlanForDoTaskCount(objItems, objItemContract, objTask, true).ToString();
//采样任务
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskVo();
SamplingCount = new TMisMonitorSubtaskLogic().SelectByTableWithAllTaskForFatherTree(objSubtask, "", "02", "", "", LogInfo.UserInfo.ID, 0, 0).Rows.Count.ToString();
//样品交接
AllocationSheetCount = new TMisMonitorResultLogic().getTaskInfoCount(LogInfo.UserInfo.ID, "sample_allocation_sheet", "021", "'01','00'").ToString();
//样品分发
TaskAllocationCount = new TMisMonitorResultLogic().getTaskInfoCount(LogInfo.UserInfo.ID, "duty_other_analyse", "03", "'01','00'").ToString();
//监测分析
AnalysisCount = new TMisMonitorResultLogic().getResultInResultFlowCount_QY(LogInfo.UserInfo.ID, "20").ToString();
//分析结果复核
ResultCheckCount = new TMisMonitorResultLogic().getTaskInfoCheckCount_QY(LogInfo.UserInfo.ID, "03", "30").ToString();
//分析主任审核
MasterQcCheckCount = new TMisMonitorResultLogic().getTaskInfoQcCheckCount_QY(LogInfo.UserInfo.ID, "analysis_result_check", "03", "50").ToString();
//质控审核
ResultQcCheckCount = new TMisMonitorResultLogic().getTaskInfoQcCheckCount_QY(LogInfo.UserInfo.ID, "analysis_result_qc_check", "03", "40").ToString();
//分析现场项目结果核录
SampleAnalysisCheckCount = new TMisMonitorTaskLogic().SelectSampleTaskForWithSampleAnalysisCountQY(LogInfo.UserInfo.ID, "sample_result_check", "'02','022'", "0", "50").ToString();
//现场监测结果复核
SampleCheckCount = new TMisMonitorSubtaskLogic().SelectSamplingCheckListCount(LogInfo.UserInfo.ID, "022", true).ToString();
//现场室主任审核
SampleQcCheckCount = new TMisMonitorSubtaskLogic().SelectSamplingCheckListCount(LogInfo.UserInfo.ID, "023", false).ToString();
#endregion
#region//任务项数判断
if (strTaskHasCount == "0")
{
this.strTask.Attributes.CssStyle.Value = "display:none";
}
if (strTaskBackCount == "0")
{
this.strTaskBack.Attributes.CssStyle.Value = "display:none";
}
if (TaskPlanCount == "0")
{
this.TaskPlan.Attributes.CssStyle.Value = "display:none";
}
if (TaskPlan10Count == "0")
{
this.TaskPlan_10.Attributes.CssStyle.Value = "display:none";
}
if (TaskPlan11Count == "0")
{
this.TaskPlan_11.Attributes.CssStyle.Value = "display:none";
}
if (TaskPlan12Count == "0")
{
this.TaskPlan_12.Attributes.CssStyle.Value = "display:none";
}
if (TaskPlan13Count == "0")
{
this.TaskPlan_13.Attributes.CssStyle.Value = "display:none";
}
if (TaskPlan14Count == "0")
{
this.TaskPlan_14.Attributes.CssStyle.Value = "display:none";
}
if (TaskDoPlanCount == "0")
{
this.TaskDoPlan.Attributes.CssStyle.Value = "display:none";
}
if (SamplingCount == "0")
{
this.Sampling.Attributes.CssStyle.Value = "display:none";
}
if (AllocationSheetCount == "0")
{
this.AllocationSheet.Attributes.CssStyle.Value = "display:none";
}
if (TaskAllocationCount == "0")
{
this.TaskAllocation.Attributes.CssStyle.Value = "display:none";
}
if (AnalysisCount == "0")
{
this.Analysis.Attributes.CssStyle.Value = "display:none";
}
if (ReportCount == "0")
{
this.ReportManage.Attributes.CssStyle.Value = "display:none";
}
if (ResultCheckCount == "0")
{
this.ResultCheck.Attributes.CssStyle.Value = "display:none";
}
if (MasterQcCheckCount == "0")
{
this.MasterQcCheck.Attributes.CssStyle.Value = "display:none";
}
if (ResultQcCheckCount == "0")
{
this.ResultQcCheck.Attributes.CssStyle.Value = "display:none";
}
if (SampleAnalysisCheckCount == "0")
{
this.SampleAnalysisCheck.Attributes.CssStyle.Value = "display:none";
}
if (SampleCheckCount == "0")
{
this.SampleCheck.Attributes.CssStyle.Value = "display:none";
}
if (SampleQcCheckCount == "0")
{
this.SampleQcCheck.Attributes.CssStyle.Value = "display:none";
}
#endregion
}
