/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorDustattributePm">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorDustattributePm, TMisMonitorDustattributePmVo.T_MIS_MONITOR_DUSTATTRIBUTE_PM_TABLE);
strSQL += string.Format(" where ID='{0}' ", tMisMonitorDustattributePm.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisMonitorDustattributePmVo tMisMonitorDustattributePm, int iIndex, int iCount)
{
string strSQL = " select * from T_MIS_MONITOR_DUSTATTRIBUTE_PM {0} order by id";
strSQL = String.Format(strSQL, BuildWhereStatement(tMisMonitorDustattributePm));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorDustattributePm_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisMonitorDustattributePm_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorDustattributePmVo tMisMonitorDustattributePm_UpdateSet, TMisMonitorDustattributePmVo tMisMonitorDustattributePm_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorDustattributePm_UpdateSet, TMisMonitorDustattributePmVo.T_MIS_MONITOR_DUSTATTRIBUTE_PM_TABLE);
strSQL += this.BuildWhereStatement(tMisMonitorDustattributePm_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
string strSQL = "delete from T_MIS_MONITOR_DUSTATTRIBUTE_PM ";
strSQL += this.BuildWhereStatement(tMisMonitorDustattributePm);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 创建原因：根据原始记录表基本数据ID获取当前项目的属性表数据信息
/// 创建人：胡方扬
/// 创建日期：2013-07-09
/// </summary>
/// <returns></returns>
public string getAttInfor()
{
string result = "";
if (!String.IsNullOrEmpty(strBaseInfor_Id))
{
TMisMonitorDustattributePmVo objDustAtt = new TMisMonitorDustattributePmVo();
objDustAtt.BASEINFOR_ID = strBaseInfor_Id;
objDustAtt.SORT_FIELD = "ID";
objDustAtt.SORT_TYPE = "";
DataTable objDt = new TMisMonitorDustattributePmLogic().SelectByTable(objDustAtt, intPageIndex, intPageSize);
int CountNum = new TMisMonitorDustattributePmLogic().GetSelectResultCount(objDustAtt);
result = LigerGridDataToJson(objDt, CountNum);
}
return(result);
}
/// <summary>
/// 创建原因：根据指定监测项目属性ID 更新指定列的数据
/// 创建人：胡方扬
/// 创建时间：2013-07-09
/// </summary>
/// <returns></returns>
public bool UpdateAttValue()
{
bool blFlag = false;
if (!String.IsNullOrEmpty(strAttInfor_Id) && !String.IsNullOrEmpty(strUpdateCell))
{
blFlag = new TMisMonitorDustattributePmLogic().UpdateCell(strAttInfor_Id, strUpdateCell, strUpdateCellValue);
if (blFlag)
{
if (strUpdateCell == "SAMPLE_FWEIGHT" || strUpdateCell == "SAMPLE_EWEIGHT")
{
//样品重量=初重-终重
Regex r = new Regex("^\\d+(\\.)?\\d*$");
TMisMonitorDustattributePmVo DustattributePmVo = new TMisMonitorDustattributePmVo();
DustattributePmVo = new TMisMonitorDustattributePmLogic().Details(strAttInfor_Id);
decimal dSAMPLE_FWEIGHT = r.IsMatch(DustattributePmVo.SAMPLE_FWEIGHT) ? decimal.Parse(DustattributePmVo.SAMPLE_FWEIGHT) : 0;
decimal dSAMPLE_EWEIGHT = r.IsMatch(DustattributePmVo.SAMPLE_EWEIGHT) ? decimal.Parse(DustattributePmVo.SAMPLE_EWEIGHT) : 0;
decimal dSAMPLE_WEIGHT = Math.Abs(dSAMPLE_EWEIGHT - dSAMPLE_FWEIGHT);
blFlag = new TMisMonitorDustattributePmLogic().UpdateCell(strAttInfor_Id, "SAMPLE_WEIGHT", dSAMPLE_WEIGHT.ToString());
if (blFlag)
{
//样品浓度=样品重量/标况体积
decimal dL_STAND = r.IsMatch(DustattributePmVo.L_STAND) ? decimal.Parse(DustattributePmVo.L_STAND) : 0;
if (dL_STAND != 0)
{
blFlag = new TMisMonitorDustattributePmLogic().UpdateCell(strAttInfor_Id, "SAMPLE_CONCENT", Math.Round((dSAMPLE_WEIGHT / dL_STAND) * 1000000, 0).ToString());
}
}
}
if (strUpdateCell == "SAMPLE_WEIGHT")
{
//样品浓度=样品重量/标况体积
Regex r = new Regex("^\\d+(\\.)?\\d*$");
TMisMonitorDustattributePmVo DustattributePmVo = new TMisMonitorDustattributePmVo();
DustattributePmVo = new TMisMonitorDustattributePmLogic().Details(strAttInfor_Id);
decimal dL_STAND = r.IsMatch(DustattributePmVo.L_STAND) ? decimal.Parse(DustattributePmVo.L_STAND) : 0;
decimal dSAMPLE_WEIGHT = r.IsMatch(DustattributePmVo.SAMPLE_WEIGHT) ? decimal.Parse(DustattributePmVo.SAMPLE_WEIGHT) : 0;
if (dL_STAND != 0)
{
blFlag = new TMisMonitorDustattributePmLogic().UpdateCell(strAttInfor_Id, "SAMPLE_CONCENT", Math.Round((dSAMPLE_WEIGHT / dL_STAND) * 1000000, 0).ToString());
}
}
}
}
return(blFlag);
}
/// <summary>
/// 创建原因：根据监测项目基础属性ID，创建初始化属性数据信息
/// 创建人：胡方扬
/// 创建时间：2013-07-09
/// </summary>
/// <returns></returns>
public string SaveAttInfor()
{
string result = "";
if (!String.IsNullOrEmpty(strBaseInfor_Id))
{
TMisMonitorDustattributePmVo objDustAtt = new TMisMonitorDustattributePmVo();
objDustAtt.BASEINFOR_ID = strBaseInfor_Id;
objDustAtt.SAMPLE_CODE = (GetDustyCoutForBaseInfor() + 1).ToString();
objDustAtt.ID = GetSerialNumber("t_mis_dutyAttPMInforID");
if (new TMisMonitorDustattributePmLogic().Create(objDustAtt))
{
result = objDustAtt.ID;
}
}
return(result);
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象条件</param>
/// <returns>对象</returns>
public TMisMonitorDustattributePmVo Details(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
return(access.Details(tMisMonitorDustattributePm));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
return(access.GetSelectResultCount(tMisMonitorDustattributePm));
}
public TMisMonitorDustattributePmLogic(TMisMonitorDustattributePmVo _tMisMonitorDustattributePm)
{
tMisMonitorDustattributePm = _tMisMonitorDustattributePm;
access = new TMisMonitorDustattributePmAccess();
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
return(access.Delete(tMisMonitorDustattributePm));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorDustattributePm_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisMonitorDustattributePm_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorDustattributePmVo tMisMonitorDustattributePm_UpdateSet, TMisMonitorDustattributePmVo tMisMonitorDustattributePm_UpdateWhere)
{
return(access.Edit(tMisMonitorDustattributePm_UpdateSet, tMisMonitorDustattributePm_UpdateWhere));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorDustattributePm">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
return(access.Edit(tMisMonitorDustattributePm));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisMonitorDustattributePmVo> SelectByObject(TMisMonitorDustattributePmVo tMisMonitorDustattributePm, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_MIS_MONITOR_DUSTATTRIBUTE_PM " + this.BuildWhereStatement(tMisMonitorDustattributePm));
return(SqlHelper.ExecuteObjectList(tMisMonitorDustattributePm, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tMisMonitorDustattributePm"></param>
/// <returns></returns>
public string BuildWhereStatement(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tMisMonitorDustattributePm)
{
//
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisMonitorDustattributePm.ID.ToString()));
}
//
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.BASEINFOR_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND BASEINFOR_ID = '{0}'", tMisMonitorDustattributePm.BASEINFOR_ID.ToString()));
}
//采样序号
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_CODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_CODE = '{0}'", tMisMonitorDustattributePm.SAMPLE_CODE.ToString()));
}
//滤筒编号
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.FITER_CODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND FITER_CODE = '{0}'", tMisMonitorDustattributePm.FITER_CODE.ToString()));
}
//采样开始日期
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_BEGINDATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_BEGINDATE = '{0}'", tMisMonitorDustattributePm.SAMPLE_BEGINDATE.ToString()));
}
//采样结束日期
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_ENDDATE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_ENDDATE = '{0}'", tMisMonitorDustattributePm.SAMPLE_ENDDATE.ToString()));
}
//采样累计时间
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.ACCTIME.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ACCTIME = '{0}'", tMisMonitorDustattributePm.ACCTIME.ToString()));
}
//采样体积
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_L_STAND.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_L_STAND = '{0}'", tMisMonitorDustattributePm.SAMPLE_L_STAND.ToString()));
}
//标况采样体积
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.L_STAND.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND L_STAND = '{0}'", tMisMonitorDustattributePm.L_STAND.ToString()));
}
//标态流量
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.NM_SPEED.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND NM_SPEED = '{0}'", tMisMonitorDustattributePm.NM_SPEED.ToString()));
}
//新品初重
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_FWEIGHT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_FWEIGHT = '{0}'", tMisMonitorDustattributePm.SAMPLE_FWEIGHT.ToString()));
}
//样品终重
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_EWEIGHT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_EWEIGHT = '{0}'", tMisMonitorDustattributePm.SAMPLE_EWEIGHT.ToString()));
}
//样品重量
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_WEIGHT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_WEIGHT = '{0}'", tMisMonitorDustattributePm.SAMPLE_WEIGHT.ToString()));
}
//样品浓度
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_CONCENT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_CONCENT = '{0}'", tMisMonitorDustattributePm.SAMPLE_CONCENT.ToString()));
}
//采样地点
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_POINT.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_POINT = '{0}'", tMisMonitorDustattributePm.SAMPLE_POINT.ToString()));
}
//采样介质编号
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.SAMPLE_MEDCODE.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND SAMPLE_MEDCODE = '{0}'", tMisMonitorDustattributePm.SAMPLE_MEDCODE.ToString()));
}
//废气排放量
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.FQPFL.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND FQPFL = '{0}'", tMisMonitorDustattributePm.FQPFL.ToString()));
}
//
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisMonitorDustattributePm.REMARK1.ToString()));
}
//
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisMonitorDustattributePm.REMARK2.ToString()));
}
//
if (!String.IsNullOrEmpty(tMisMonitorDustattributePm.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisMonitorDustattributePm.REMARK3.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisMonitorDustattributePm"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
return(access.SelectByTable(tMisMonitorDustattributePm));
}
/// <summary>
/// 创建原因：计算原始记录表的平均数据
/// 创建人：魏林
/// 创建时间：2014-04-16
/// </summary>
/// <returns></returns>
public string AvgAttInfor()
{
Regex r = new Regex("^\\d+(\\.)?\\d*$");
bool iSuccess = true;
decimal SAMPLE_CONCENT = 0;
decimal FQPFL = 0;
int iPRECISION = 0;
if (!String.IsNullOrEmpty(strBaseInfor_Id))
{
TMisMonitorDustattributePmVo objDustAtt = new TMisMonitorDustattributePmVo();
objDustAtt.BASEINFOR_ID = strBaseInfor_Id;
objDustAtt.SORT_FIELD = "ID";
DataTable dt = new TMisMonitorDustattributePmLogic().SelectByTable(objDustAtt);
if (dt.Rows.Count > 0)
{
iPRECISION = dt.Rows[0]["SAMPLE_CONCENT"].ToString().Contains('.') ? dt.Rows[0]["SAMPLE_CONCENT"].ToString().Split('.')[1].Length : 0;
}
if (dt.Rows[dt.Rows.Count - 1]["FITER_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]["SAMPLE_CONCENT"].ToString()))
{
SAMPLE_CONCENT += decimal.Parse(dt.Rows[i]["SAMPLE_CONCENT"].ToString());
}
else
{
SAMPLE_CONCENT += GetNumber(dt.Rows[i]["SAMPLE_CONCENT"].ToString()) / 2;
}
FQPFL += r.IsMatch(dt.Rows[i]["FQPFL"].ToString()) ? decimal.Parse(dt.Rows[i]["FQPFL"].ToString()) : GetNumber(dt.Rows[i]["FQPFL"].ToString());
}
objDustAtt.SAMPLE_CONCENT = Math.Round(SAMPLE_CONCENT / (dt.Rows.Count - 1), iPRECISION).ToString();
objDustAtt.FQPFL = Math.Round(FQPFL / (dt.Rows.Count - 1), 0).ToString();
iSuccess = new TMisMonitorDustattributePmLogic().Edit(objDustAtt);
}
else
{
objDustAtt.SORT_FIELD = "";
objDustAtt.ID = GetSerialNumber("t_mis_dutyAttPMInforID");
objDustAtt.FITER_CODE = "平均";
for (int i = 0; i < dt.Rows.Count; i++)
{
if (r.IsMatch(dt.Rows[i]["SAMPLE_CONCENT"].ToString()))
{
SAMPLE_CONCENT += decimal.Parse(dt.Rows[i]["SAMPLE_CONCENT"].ToString());
}
else
{
SAMPLE_CONCENT += GetNumber(dt.Rows[i]["SAMPLE_CONCENT"].ToString()) / 2;
}
FQPFL += r.IsMatch(dt.Rows[i]["FQPFL"].ToString()) ? decimal.Parse(dt.Rows[i]["FQPFL"].ToString()) : GetNumber(dt.Rows[i]["FQPFL"].ToString());
}
objDustAtt.SAMPLE_CONCENT = Math.Round(SAMPLE_CONCENT / dt.Rows.Count, iPRECISION).ToString();
objDustAtt.FQPFL = Math.Round(FQPFL / dt.Rows.Count, 0).ToString();
iSuccess = new TMisMonitorDustattributePmLogic().Create(objDustAtt);
}
//更新结果表
TMisMonitorDustinforVo objDustinforVo = new TMisMonitorDustinforLogic().Details(strBaseInfor_Id);
TMisMonitorResultVo objResultVo = new TMisMonitorResultLogic().Details(objDustinforVo.SUBTASK_ID);
objResultVo.ITEM_RESULT = objDustAtt.SAMPLE_CONCENT;
iSuccess = new TMisMonitorResultLogic().Edit(objResultVo);
}
return(iSuccess ? "1" : "0");
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisMonitorDustattributePm"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
string strSQL = "select * from T_MIS_MONITOR_DUSTATTRIBUTE_PM " + this.BuildWhereStatement(tMisMonitorDustattributePm) + " order by id";
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
string strSQL = "select Count(*) from T_MIS_MONITOR_DUSTATTRIBUTE_PM " + this.BuildWhereStatement(tMisMonitorDustattributePm);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisMonitorDustattributePmVo> SelectByObject(TMisMonitorDustattributePmVo tMisMonitorDustattributePm, int iIndex, int iCount)
{
return(access.SelectByObject(tMisMonitorDustattributePm, iIndex, iCount));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
return(access.Create(tMisMonitorDustattributePm));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisMonitorDustattributePmVo tMisMonitorDustattributePm, int iIndex, int iCount)
{
return(access.SelectByTable(tMisMonitorDustattributePm, iIndex, iCount));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象条件</param>
/// <returns>对象</returns>
public TMisMonitorDustattributePmVo Details(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
string strSQL = String.Format("select * from T_MIS_MONITOR_DUSTATTRIBUTE_PM " + this.BuildWhereStatement(tMisMonitorDustattributePm));
return(SqlHelper.ExecuteObject(new TMisMonitorDustattributePmVo(), strSQL));
}
/// <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);
}
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>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象</param>
/// <returns></returns>
public TMisMonitorDustattributePmVo SelectByObject(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
return(access.SelectByObject(tMisMonitorDustattributePm));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="tMisMonitorDustattributePm">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisMonitorDustattributePmVo tMisMonitorDustattributePm)
{
string strSQL = SqlHelper.BuildInsertExpress(tMisMonitorDustattributePm, TMisMonitorDustattributePmVo.T_MIS_MONITOR_DUSTATTRIBUTE_PM_TABLE);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
