/// <summary> /// 创建原因:获取当前已经存在的属性样品总条数 /// 创建人:胡方扬 /// 创建日期:2013-07-09 /// </summary> /// <returns></returns> public int GetDustyCoutForBaseInfor() { int CountNum = 0; if (!String.IsNullOrEmpty(strBaseInfor_Id)) { DataTable dt = new TMisMonitorDustattributePmLogic().SelectByTable(new TMisMonitorDustattributePmVo { BASEINFOR_ID = strBaseInfor_Id }); CountNum = dt.Rows.Count; } return(CountNum); }
/// <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> /// 获取监测项目信息 /// </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> /// 创建原因:计算原始记录表的平均数据 /// 创建人:魏林 /// 创建时间: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"); }