/// <summary>
        /// 对象编辑
        /// </summary>
        /// <param name="tMisMonitorDustattribute">用户对象</param>
        /// <returns>是否成功</returns>
        public bool Edit(TMisMonitorDustattributeVo tMisMonitorDustattribute)
        {
            string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorDustattribute, TMisMonitorDustattributeVo.T_MIS_MONITOR_DUSTATTRIBUTE_TABLE);

            strSQL += string.Format(" where ID='{0}' ", tMisMonitorDustattribute.ID);
            return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
        }
        /// <summary>
        /// 获取对象DataTable
        /// </summary>
        /// <param name="tMisMonitorDustattribute">对象</param>
        /// <param name="iIndex">起始页码</param>
        /// <param name="iCount">每页数目</param>
        /// <returns>返回结果</returns>
        public DataTable SelectByTable(TMisMonitorDustattributeVo tMisMonitorDustattribute, int iIndex, int iCount)
        {
            string strSQL = " select * from T_MIS_MONITOR_DUSTATTRIBUTE {0} order by id";

            strSQL = String.Format(strSQL, BuildWhereStatement(tMisMonitorDustattribute));
            return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
        }
        /// <summary>
        /// 对象编辑
        /// </summary>
        /// <param name="tMisMonitorDustattribute_UpdateSet">UpdateSet用户对象</param>
        /// <param name="tMisMonitorDustattribute_UpdateWhere">UpdateWhere用户对象</param>
        /// <returns>是否成功</returns>
        public bool Edit(TMisMonitorDustattributeVo tMisMonitorDustattribute_UpdateSet, TMisMonitorDustattributeVo tMisMonitorDustattribute_UpdateWhere)
        {
            string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorDustattribute_UpdateSet, TMisMonitorDustattributeVo.T_MIS_MONITOR_DUSTATTRIBUTE_TABLE);

            strSQL += this.BuildWhereStatement(tMisMonitorDustattribute_UpdateWhere);
            return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
        }
        /// <summary>
        /// 对象删除
        /// </summary>
        /// <param name="Id">ID</param>
        /// <returns>是否成功</returns>
        public bool Delete(TMisMonitorDustattributeVo tMisMonitorDustattribute)
        {
            string strSQL = "delete from T_MIS_MONITOR_DUSTATTRIBUTE ";

            strSQL += this.BuildWhereStatement(tMisMonitorDustattribute);

            return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
        }
예제 #5
0
    /// <summary>
    /// 创建原因:根据原始记录表基本数据ID获取当前项目的属性表数据信息
    /// 创建人:胡方扬
    /// 创建日期:2013-07-09
    /// </summary>
    /// <returns></returns>
    public string getAttInfor()
    {
        string result = "";

        if (!String.IsNullOrEmpty(strBaseInfor_Id))
        {
            TMisMonitorDustattributeVo objDustAtt = new TMisMonitorDustattributeVo();
            objDustAtt.BASEINFOR_ID = strBaseInfor_Id;
            objDustAtt.SORT_FIELD   = "ID";
            objDustAtt.SORT_TYPE    = "desc";
            DataTable objDt    = new TMisMonitorDustattributeLogic().SelectByTable(objDustAtt, intPageIndex, intPageSize);
            int       CountNum = new TMisMonitorDustattributeLogic().GetSelectResultCount(objDustAtt);
            result = LigerGridDataToJson(objDt, CountNum);
        }
        return(result);
    }
예제 #6
0
    /// <summary>
    /// 创建原因:根据监测项目基础属性ID,创建初始化属性数据信息
    /// 创建人:胡方扬
    /// 创建时间:2013-07-09
    /// </summary>
    /// <returns></returns>
    public string SaveAttInfor()
    {
        string result = "";

        if (!String.IsNullOrEmpty(strBaseInfor_Id))
        {
            TMisMonitorDustattributeVo objDustAtt = new TMisMonitorDustattributeVo();
            objDustAtt.BASEINFOR_ID = strBaseInfor_Id;
            objDustAtt.SAMPLE_CODE  = (GetDustyCoutForBaseInfor() + 1).ToString();
            objDustAtt.ID           = GetSerialNumber("t_mis_dutyAttInforID");
            if (new TMisMonitorDustattributeLogic().Create(objDustAtt))
            {
                result = objDustAtt.ID;
            }
        }
        return(result);
    }
예제 #7
0
    /// <summary>
    /// 创建原因:根据指定监测项目属性ID 更新指定列的数据
    /// 创建人:胡方扬
    /// 创建时间:2013-07-09
    /// </summary>
    /// <returns></returns>
    public bool UpdateAttValue()
    {
        bool blFlag = false;

        if (!String.IsNullOrEmpty(strAttInfor_Id) && !String.IsNullOrEmpty(strUpdateCell))
        {
            blFlag = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, strUpdateCell, strUpdateCellValue);

            Regex r = new Regex("^\\d+(\\.)?\\d*$");
            TMisMonitorDustattributeVo DustattributeVo = new TMisMonitorDustattributeVo();
            DustattributeVo = new TMisMonitorDustattributeLogic().Details(strAttInfor_Id);
            if (blFlag)
            {
                switch (strUpdateCell)
                {
                case "L_STAND":         //标况体积
                case "SMOKE_DISCHARGE": //定溶体积
                case "SMOKE_POTENCY2":  //油烟浓度
                    //计算油烟排放浓度:(油烟浓度*定溶体积)/标况体积
                    decimal dL_STAND         = r.IsMatch(DustattributeVo.L_STAND) ? decimal.Parse(DustattributeVo.L_STAND) : 0;
                    decimal dSMOKE_DISCHARGE = r.IsMatch(DustattributeVo.SMOKE_DISCHARGE) ? decimal.Parse(DustattributeVo.SMOKE_DISCHARGE) : 0;
                    decimal dSMOKE_POTENCY2  = r.IsMatch(DustattributeVo.SMOKE_POTENCY2) ? decimal.Parse(DustattributeVo.SMOKE_POTENCY2) : 0;
                    decimal dSMOKE_POTENCY   = 0;
                    if (dL_STAND != 0)
                    {
                        dSMOKE_POTENCY = (dSMOKE_POTENCY2 * dSMOKE_DISCHARGE) / dL_STAND;
                        blFlag         = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_POTENCY", Math.Round(dSMOKE_POTENCY, 2).ToString());
                    }
                    break;

                default:
                    break;
                }
            }
        }
        return(blFlag);
    }
        /// <summary>
        /// 根据对象获取全部数据,用Table承载
        ///  数据量较小时使用【不推荐】
        /// </summary>
        /// <param name="tMisMonitorDustattribute"></param>
        /// <returns></returns>
        public DataTable SelectByTable(TMisMonitorDustattributeVo tMisMonitorDustattribute)
        {
            string strSQL = "select * from T_MIS_MONITOR_DUSTATTRIBUTE " + this.BuildWhereStatement(tMisMonitorDustattribute) + " order by id";

            return(SqlHelper.ExecuteDataTable(strSQL));
        }
예제 #9
0
    public string CheckDustyTable(string strSumResultId)
    {
        bool      isSuccess   = true;
        DataTable dtDustinfor = new TMisMonitorDustinforLogic().SelectTableByID(strSumResultId);

        DataRow[] drDustinfor;

        //如果是烟尘,粉尘,总悬浮颗粒物,颗粒物(000001827,000001945,000000130,000000220)初重、终重、重量 不能为空
        drDustinfor = dtDustinfor.Select("ITEM_ID in('000001827','000001945','000000130','000000220')");
        for (int i = 0; i < drDustinfor.Length; i++)
        {
            TMisMonitorDustattributeVo objDustattribute = new TMisMonitorDustattributeVo();
            objDustattribute.BASEINFOR_ID = drDustinfor[i]["ID"].ToString();
            DataTable dt = new TMisMonitorDustattributeLogic().SelectByTable(objDustattribute);
            for (int j = 0; j < dt.Rows.Count; j++)
            {
                if (dt.Rows[j]["FITER_BEGIN_WEIGHT"].ToString().Length == 0 && dt.Rows[j]["SAMPLE_CODE"].ToString() != "平均")
                {
                    isSuccess = false;
                    break;
                }
                if (dt.Rows[j]["FITER_AFTER_WEIGHT"].ToString().Length == 0 && dt.Rows[j]["SAMPLE_CODE"].ToString() != "平均")
                {
                    isSuccess = false;
                    break;
                }
                if (dt.Rows[j]["SAMPLE_WEIGHT"].ToString().Length == 0 && dt.Rows[j]["SAMPLE_CODE"].ToString() != "平均")
                {
                    isSuccess = false;
                    break;
                }
            }

            TMisMonitorDustattributePmVo objDustattributePm = new TMisMonitorDustattributePmVo();
            objDustattributePm.BASEINFOR_ID = drDustinfor[i]["ID"].ToString();
            dt = new TMisMonitorDustattributePmLogic().SelectByTable(objDustattributePm);
            for (int j = 0; j < dt.Rows.Count; j++)
            {
                if (dt.Rows[j]["SAMPLE_FWEIGHT"].ToString().Length == 0 && dt.Rows[j]["FITER_CODE"].ToString() != "平均")
                {
                    isSuccess = false;
                    break;
                }
                if (dt.Rows[j]["SAMPLE_EWEIGHT"].ToString().Length == 0 && dt.Rows[j]["FITER_CODE"].ToString() != "平均")
                {
                    isSuccess = false;
                    break;
                }
                if (dt.Rows[j]["SAMPLE_WEIGHT"].ToString().Length == 0 && dt.Rows[j]["FITER_CODE"].ToString() != "平均")
                {
                    isSuccess = false;
                    break;
                }
            }
        }
        drDustinfor = dtDustinfor.Select("ITEM_ID not in('000001827','000001945','000000130','000000220')");
        for (int i = 0; i < drDustinfor.Length; i++)
        {
            TMisMonitorDustattributeVo objDustattribute = new TMisMonitorDustattributeVo();
            objDustattribute.BASEINFOR_ID = drDustinfor[i]["ID"].ToString();
            DataTable dt = new TMisMonitorDustattributeLogic().SelectByTable(objDustattribute);
            for (int j = 0; j < dt.Rows.Count; j++)
            {
                if (dt.Rows[j]["SMOKE_POTENCY"].ToString().Length == 0 && dt.Rows[j]["SAMPLE_CODE"].ToString() != "平均")
                {
                    isSuccess = false;
                    break;
                }
            }

            TMisMonitorDustattributePmVo objDustattributePm = new TMisMonitorDustattributePmVo();
            objDustattributePm.BASEINFOR_ID = drDustinfor[i]["ID"].ToString();
            dt = new TMisMonitorDustattributePmLogic().SelectByTable(objDustattributePm);
            for (int j = 0; j < dt.Rows.Count; j++)
            {
                if (dt.Rows[j]["SAMPLE_CONCENT"].ToString().Length == 0 && dt.Rows[j]["FITER_CODE"].ToString() != "平均")
                {
                    isSuccess = false;
                    break;
                }
            }
        }

        return(isSuccess == true ? "1" : "0");
    }
        /// <summary>
        /// 获取对象List
        /// </summary>
        /// <param name="tMisMonitorDustattribute">对象</param>
        /// <param name="iIndex">起始页码</param>
        /// <param name="iCount">每页数目</param>
        /// <returns>返回结果</returns>
        public List <TMisMonitorDustattributeVo> SelectByObject(TMisMonitorDustattributeVo tMisMonitorDustattribute, int iIndex, int iCount)
        {
            string strSQL = String.Format("select * from  T_MIS_MONITOR_DUSTATTRIBUTE " + this.BuildWhereStatement(tMisMonitorDustattribute));

            return(SqlHelper.ExecuteObjectList(tMisMonitorDustattribute, BuildPagerExpress(strSQL, iIndex, iCount)));
        }
 /// <summary>
 /// 对象编辑
 /// </summary>
 /// <param name="tMisMonitorDustattribute">用户对象</param>
 /// <returns>是否成功</returns>
 public bool Edit(TMisMonitorDustattributeVo tMisMonitorDustattribute)
 {
     return(access.Edit(tMisMonitorDustattribute));
 }
        /// <summary>
        /// 获得查询结果总行数,用于分页
        /// </summary>
        /// <param name="tMisMonitorDustattribute">对象</param>
        /// <returns>返回行数</returns>
        public int GetSelectResultCount(TMisMonitorDustattributeVo tMisMonitorDustattribute)
        {
            string strSQL = "select Count(*) from T_MIS_MONITOR_DUSTATTRIBUTE " + this.BuildWhereStatement(tMisMonitorDustattribute);

            return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
        }
        /// <summary>
        /// 对象明细
        /// </summary>
        /// <param name="tMisMonitorDustattribute">对象条件</param>
        /// <returns>对象</returns>
        public TMisMonitorDustattributeVo Details(TMisMonitorDustattributeVo tMisMonitorDustattribute)
        {
            string strSQL = String.Format("select * from  T_MIS_MONITOR_DUSTATTRIBUTE " + this.BuildWhereStatement(tMisMonitorDustattribute));

            return(SqlHelper.ExecuteObject(new TMisMonitorDustattributeVo(), strSQL));
        }
예제 #14
0
    /// <summary>
    /// 创建原因:根据指定监测项目属性ID 更新指定列的数据
    /// 创建人:胡方扬
    /// 创建时间:2013-07-09
    /// </summary>
    /// <returns></returns>
    public bool UpdateAttValue()
    {
        bool blFlag = false;

        if (!String.IsNullOrEmpty(strAttInfor_Id) && !String.IsNullOrEmpty(strUpdateCell))
        {
            blFlag = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, strUpdateCell, strUpdateCellValue);

            Regex r = new Regex("^\\d+(\\.)?\\d*$");
            TMisMonitorDustattributeVo DustattributeVo = new TMisMonitorDustattributeVo();
            DustattributeVo = new TMisMonitorDustattributeLogic().Details(strAttInfor_Id);
            if (blFlag)
            {
                switch (strUpdateCell)
                {
                case "FITER_BEGIN_WEIGHT":       //初重
                case "FITER_AFTER_WEIGHT":       //终重
                    //计算样品重量:终重-初重
                    decimal dWEIGHT_BEGIN = r.IsMatch(DustattributeVo.FITER_BEGIN_WEIGHT) ? decimal.Parse(DustattributeVo.FITER_BEGIN_WEIGHT) : 0;
                    decimal dWEIGHT_END   = r.IsMatch(DustattributeVo.FITER_AFTER_WEIGHT) ? decimal.Parse(DustattributeVo.FITER_AFTER_WEIGHT) : 0;
                    decimal dWEIGHT       = Math.Abs(dWEIGHT_END - dWEIGHT_BEGIN);
                    blFlag = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SAMPLE_WEIGHT", dWEIGHT.ToString());
                    //计算烟尘浓度:(样品重量/标况体积)*1000000
                    decimal dL_STAND = r.IsMatch(DustattributeVo.L_STAND) ? decimal.Parse(DustattributeVo.L_STAND) : 0;
                    decimal dPOTENCY = 0;
                    if (dL_STAND != 0)
                    {
                        dPOTENCY = (dWEIGHT / dL_STAND) * 1000000;
                        blFlag   = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_POTENCY", Math.Round(dPOTENCY, 0).ToString());
                    }
                    //计算烟尘折算浓度:((21/(21-烟气含氧量))*烟尘浓度)/折算系数
                    decimal dOXYGEN = r.IsMatch(DustattributeVo.SMOKE_OXYGEN) ? decimal.Parse(DustattributeVo.SMOKE_OXYGEN) : 0;
                    TMisMonitorDustinforVo DustinforVo = new TMisMonitorDustinforLogic().Details(DustattributeVo.BASEINFOR_ID);
                    decimal dMODUL_NUM = r.IsMatch(DustinforVo.MODUL_NUM) ? decimal.Parse(DustinforVo.MODUL_NUM) : 0;
                    decimal dPOTENCY2  = 0;
                    if (dMODUL_NUM != 0)
                    {
                        dPOTENCY2 = ((21 / (21 - dOXYGEN)) * dPOTENCY) / dMODUL_NUM;
                        blFlag    = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_POTENCY2", Math.Round(dPOTENCY2, 0).ToString());
                    }
                    //计算烟尘排放量:(烟尘浓度*标态流量)/1000000
                    decimal dSPEED = r.IsMatch(DustattributeVo.NM_SPEED) ? decimal.Parse(DustattributeVo.NM_SPEED) : 0;
                    blFlag = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_DISCHARGE", Math.Round((dPOTENCY * dSPEED) / 1000000, 3).ToString());
                    break;

                case "SAMPLE_WEIGHT":            //样品重量
                    //计算烟尘浓度:(样品重量/标况体积)*1000000
                    dL_STAND = r.IsMatch(DustattributeVo.L_STAND) ? decimal.Parse(DustattributeVo.L_STAND) : 0;
                    dWEIGHT  = r.IsMatch(DustattributeVo.SAMPLE_WEIGHT) ? decimal.Parse(DustattributeVo.SAMPLE_WEIGHT) : 0;
                    dPOTENCY = 0;
                    if (dL_STAND != 0)
                    {
                        dPOTENCY = (dWEIGHT / dL_STAND) * 1000000;
                        blFlag   = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_POTENCY", Math.Round(dPOTENCY, 0).ToString());
                    }
                    //计算烟尘折算浓度:((21/(21-烟气含氧量))*烟尘浓度)/折算系数
                    dOXYGEN     = r.IsMatch(DustattributeVo.SMOKE_OXYGEN) ? decimal.Parse(DustattributeVo.SMOKE_OXYGEN) : 0;
                    DustinforVo = new TMisMonitorDustinforLogic().Details(DustattributeVo.BASEINFOR_ID);
                    dMODUL_NUM  = r.IsMatch(DustinforVo.MODUL_NUM) ? decimal.Parse(DustinforVo.MODUL_NUM) : 0;
                    dPOTENCY2   = 0;
                    if (dMODUL_NUM != 0)
                    {
                        dPOTENCY2 = ((21 / (21 - dOXYGEN)) * dPOTENCY) / dMODUL_NUM;
                        blFlag    = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_POTENCY2", Math.Round(dPOTENCY2, 0).ToString());
                    }
                    //计算烟尘排放量:(烟尘浓度*标态流量)/1000000
                    dSPEED = r.IsMatch(DustattributeVo.NM_SPEED) ? decimal.Parse(DustattributeVo.NM_SPEED) : 0;
                    blFlag = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_DISCHARGE", Math.Round((dPOTENCY * dSPEED) / 1000000, 3).ToString());
                    break;

                case "SMOKE_POTENCY":            //烟尘浓度
                    //计算烟尘折算浓度:((21/(21-烟气含氧量))*烟尘浓度)/折算系数
                    dPOTENCY    = r.IsMatch(DustattributeVo.SMOKE_POTENCY) ? decimal.Parse(DustattributeVo.SMOKE_POTENCY) : 0;
                    dOXYGEN     = r.IsMatch(DustattributeVo.SMOKE_OXYGEN) ? decimal.Parse(DustattributeVo.SMOKE_OXYGEN) : 0;
                    DustinforVo = new TMisMonitorDustinforLogic().Details(DustattributeVo.BASEINFOR_ID);
                    dMODUL_NUM  = r.IsMatch(DustinforVo.MODUL_NUM) ? decimal.Parse(DustinforVo.MODUL_NUM) : 0;
                    dPOTENCY2   = 0;
                    if (dMODUL_NUM != 0)
                    {
                        dPOTENCY2 = ((21 / (21 - dOXYGEN)) * dPOTENCY) / dMODUL_NUM;
                        blFlag    = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_POTENCY2", Math.Round(dPOTENCY2, 0).ToString());
                    }
                    else
                    {
                        if (DustattributeVo.SAMPLE_CODE == "平均")
                        {
                            //更新结果表
                            TMisMonitorResultVo objResultVo = new TMisMonitorResultVo();
                            objResultVo.ID          = DustinforVo.SUBTASK_ID;
                            objResultVo.ITEM_RESULT = strUpdateCellValue;
                            blFlag = new TMisMonitorResultLogic().Edit(objResultVo);
                        }
                    }
                    //计算烟尘排放量:(烟尘浓度*标态流量)/1000000
                    dSPEED = r.IsMatch(DustattributeVo.NM_SPEED) ? decimal.Parse(DustattributeVo.NM_SPEED) : 0;
                    blFlag = new TMisMonitorDustattributeLogic().UpdateCell(strAttInfor_Id, "SMOKE_DISCHARGE", Math.Round((dPOTENCY * dSPEED) / 1000000, 3).ToString());
                    break;

                case "SMOKE_POTENCY2":
                    DustinforVo = new TMisMonitorDustinforLogic().Details(DustattributeVo.BASEINFOR_ID);
                    dMODUL_NUM  = r.IsMatch(DustinforVo.MODUL_NUM) ? decimal.Parse(DustinforVo.MODUL_NUM) : 0;
                    if (dMODUL_NUM != 0 && DustattributeVo.SAMPLE_CODE == "平均")
                    {
                        //更新结果表
                        TMisMonitorResultVo objResultVo = new TMisMonitorResultVo();
                        objResultVo.ID          = DustinforVo.SUBTASK_ID;
                        objResultVo.ITEM_RESULT = strUpdateCellValue;
                        blFlag = new TMisMonitorResultLogic().Edit(objResultVo);
                    }
                    break;

                default:
                    break;
                }
            }
        }
        return(blFlag);
    }
 public TMisMonitorDustattributeLogic(TMisMonitorDustattributeVo _tMisMonitorDustattribute)
 {
     tMisMonitorDustattribute = _tMisMonitorDustattribute;
     access = new TMisMonitorDustattributeAccess();
 }
 /// <summary>
 /// 对象编辑
 /// </summary>
 /// <param name="tMisMonitorDustattribute_UpdateSet">UpdateSet用户对象</param>
 /// <param name="tMisMonitorDustattribute_UpdateWhere">UpdateWhere用户对象</param>
 /// <returns>是否成功</returns>
 public bool Edit(TMisMonitorDustattributeVo tMisMonitorDustattribute_UpdateSet, TMisMonitorDustattributeVo tMisMonitorDustattribute_UpdateWhere)
 {
     return(access.Edit(tMisMonitorDustattribute_UpdateSet, tMisMonitorDustattribute_UpdateWhere));
 }
 /// <summary>
 /// 获得查询结果总行数,用于分页
 /// </summary>
 /// <param name="tMisMonitorDustattribute">对象</param>
 /// <returns>返回行数</returns>
 public int GetSelectResultCount(TMisMonitorDustattributeVo tMisMonitorDustattribute)
 {
     return(access.GetSelectResultCount(tMisMonitorDustattribute));
 }
        /// <summary>
        /// 对象添加
        /// </summary>
        /// <param name="tMisMonitorDustattribute">对象</param>
        /// <returns>是否成功</returns>
        public bool Create(TMisMonitorDustattributeVo tMisMonitorDustattribute)
        {
            string strSQL = SqlHelper.BuildInsertExpress(tMisMonitorDustattribute, TMisMonitorDustattributeVo.T_MIS_MONITOR_DUSTATTRIBUTE_TABLE);

            return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
        }
 /// <summary>
 /// 根据对象获取全部数据,用Table承载
 ///  数据量较小时使用【不推荐】
 /// </summary>
 /// <param name="tMisMonitorDustattribute"></param>
 /// <returns></returns>
 public DataTable SelectByTable(TMisMonitorDustattributeVo tMisMonitorDustattribute)
 {
     return(access.SelectByTable(tMisMonitorDustattribute));
 }
 /// <summary>
 /// 获取对象DataTable
 /// </summary>
 /// <param name="tMisMonitorDustattribute">对象</param>
 /// <param name="iIndex">起始页码</param>
 /// <param name="iCount">每页数目</param>
 /// <returns>返回结果</returns>
 public DataTable SelectByTable(TMisMonitorDustattributeVo tMisMonitorDustattribute, int iIndex, int iCount)
 {
     return(access.SelectByTable(tMisMonitorDustattribute, iIndex, iCount));
 }
 /// <summary>
 /// 获取对象List
 /// </summary>
 /// <param name="tMisMonitorDustattribute">对象</param>
 /// <param name="iIndex">起始页码</param>
 /// <param name="iCount">每页数目</param>
 /// <returns>返回结果</returns>
 public List <TMisMonitorDustattributeVo> SelectByObject(TMisMonitorDustattributeVo tMisMonitorDustattribute, int iIndex, int iCount)
 {
     return(access.SelectByObject(tMisMonitorDustattribute, iIndex, iCount));
 }
 /// <summary>
 /// 对象明细
 /// </summary>
 /// <param name="tMisMonitorDustattribute">对象条件</param>
 /// <returns>对象</returns>
 public TMisMonitorDustattributeVo Details(TMisMonitorDustattributeVo tMisMonitorDustattribute)
 {
     return(access.Details(tMisMonitorDustattribute));
 }
예제 #23
0
    /// <summary>
    /// 创建原因:计算原始记录表的平均数据
    /// 创建人:魏林
    /// 创建时间:2014-04-16
    /// </summary>
    /// <returns></returns>
    public string AvgAttInfor()
    {
        Regex   r = new Regex("^\\d+(\\.)?\\d*$");
        bool    iSuccess = true;
        decimal SMOKE_TEMPERATURE = 0, SMOKE_OXYGEN = 0, SMOKE_SPEED = 0, NM_SPEED = 0, L_STAND = 0;
        decimal SMOKE_POTENCY = 0, SMOKE_POTENCY2 = 0, SMOKE_DISCHARGE = 0;
        decimal SMOKE_TEMPERATURE_COut = 0, SMOKE_OXYGEN_COut = 0, SMOKE_SPEED_COut = 0, NM_SPEED_COut = 0, L_STAND_COut = 0, SMOKE_POTENCY_COut = 0, SMOKE_POTENCY2_COut = 0, SMOKE_DISCHARGE_COut = 0;
        int     iPRECISION = 0; //平均值的小数位位数

        if (!String.IsNullOrEmpty(strBaseInfor_Id))
        {
            TMisMonitorDustattributeVo objDustAtt = new TMisMonitorDustattributeVo();
            objDustAtt.BASEINFOR_ID = strBaseInfor_Id;
            objDustAtt.SORT_FIELD   = "ID";
            DataTable dt = new TMisMonitorDustattributeLogic().SelectByTable(objDustAtt);
            if (dt.Rows[dt.Rows.Count - 1]["SAMPLE_CODE"].ToString() == "平均")
            {
                objDustAtt.SORT_FIELD = "";
                objDustAtt.ID         = dt.Rows[dt.Rows.Count - 1]["ID"].ToString();
                for (int i = 0; i < dt.Rows.Count - 1; i++)
                {
                    if (r.IsMatch(dt.Rows[i]["SMOKE_TEMPERATURE"].ToString()))
                    {
                        SMOKE_TEMPERATURE += decimal.Parse(dt.Rows[i]["SMOKE_TEMPERATURE"].ToString());
                    }
                    else
                    {
                        SMOKE_TEMPERATURE_COut = GetNumber(dt.Rows[i]["SMOKE_TEMPERATURE"].ToString());
                        SMOKE_TEMPERATURE     += SMOKE_TEMPERATURE_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_OXYGEN"].ToString()))
                    {
                        SMOKE_OXYGEN += decimal.Parse(dt.Rows[i]["SMOKE_OXYGEN"].ToString());
                    }
                    else
                    {
                        SMOKE_OXYGEN_COut = GetNumber(dt.Rows[i]["SMOKE_OXYGEN"].ToString());
                        SMOKE_OXYGEN     += SMOKE_OXYGEN_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_SPEED"].ToString()))
                    {
                        SMOKE_SPEED += decimal.Parse(dt.Rows[i]["SMOKE_SPEED"].ToString());
                    }
                    else
                    {
                        SMOKE_SPEED_COut = GetNumber(dt.Rows[i]["SMOKE_SPEED"].ToString());
                        SMOKE_SPEED     += SMOKE_SPEED_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["NM_SPEED"].ToString()))
                    {
                        NM_SPEED += decimal.Parse(dt.Rows[i]["NM_SPEED"].ToString());
                    }
                    else
                    {
                        NM_SPEED_COut = GetNumber(dt.Rows[i]["NM_SPEED"].ToString());
                        NM_SPEED     += NM_SPEED_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["L_STAND"].ToString()))
                    {
                        L_STAND += decimal.Parse(dt.Rows[i]["L_STAND"].ToString());
                    }
                    else
                    {
                        L_STAND_COut = GetNumber(dt.Rows[i]["L_STAND"].ToString());
                        L_STAND     += L_STAND_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_POTENCY"].ToString()))
                    {
                        SMOKE_POTENCY += decimal.Parse(dt.Rows[i]["SMOKE_POTENCY"].ToString());
                    }
                    else
                    {
                        SMOKE_POTENCY_COut = GetNumber(dt.Rows[i]["SMOKE_POTENCY"].ToString());
                        SMOKE_POTENCY     += SMOKE_POTENCY_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_POTENCY2"].ToString()))
                    {
                        SMOKE_POTENCY2 += decimal.Parse(dt.Rows[i]["SMOKE_POTENCY2"].ToString());
                    }
                    else
                    {
                        SMOKE_POTENCY2_COut = GetNumber(dt.Rows[i]["SMOKE_POTENCY2"].ToString());
                        SMOKE_POTENCY2     += SMOKE_POTENCY2_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_DISCHARGE"].ToString()))
                    {
                        SMOKE_DISCHARGE += decimal.Parse(dt.Rows[i]["SMOKE_DISCHARGE"].ToString());
                    }
                    else
                    {
                        SMOKE_DISCHARGE_COut = GetNumber(dt.Rows[i]["SMOKE_DISCHARGE"].ToString());
                        SMOKE_DISCHARGE     += SMOKE_DISCHARGE_COut / 2;
                    }
                }
                iPRECISION = dt.Rows[0]["SMOKE_TEMPERATURE"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_TEMPERATURE"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_TEMPERATURE_COut != 0 && Math.Round(SMOKE_TEMPERATURE / (dt.Rows.Count - 1), iPRECISION) < SMOKE_TEMPERATURE_COut)
                {
                    objDustAtt.SMOKE_TEMPERATURE = SMOKE_TEMPERATURE_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_TEMPERATURE = Math.Round(SMOKE_TEMPERATURE / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_OXYGEN"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_OXYGEN"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_OXYGEN_COut != 0 && Math.Round(SMOKE_OXYGEN / (dt.Rows.Count - 1), iPRECISION) < SMOKE_OXYGEN_COut)
                {
                    objDustAtt.SMOKE_OXYGEN = SMOKE_OXYGEN_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_OXYGEN = Math.Round(SMOKE_OXYGEN / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_SPEED"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_SPEED"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_SPEED_COut != 0 && Math.Round(SMOKE_SPEED / (dt.Rows.Count - 1), iPRECISION) < SMOKE_SPEED_COut)
                {
                    objDustAtt.SMOKE_SPEED = SMOKE_SPEED_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_SPEED = Math.Round(SMOKE_SPEED / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["NM_SPEED"].ToString().Contains('.') ? dt.Rows[0]["NM_SPEED"].ToString().Split('.')[1].Length : 0;
                if (NM_SPEED_COut != 0 && Math.Round(NM_SPEED / (dt.Rows.Count - 1), iPRECISION) < NM_SPEED_COut)
                {
                    objDustAtt.NM_SPEED = NM_SPEED_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.NM_SPEED = Math.Round(NM_SPEED / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["L_STAND"].ToString().Contains('.') ? dt.Rows[0]["L_STAND"].ToString().Split('.')[1].Length : 0;
                if (L_STAND_COut != 0 && Math.Round(L_STAND / (dt.Rows.Count - 1), iPRECISION) < L_STAND_COut)
                {
                    objDustAtt.L_STAND = L_STAND_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.L_STAND = Math.Round(L_STAND / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_POTENCY"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_POTENCY"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_POTENCY_COut != 0 && Math.Round(SMOKE_POTENCY / (dt.Rows.Count - 1), iPRECISION) < SMOKE_POTENCY_COut)
                {
                    objDustAtt.SMOKE_POTENCY = SMOKE_POTENCY_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_POTENCY = Math.Round(SMOKE_POTENCY / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_POTENCY2"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_POTENCY2"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_POTENCY2_COut != 0 && Math.Round(SMOKE_POTENCY2 / (dt.Rows.Count - 1), iPRECISION) < SMOKE_POTENCY2_COut)
                {
                    objDustAtt.SMOKE_POTENCY2 = SMOKE_POTENCY2_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_POTENCY2 = Math.Round(SMOKE_POTENCY2 / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_DISCHARGE"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_DISCHARGE"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_DISCHARGE_COut != 0 && Math.Round(SMOKE_DISCHARGE / (dt.Rows.Count - 1), iPRECISION) < SMOKE_DISCHARGE_COut)
                {
                    objDustAtt.SMOKE_DISCHARGE = SMOKE_DISCHARGE_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_DISCHARGE = Math.Round(SMOKE_DISCHARGE / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iSuccess = new TMisMonitorDustattributeLogic().Edit(objDustAtt);
            }
            else
            {
                objDustAtt.SORT_FIELD  = "";
                objDustAtt.ID          = GetSerialNumber("t_mis_dutyAttInforID");
                objDustAtt.SAMPLE_CODE = "平均";
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (r.IsMatch(dt.Rows[i]["SMOKE_TEMPERATURE"].ToString()))
                    {
                        SMOKE_TEMPERATURE += decimal.Parse(dt.Rows[i]["SMOKE_TEMPERATURE"].ToString());
                    }
                    else
                    {
                        SMOKE_TEMPERATURE_COut = GetNumber(dt.Rows[i]["SMOKE_TEMPERATURE"].ToString());
                        SMOKE_TEMPERATURE     += SMOKE_TEMPERATURE_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_OXYGEN"].ToString()))
                    {
                        SMOKE_OXYGEN += decimal.Parse(dt.Rows[i]["SMOKE_OXYGEN"].ToString());
                    }
                    else
                    {
                        SMOKE_OXYGEN_COut = GetNumber(dt.Rows[i]["SMOKE_OXYGEN"].ToString());
                        SMOKE_OXYGEN     += SMOKE_OXYGEN_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_SPEED"].ToString()))
                    {
                        SMOKE_SPEED += decimal.Parse(dt.Rows[i]["SMOKE_SPEED"].ToString());
                    }
                    else
                    {
                        SMOKE_SPEED_COut = GetNumber(dt.Rows[i]["SMOKE_SPEED"].ToString());
                        SMOKE_SPEED     += SMOKE_SPEED_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["NM_SPEED"].ToString()))
                    {
                        NM_SPEED += decimal.Parse(dt.Rows[i]["NM_SPEED"].ToString());
                    }
                    else
                    {
                        NM_SPEED_COut = GetNumber(dt.Rows[i]["NM_SPEED"].ToString());
                        NM_SPEED     += NM_SPEED_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["L_STAND"].ToString()))
                    {
                        L_STAND += decimal.Parse(dt.Rows[i]["L_STAND"].ToString());
                    }
                    else
                    {
                        L_STAND_COut = GetNumber(dt.Rows[i]["L_STAND"].ToString());
                        L_STAND     += L_STAND_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_POTENCY"].ToString()))
                    {
                        SMOKE_POTENCY += decimal.Parse(dt.Rows[i]["SMOKE_POTENCY"].ToString());
                    }
                    else
                    {
                        SMOKE_POTENCY_COut = GetNumber(dt.Rows[i]["SMOKE_POTENCY"].ToString());
                        SMOKE_POTENCY     += SMOKE_POTENCY_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_POTENCY2"].ToString()))
                    {
                        SMOKE_POTENCY2 += decimal.Parse(dt.Rows[i]["SMOKE_POTENCY2"].ToString());
                    }
                    else
                    {
                        SMOKE_POTENCY2_COut = GetNumber(dt.Rows[i]["SMOKE_POTENCY2"].ToString());
                        SMOKE_POTENCY2     += SMOKE_POTENCY2_COut / 2;
                    }

                    if (r.IsMatch(dt.Rows[i]["SMOKE_DISCHARGE"].ToString()))
                    {
                        SMOKE_DISCHARGE += decimal.Parse(dt.Rows[i]["SMOKE_DISCHARGE"].ToString());
                    }
                    else
                    {
                        SMOKE_DISCHARGE_COut = GetNumber(dt.Rows[i]["SMOKE_DISCHARGE"].ToString());
                        SMOKE_DISCHARGE     += SMOKE_DISCHARGE_COut / 2;
                    }
                }
                iPRECISION = dt.Rows[0]["SMOKE_TEMPERATURE"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_TEMPERATURE"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_TEMPERATURE_COut != 0 && Math.Round(SMOKE_TEMPERATURE / (dt.Rows.Count - 1), iPRECISION) < SMOKE_TEMPERATURE_COut)
                {
                    objDustAtt.SMOKE_TEMPERATURE = SMOKE_TEMPERATURE_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_TEMPERATURE = Math.Round(SMOKE_TEMPERATURE / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_OXYGEN"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_OXYGEN"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_OXYGEN_COut != 0 && Math.Round(SMOKE_OXYGEN / (dt.Rows.Count - 1), iPRECISION) < SMOKE_OXYGEN_COut)
                {
                    objDustAtt.SMOKE_OXYGEN = SMOKE_OXYGEN_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_OXYGEN = Math.Round(SMOKE_OXYGEN / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_SPEED"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_SPEED"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_SPEED_COut != 0 && Math.Round(SMOKE_SPEED / (dt.Rows.Count - 1), iPRECISION) < SMOKE_SPEED_COut)
                {
                    objDustAtt.SMOKE_SPEED = SMOKE_SPEED_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_SPEED = Math.Round(SMOKE_SPEED / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["NM_SPEED"].ToString().Contains('.') ? dt.Rows[0]["NM_SPEED"].ToString().Split('.')[1].Length : 0;
                if (NM_SPEED_COut != 0 && Math.Round(NM_SPEED / (dt.Rows.Count - 1), iPRECISION) < NM_SPEED_COut)
                {
                    objDustAtt.NM_SPEED = NM_SPEED_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.NM_SPEED = Math.Round(NM_SPEED / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["L_STAND"].ToString().Contains('.') ? dt.Rows[0]["L_STAND"].ToString().Split('.')[1].Length : 0;
                if (L_STAND_COut != 0 && Math.Round(L_STAND / (dt.Rows.Count - 1), iPRECISION) < L_STAND_COut)
                {
                    objDustAtt.L_STAND = L_STAND_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.L_STAND = Math.Round(L_STAND / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_POTENCY"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_POTENCY"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_POTENCY_COut != 0 && Math.Round(SMOKE_POTENCY / (dt.Rows.Count - 1), iPRECISION) < SMOKE_POTENCY_COut)
                {
                    objDustAtt.SMOKE_POTENCY = SMOKE_POTENCY_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_POTENCY = Math.Round(SMOKE_POTENCY / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_POTENCY2"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_POTENCY2"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_POTENCY2_COut != 0 && Math.Round(SMOKE_POTENCY2 / (dt.Rows.Count - 1), iPRECISION) < SMOKE_POTENCY2_COut)
                {
                    objDustAtt.SMOKE_POTENCY2 = SMOKE_POTENCY2_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_POTENCY2 = Math.Round(SMOKE_POTENCY2 / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iPRECISION = dt.Rows[0]["SMOKE_DISCHARGE"].ToString().Contains('.') ? dt.Rows[0]["SMOKE_DISCHARGE"].ToString().Split('.')[1].Length : 0;
                if (SMOKE_DISCHARGE_COut != 0 && Math.Round(SMOKE_DISCHARGE / (dt.Rows.Count - 1), iPRECISION) < SMOKE_DISCHARGE_COut)
                {
                    objDustAtt.SMOKE_DISCHARGE = SMOKE_DISCHARGE_COut.ToString() + "(L)";
                }
                else
                {
                    objDustAtt.SMOKE_DISCHARGE = Math.Round(SMOKE_DISCHARGE / (dt.Rows.Count - 1), iPRECISION).ToString();
                }

                iSuccess = new TMisMonitorDustattributeLogic().Create(objDustAtt);
            }

            //更新结果表
            TMisMonitorDustinforVo objDustinforVo = new TMisMonitorDustinforLogic().Details(strBaseInfor_Id);
            TMisMonitorResultVo    objResultVo    = new TMisMonitorResultLogic().Details(objDustinforVo.SUBTASK_ID);
            if (objDustinforVo.MODUL_NUM.Length > 0)
            {
                objResultVo.ITEM_RESULT = objDustAtt.SMOKE_POTENCY2;
            }
            else
            {
                objResultVo.ITEM_RESULT = objDustAtt.SMOKE_POTENCY;
            }
            iSuccess = new TMisMonitorResultLogic().Edit(objResultVo);
        }
        return(iSuccess ? "1" : "0");
    }
 /// <summary>
 /// 对象添加
 /// </summary>
 /// <param name="sysRole">对象</param>
 /// <returns>是否成功</returns>
 public bool Create(TMisMonitorDustattributeVo tMisMonitorDustattribute)
 {
     return(access.Create(tMisMonitorDustattribute));
 }
        /// <summary>
        /// 根据对象构造条件语句
        /// </summary>
        /// <param name="tMisMonitorDustattribute"></param>
        /// <returns></returns>
        public string BuildWhereStatement(TMisMonitorDustattributeVo tMisMonitorDustattribute)
        {
            StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");

            if (null != tMisMonitorDustattribute)
            {
                //
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.ID.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisMonitorDustattribute.ID.ToString()));
                }
                //
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.BASEINFOR_ID.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND BASEINFOR_ID = '{0}'", tMisMonitorDustattribute.BASEINFOR_ID.ToString()));
                }
                //采样序号
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SAMPLE_CODE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SAMPLE_CODE = '{0}'", tMisMonitorDustattribute.SAMPLE_CODE.ToString()));
                }
                //滤筒编号
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.FITER_CODE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND FITER_CODE = '{0}'", tMisMonitorDustattribute.FITER_CODE.ToString()));
                }
                //采样日期
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SAMPLE_DATE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SAMPLE_DATE = '{0}'", tMisMonitorDustattribute.SAMPLE_DATE.ToString()));
                }
                //烟气动压
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_MOVE_PRESSURE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_MOVE_PRESSURE = '{0}'", tMisMonitorDustattribute.SMOKE_MOVE_PRESSURE.ToString()));
                }
                //烟气静压
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_STATIC_PRESSURE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_STATIC_PRESSURE = '{0}'", tMisMonitorDustattribute.SMOKE_STATIC_PRESSURE.ToString()));
                }
                //烟气全压
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_ALL_PRESSURE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_ALL_PRESSURE = '{0}'", tMisMonitorDustattribute.SMOKE_ALL_PRESSURE.ToString()));
                }
                //烟气计压
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_K_PRESSURE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_K_PRESSURE = '{0}'", tMisMonitorDustattribute.SMOKE_K_PRESSURE.ToString()));
                }
                //烟气温度
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_TEMPERATURE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_TEMPERATURE = '{0}'", tMisMonitorDustattribute.SMOKE_TEMPERATURE.ToString()));
                }
                //烟气含氧量
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_OXYGEN.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_OXYGEN = '{0}'", tMisMonitorDustattribute.SMOKE_OXYGEN.ToString()));
                }
                //烟气流速
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_SPEED.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_SPEED = '{0}'", tMisMonitorDustattribute.SMOKE_SPEED.ToString()));
                }
                //标态流量
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.NM_SPEED.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND NM_SPEED = '{0}'", tMisMonitorDustattribute.NM_SPEED.ToString()));
                }
                //标况体积
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.L_STAND.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND L_STAND = '{0}'", tMisMonitorDustattribute.L_STAND.ToString()));
                }
                //滤筒初重
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.FITER_BEGIN_WEIGHT.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND FITER_BEGIN_WEIGHT = '{0}'", tMisMonitorDustattribute.FITER_BEGIN_WEIGHT.ToString()));
                }
                //滤筒终重
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.FITER_AFTER_WEIGHT.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND FITER_AFTER_WEIGHT = '{0}'", tMisMonitorDustattribute.FITER_AFTER_WEIGHT.ToString()));
                }
                //样品重量
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SAMPLE_WEIGHT.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SAMPLE_WEIGHT = '{0}'", tMisMonitorDustattribute.SAMPLE_WEIGHT.ToString()));
                }
                //烟尘浓度
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_POTENCY.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_POTENCY = '{0}'", tMisMonitorDustattribute.SMOKE_POTENCY.ToString()));
                }
                //烟尘折算浓度
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_POTENCY2.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_POTENCY2 = '{0}'", tMisMonitorDustattribute.SMOKE_POTENCY2.ToString()));
                }
                //烟尘排放量
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.SMOKE_DISCHARGE.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND SMOKE_DISCHARGE = '{0}'", tMisMonitorDustattribute.SMOKE_DISCHARGE.ToString()));
                }
                //
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.REMARK1.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisMonitorDustattribute.REMARK1.ToString()));
                }
                //
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.REMARK2.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisMonitorDustattribute.REMARK2.ToString()));
                }
                //
                if (!String.IsNullOrEmpty(tMisMonitorDustattribute.REMARK3.ToString().Trim()))
                {
                    strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisMonitorDustattribute.REMARK3.ToString()));
                }
            }
            return(strWhereStatement.ToString());
        }
 /// <summary>
 /// 对象删除
 /// </summary>
 /// <param name="Id">ID</param>
 /// <returns>是否成功</returns>
 public bool Delete(TMisMonitorDustattributeVo tMisMonitorDustattribute)
 {
     return(access.Delete(tMisMonitorDustattribute));
 }
예제 #27
0
    /// <summary>
    /// 获取监测项目信息
    /// </summary>
    /// <returns></returns>
    private string getFourGridInfo(string strThreeGridId)
    {
        string strSortname  = Request.Params["sortname"];
        string strSortorder = Request.Params["sortorder"];
        //当前页面
        int intPageIndex = Convert.ToInt32(Request.Params["page"]);
        //每页记录数
        int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);

        DataTable dt = new TMisMonitorResultLogic().getItemInfoInAlloction_QHD(strThreeGridId, "'01','00'", "0", "", "", intPageIndex, intPageSize);

        //退回意见
        for (int i = 0; i < dt.Rows.Count; i++)
        {
            TMisMonitorResultVo     objResutlVo     = new TMisMonitorResultLogic().Details(dt.Rows[i]["ID"].ToString());
            TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(objResutlVo.SAMPLE_ID);
            TMisMonitorSubtaskVo    objSubtaskVo    = new TMisMonitorSubtaskLogic().Details(objSampleInfoVo.SUBTASK_ID);

            TMisReturnInfoVo objReturnInfoVo = new TMisReturnInfoVo();
            objReturnInfoVo.TASK_ID        = objSubtaskVo.TASK_ID;
            objReturnInfoVo.SUBTASK_ID     = objSubtaskVo.ID;
            objReturnInfoVo.RESULT_ID      = dt.Rows[i]["ID"].ToString();
            objReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_007;
            objReturnInfoVo.BACKTO_STATUS  = SerialType.Monitor_006;
            objReturnInfoVo        = new TMisReturnInfoLogic().Details(objReturnInfoVo);
            dt.Rows[i]["REMARK_1"] = objReturnInfoVo.SUGGESTION;

            //获取原始记录表的采样编号
            DataTable dtInfo        = new DataTable();
            DataRow[] drInfo        = dtInfo.Select("1=2");
            string    strFiter_Code = "";
            TMisMonitorDustinforVo objDustinforVo = new TMisMonitorDustinforVo();
            objDustinforVo.SUBTASK_ID = dt.Rows[i]["ID"].ToString();
            objDustinforVo            = new TMisMonitorDustinforLogic().Details(objDustinforVo);
            if (objDustinforVo.ID.Length > 0)
            {
                TMisMonitorDustattributeVo objDustattributeVo = new TMisMonitorDustattributeVo();
                objDustattributeVo.BASEINFOR_ID = objDustinforVo.ID;
                dtInfo = new TMisMonitorDustattributeLogic().SelectByTable(objDustattributeVo);
                if (dtInfo.Rows.Count > 0)
                {
                    drInfo = dtInfo.Select("FITER_CODE<>'平均'");
                }
                else
                {
                    TMisMonitorDustattributeSo2ornoxVo objDustattributeSo2ornoxVo = new TMisMonitorDustattributeSo2ornoxVo();
                    objDustattributeSo2ornoxVo.BASEINFOR_ID = objDustinforVo.ID;
                    dtInfo = new TMisMonitorDustattributeSo2ornoxLogic().SelectByTable(objDustattributeSo2ornoxVo);
                    if (dtInfo.Rows.Count > 0)
                    {
                        drInfo = dtInfo.Select("FITER_CODE<>'平均'");
                    }
                    else
                    {
                        TMisMonitorDustattributePmVo DustattributePmVo = new TMisMonitorDustattributePmVo();
                        DustattributePmVo.BASEINFOR_ID = objDustinforVo.ID;
                        dtInfo = new TMisMonitorDustattributePmLogic().SelectByTable(DustattributePmVo);
                        if (dtInfo.Rows.Count > 0)
                        {
                            drInfo = dtInfo.Select("FITER_CODE<>'平均'");
                        }
                    }
                }
                for (int j = 0; j < drInfo.Length; j++)
                {
                    strFiter_Code += drInfo[j]["FITER_CODE"].ToString() + ",";
                }
                dt.Rows[i]["REMARK_2"] = strFiter_Code.TrimEnd(',');
            }
        }

        int    intTotalCount = new TMisMonitorResultLogic().getItemInfoCountInAlloction_QHD(strThreeGridId, "'01','00'", "0", "", "");
        string strJson       = CreateToJson(dt, intTotalCount);

        return(strJson);
    }
 /// <summary>
 /// 根据对象特征获取单一对象
 /// </summary>
 /// <param name="tMisMonitorDustattribute">对象</param>
 /// <returns></returns>
 public TMisMonitorDustattributeVo SelectByObject(TMisMonitorDustattributeVo tMisMonitorDustattribute)
 {
     return(access.SelectByObject(tMisMonitorDustattribute));
 }