/// <summary>
/// 获取样品信息
/// </summary>
/// <returns></returns>
private string getSampleGridInfo(string strTaskID, string strSubTaskID)
{
//huangjinjun add 2016.1.26 如果REMARK3等于true，将ph值、电导率、溶解氧设为分析项目
TMisMonitorTaskVo tm = new TMisMonitorTaskVo();
TMisMonitorSubtaskVo tmsub = new TMisMonitorSubtaskVo();
tmsub = new TMisMonitorSubtaskLogic().Details(strSubTaskID);
tm.ID = tmsub.TASK_ID;
DataTable dtRemark = new TMisMonitorTaskLogic().SelectByTable(tm);
if (dtRemark.Rows[0]["REMARK3"].ToString() == "true")
{
bool bl = new TBaseItemInfoLogic().EditItemTypeFX();
}
else
{
bool bl = new TBaseItemInfoLogic().EditItemTypeXC();
}
var strCCflowWorkId = Request.QueryString["strCCflowWorkId"];
var identification = CCFlowFacade.GetFlowIdentification(LogInfo.UserInfo.USER_NAME, Convert.ToInt64(strCCflowWorkId));
var sampleIdList = identification.Split(new string[] { "|" }, StringSplitOptions.RemoveEmptyEntries).ToList();
if (sampleIdList.Count > 0)
{
sampleIdList.RemoveAt(0);
}
if (sampleIdList.Count == 0)
{
DataTable dt = new TMisMonitorResultLogic().getSampleCodeInAlloction_MAS(strTaskID, strSubTaskID);
string strJson = CreateToJson(dt, 0);
return(strJson);
}
else
{
DataTable dt = new TMisMonitorResultLogic().getSampleCodeInAlloction_MAS(strTaskID, strSubTaskID);
var newDT = new DataTable();
foreach (DataColumn column in dt.Columns)
{
newDT.Columns.Add(column.ColumnName);
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (!sampleIdList.Contains(dt.Rows[i]["ID"].ToString()))
{
continue;
}
newDT.Rows.Add(dt.Rows[i].ItemArray);
}
string strJson = CreateToJson(newDT, 0);
return(strJson);
}
}
public static string EditItem(string strItemID, string strCharge, string strPowerFee, string strPreFree, string strTestAnsyFree, string strTestPointNum, string strAnsyNum)
{
bool isSuccess = true;
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.ID = strItemID;
objItem.CHARGE = strCharge;
objItem.TEST_POWER_FEE = strPowerFee;
objItem.PRETREATMENT_FEE = strPreFree;
objItem.TEST_ANSY_FEE = strTestAnsyFree;
objItem.TEST_POINT_NUM = strTestPointNum;
objItem.ANALYSE_NUM = strAnsyNum;
isSuccess = new TBaseItemInfoLogic().Edit(objItem);
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
//获取监测项目
private void GetItem()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
string strSrhMONITOR_ID = (Request.Params["SrhMONITOR_ID"] != null) ? Request.Params["SrhMONITOR_ID"] : "";
string strSrhITEM_NAME = (Request.Params["SrhITEM_NAME"] != null) ? Request.Params["SrhITEM_NAME"] : "";
if (strSortname == null || strSortname.Length == 0)
{
strSortname = TBaseItemInfoVo.MONITOR_ID_FIELD + "," + TBaseItemInfoVo.ORDER_NUM_FIELD;
}
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.IS_DEL = "0";
objItem.HAS_SUB_ITEM = "0";//监测项目管理默认直接子项目。说明，父项目，在用户界面以项目包形式存在，不属于项目范畴；子项目、项目包，在数据库存一个表，对用户应该是两个概念。
objItem.IS_SUB = "1";
objItem.MONITOR_ID = strSrhMONITOR_ID;
objItem.ITEM_NAME = strSrhITEM_NAME;
objItem.SORT_FIELD = strSortname;
objItem.SORT_TYPE = strSortorder;
TBaseItemInfoLogic logicItem = new TBaseItemInfoLogic();
int intTotalCount = logicItem.GetSelectResultCount(objItem);;//总计的数据条数
DataTable dt = logicItem.SelectByTable_ByJoinMonitorType(objItem, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
}
/// <summary>
/// 获取任务信息
/// </summary>
/// <returns></returns>
private string getOneGridInfo(string strSample)
{
string strSubTaskID = Request["strSubTaskID"].ToString();
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 TMisMonitorTaskLogic().SelectSampleTaskForMAS(strSubTaskID, strSample == "1" ? true : false, intPageIndex, intPageSize);
//huangjinjun add 2016.1.26
TMisMonitorTaskVo tm = new TMisMonitorTaskLogic().Details(dt.Rows[0]["ID"].ToString());
if (tm.REMARK3 == "true")
{
bool bl = new TBaseItemInfoLogic().EditItemTypeFX();
}
else
{
bool bl = new TBaseItemInfoLogic().EditItemTypeXC();
}
int intTotalCount = new TMisMonitorTaskLogic().SelectSampleTaskCountForMAS(strSubTaskID, strSample == "1" ? true : false);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
public static string deleteItemBag(string strDelIDs)
{
if (strDelIDs.Length == 0)
{
return("0");
}
string[] arrDelIDs = strDelIDs.Split(',');
bool isSuccess = true;
for (int i = 0; i < arrDelIDs.Length; i++)
{
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.ID = arrDelIDs[i];
objItem.IS_DEL = "1";
isSuccess = new TBaseItemInfoLogic().Edit(objItem);
TBaseItemSubItemVo objSubItemSet = new TBaseItemSubItemVo();
objSubItemSet.IS_DEL = "1";
TBaseItemSubItemVo objSubItemWhere = new TBaseItemSubItemVo();
objSubItemWhere.PARENT_ITEM_ID = arrDelIDs[i];
new TBaseItemSubItemLogic().Edit(objSubItemSet, objSubItemWhere);
}
if (isSuccess)
{
new PageBase().WriteLog("删除项目包", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除项目包" + arrDelIDs[0].ToString() + "成功");
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 获取监测点信息
/// </summary>
/// <returns></returns>
private string getOneGridInfo(string strTaskID, string strSubTaskID)
{
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().getTaskInfo_MAS(strTaskID, strSubTaskID, intPageIndex, intPageSize);
//huangjinjun add 2016.1.26 如果REMARK3等于true，将ph值、电导率、溶解氧设为分析项目
if (dt.Rows[0]["REMARK3"].ToString() == "true")
{
bool bl = new TBaseItemInfoLogic().EditItemTypeFX();
}
else
{
bool bl = new TBaseItemInfoLogic().EditItemTypeXC();
}
int intTotalCount = new TMisMonitorResultLogic().getTaskInfoCount_MAS(strTaskID, strSubTaskID);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
public static string EditItem(string strID, string strITEM_NAME, string strLAB_CERTIFICATE, string strMEASURE_CERTIFICATE, string strORDER_NUM, string strITEM_NUM, string strIS_SAMPLEDEPT, string strIS_ANYSCENE, string strORI_CATALOG_TABLEID)
{
bool isSuccess = true;
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.ID = strID;
objItem.ITEM_NAME = strITEM_NAME;
objItem.LAB_CERTIFICATE = strLAB_CERTIFICATE;
objItem.MEASURE_CERTIFICATE = strMEASURE_CERTIFICATE;
objItem.ORDER_NUM = strORDER_NUM.PadLeft(8, '0');
objItem.ITEM_NUM = strITEM_NUM;
objItem.IS_SAMPLEDEPT = strIS_SAMPLEDEPT;
objItem.IS_ANYSCENE_ITEM = strIS_ANYSCENE;
objItem.ORI_CATALOG_TABLEID = strORI_CATALOG_TABLEID;
isSuccess = new TBaseItemInfoLogic().Edit(objItem);
if (isSuccess)
{
new PageBase().WriteLog("修改项目", "", new PageBase().LogInfo.UserInfo.USER_NAME + "修改项目" + objItem.ID + "成功");
return("1");
}
else
{
return("0");
}
}
public static string AddItem(string strMONITOR_ID, string strITEM_NAME, string strLAB_CERTIFICATE, string strMEASURE_CERTIFICATE, string strORDER_NUM, string strITEM_NUM, string strIS_SAMPLEDEPT, string strIS_ANYSCENE, string strORI_CATALOG_TABLEID)
{
bool isSuccess = true;
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.ID = GetSerialNumber("t_base_item_info_id");
objItem.IS_DEL = "0";
objItem.HAS_SUB_ITEM = "0";//监测项目管理默认直接子项目。说明，父项目，在用户界面以项目包形式存在，不属于项目范畴；子项目、项目包，在数据库存一个表，对用户应该是两个概念。
objItem.IS_SUB = "1";
objItem.MONITOR_ID = strMONITOR_ID;
objItem.ITEM_NAME = strITEM_NAME;
objItem.LAB_CERTIFICATE = strLAB_CERTIFICATE;
objItem.MEASURE_CERTIFICATE = strMEASURE_CERTIFICATE;
objItem.ORDER_NUM = strORDER_NUM.PadLeft(8, '0');
objItem.ITEM_NUM = strITEM_NUM;
objItem.IS_SAMPLEDEPT = strIS_SAMPLEDEPT;
objItem.IS_ANYSCENE_ITEM = strIS_ANYSCENE;
objItem.ORI_CATALOG_TABLEID = strORI_CATALOG_TABLEID;
isSuccess = new TBaseItemInfoLogic().Create(objItem);
if (isSuccess)
{
new PageBase().WriteLog("新增项目", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增项目" + objItem.ID + "成功");
return("1");
}
else
{
return("0");
}
}
protected void BindList()
{
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.IS_DEL = "0";
List <TBaseItemInfoVo> lstItem = new TBaseItemInfoLogic().SelectByObject(objItem, 0, 0);
lstItem.Sort(delegate(TBaseItemInfoVo a, TBaseItemInfoVo b) {
if (a.MONITOR_ID.CompareTo(b.MONITOR_ID) == 0)
{
return(a.ORDER_NUM.CompareTo(b.ORDER_NUM));
}
else
{
return(a.MONITOR_ID.CompareTo(b.MONITOR_ID));
}
});
for (int i = 0; i < lstItem.Count; i++)
{
lstItem[i].ITEM_NAME = new TBaseMonitorTypeInfoLogic().Details(lstItem[i].MONITOR_ID).MONITOR_TYPE_NAME + "—" + lstItem[i].ITEM_NAME;
}
this.ListBox1.DataSource = lstItem;
this.ListBox1.DataValueField = TBaseItemInfoVo.ID_FIELD;
this.ListBox1.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD;
this.ListBox1.DataBind();
TBaseIndustryItemVo objIndustryItem = new TBaseIndustryItemVo();
objIndustryItem.INDUSTRY_ID = this.Request["IndustryID"].ToString();
List <TBaseIndustryItemVo> lstIndustryItem = new TBaseIndustryItemLogic().SelectByObject(objIndustryItem, 0, 0);
string strIndustryItemIDs = "";
for (int i = 0; i < lstIndustryItem.Count; i++)
{
strIndustryItemIDs += "," + lstIndustryItem[i].ITEM_ID;
}
strIndustryItemIDs += ",";
for (int i = lstItem.Count - 1; i >= 0; i--)
{
if (!strIndustryItemIDs.Contains(lstItem[i].ID))
{
lstItem.RemoveAt(i);
}
}
this.ListBox2.DataSource = lstItem;
this.ListBox2.DataValueField = TBaseItemInfoVo.ID_FIELD;
this.ListBox2.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD;
this.ListBox2.DataBind();
for (int i = 0; i < ListBox2.Items.Count; i++)
{
ListItem item = ListBox2.Items[i];
ListBox1.Items.Remove(item);
}
}
public static string AddItemBag(string strMONITOR_ID, string strITEM_NAME)
{
bool isSuccess = true;
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.ID = GetSerialNumber("t_base_item_info_id");
objItem.IS_DEL = "0";
objItem.HAS_SUB_ITEM = "1";//监测项目管理默认直接子项目。说明，父项目，在用户界面以项目包形式存在，不属于项目范畴；子项目、项目包，在数据库存一个表，对用户应该是两个概念。
objItem.IS_SUB = "0";
objItem.MONITOR_ID = strMONITOR_ID;
objItem.ITEM_NAME = strITEM_NAME;
isSuccess = new TBaseItemInfoLogic().Create(objItem);
if (isSuccess)
{
new PageBase().WriteLog("新增项目包", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增项目包" + objItem.ID + "成功");
return("1");
}
else
{
return("0");
}
}
public static List <object> GetMonitorItems(string strMonitor, string strUserId)
{
List <object> reslut = new List <object>();
DataTable dtSt = new DataTable();
TBaseItemInfoVo objtd = new TBaseItemInfoVo();
objtd.IS_DEL = "0";
objtd.MONITOR_ID = strMonitor;
dtSt = new TBaseItemInfoLogic().SelectByTable(objtd);
DataTable dtnew = new DataTable();
dtnew = new TSysUserDutyLogic().GetExistMonitor(strMonitor, strUserId, false, false);
for (int i = 0; i < dtnew.Rows.Count; i++)
{
DataRow[] drr = dtSt.Select("ID='" + dtnew.Rows[i]["ITEM_ID"] + "'");
if (drr.Length > 0)
{
foreach (DataRow drow in drr)
{
drow.Delete();
}
}
}
dtSt.AcceptChanges();
reslut = LigerGridSelectDataToJson(dtSt, dtSt.Rows.Count);
return(reslut);
}
/// <summary>
/// 创建原因：获取监测项目要用到的原始记录表的表名称和表ID
/// 创建人：胡方扬
/// 创意日期：2013-08-29
/// </summary>
/// <param name="strWhere"></param>
/// <returns></returns>
public string GetDefineTable(string strWhere)
{
string result = "";
DataTable dt = new TBaseItemInfoLogic().GetSysDutyCataLogTableInfor(strWhere);
result = LigerGridDataToJson(dt, dt.Rows.Count);
return(result);
}
public static bool QcUpdate(string strID, string strUpdateCell, string strUpdateCellValue)
{
bool isSuccess = true;
isSuccess = new TBaseItemInfoLogic().UpdateQcInfo("T_MIS_MONITOR_QC_ADD", strUpdateCell, strUpdateCellValue, strID);
return(isSuccess);
}
/// <summary>
/// 获取监测项目信息
/// </summary>
/// <param name="strValue">ID</param>
/// <returns></returns>
public string getBaseItemInfor( )
{
DataTable objDt = new TBaseItemInfoLogic().SelectByTable(new TBaseItemInfoVo {
ID = strItemId
});
return(LigerGridDataToJson(objDt, objDt.Rows.Count));
}
/// <summary>
/// 获取监测点信息
/// </summary>
/// <returns></returns>
private string getOneGridInfo()
{
DataTable objTable = new TBaseItemInfoLogic().SelectQcAddItem(this.txtSampleId.Value.Trim(), this.txtQcType.Value.Trim());
int intTotalCount = objTable.Rows.Count;
string strJson = CreateToJson(objTable, intTotalCount);
return(strJson);
}
public static List <object> GetSampleItem(string strSampleID, string strQcType)
{
List <object> listResult = new List <object>();
DataTable dt = new DataTable();
dt = new TBaseItemInfoLogic().SelectItemForQC(strSampleID, strQcType);
listResult = LigerGridSelectDataToJson(dt, dt.Rows.Count);
return(listResult);
}
public static string setDefaultSamplingInstrumentInfo(string ITEM_ID, string strValue)
{
bool isSuccess = new TBaseItemInfoLogic().setItemSamplingInstrumentDefault(ITEM_ID, strValue);
if (isSuccess)
{
new PageBase().WriteLog("设置默认采样仪器", "", new PageBase().LogInfo.UserInfo.USER_NAME + "设置默认采样仪器");
}
return(isSuccess == true ? "1" : "0");
}
protected void BindList()
{
string strMonitorID = new TBaseItemInfoLogic().Details(this.Request["selBagID"].ToString()).MONITOR_ID;
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.IS_DEL = "0";
objItem.IS_SUB = "1";
objItem.HAS_SUB_ITEM = "0";
objItem.MONITOR_ID = strMonitorID;
List <TBaseItemInfoVo> lstItem = new TBaseItemInfoLogic().SelectByObject(objItem, 0, 0);
lstItem.Sort(delegate(TBaseItemInfoVo a, TBaseItemInfoVo b) { return(a.ORDER_NUM.CompareTo(b.ORDER_NUM)); });
this.ListBox1.DataSource = lstItem;
this.ListBox1.DataValueField = TBaseItemInfoVo.ID_FIELD;
this.ListBox1.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD;
this.ListBox1.DataBind();
TBaseItemSubItemVo objSubItem = new TBaseItemSubItemVo();
objSubItem.IS_DEL = "0";
objSubItem.PARENT_ITEM_ID = this.Request["selBagID"].ToString();
List <TBaseItemSubItemVo> lstSubItem = new TBaseItemSubItemLogic().SelectByObject(objSubItem, 0, 0);
string strSubItemIDs = "";
for (int i = 0; i < lstSubItem.Count; i++)
{
strSubItemIDs += "," + lstSubItem[i].ITEM_ID;
}
strSubItemIDs = strSubItemIDs + ",";
for (int i = lstItem.Count - 1; i >= 0; i--)
{
if (!strSubItemIDs.Contains(lstItem[i].ID))
{
lstItem.RemoveAt(i);
}
}
this.ListBox2.DataSource = lstItem;
this.ListBox2.DataValueField = TBaseItemInfoVo.ID_FIELD;
this.ListBox2.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD;
this.ListBox2.DataBind();
for (int i = 0; i < ListBox2.Items.Count; i++)
{
ListItem item = ListBox2.Items[i];
ListBox1.Items.Remove(item);
}
}
/// <summary>
/// 退回监测项目
/// </summary>
/// <param name="strResultId">结果ID</param>
/// <returns></returns>
public string GoToBack(string strResultIds, string strSuggestion)
{
bool isSuccess = true;
string[] strResultId = strResultIds.Split(',');
for (int i = 0; i < strResultId.Length; i++)
{
TBaseItemInfoVo BaseItemInfoVo = new TBaseItemInfoVo();
BaseItemInfoVo = new TBaseItemInfoLogic().Details(new TMisMonitorResultLogic().Details(strResultId[i].ToString()).ITEM_ID);
TMisMonitorResultVo TMisMonitorResultVo = new TMisMonitorResultVo();
TMisMonitorResultVo.ID = strResultId[i].ToString();
TMisMonitorResultVo.TASK_TYPE = "退回";
if (BaseItemInfoVo.IS_ANYSCENE_ITEM == "1") //分析类现场监测项目 退回到：00
{
TMisMonitorResultVo.RESULT_STATUS = "00";
}
else
{
TMisMonitorResultVo.RESULT_STATUS = "01"; //分析类监测项目 退回到：01
}
isSuccess = new TMisMonitorResultLogic().Edit(TMisMonitorResultVo);
TMisMonitorResultVo = new TMisMonitorResultLogic().Details(strResultId[i].ToString());
TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(TMisMonitorResultVo.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 = strResultId[i].ToString();
objReturnInfoVo.CURRENT_STATUS = SerialType.Monitor_007;
objReturnInfoVo.BACKTO_STATUS = SerialType.Monitor_006;
TMisReturnInfoVo obj = new TMisReturnInfoLogic().Details(objReturnInfoVo);
if (obj.ID.Length > 0)
{
objReturnInfoVo.ID = obj.ID;
objReturnInfoVo.SUGGESTION = strSuggestion;
isSuccess = new TMisReturnInfoLogic().Edit(objReturnInfoVo);
}
else
{
objReturnInfoVo.ID = GetSerialNumber("t_mis_return_id");
objReturnInfoVo.SUGGESTION = strSuggestion;
isSuccess = new TMisReturnInfoLogic().Create(objReturnInfoVo);
}
}
return(isSuccess == true ? "1" : "0");
}
public static List <object> GetMonitorSubItems(string strStandId, string strCondtionId, string strMonitor)
{
List <object> reslut = new List <object>();
DataTable dtSt = new DataTable();
TBaseEvaluationConItemVo objtd = new TBaseEvaluationConItemVo();
objtd.IS_DEL = "0";
objtd.MONITOR_ID = strMonitor;
objtd.STANDARD_ID = strStandId;
objtd.CONDITION_ID = strCondtionId;
dtSt = new TBaseEvaluationConItemLogic().SelectByTable(objtd);
DataTable dt = new DataTable();
TBaseItemInfoVo objitem = new TBaseItemInfoVo();
objitem.MONITOR_ID = strMonitor;
objitem.IS_DEL = "0";
dt = new TBaseItemInfoLogic().SelectByTable(objitem);
DataTable dtItem = new DataTable();
dtItem = dt.Copy();
dtItem.Clear();
if (dtSt.Rows.Count > 0)
{
for (int i = 0; i < dtSt.Rows.Count; i++)
{
if (!String.IsNullOrEmpty(dtSt.Rows[i]["ITEM_ID"].ToString()))
{
DataRow[] dr = dt.Select("ID='" + dtSt.Rows[i]["ITEM_ID"].ToString() + "'");
if (dr != null)
{
foreach (DataRow Temrow in dr)
{
Temrow.Delete();
dt.AcceptChanges();
}
}
}
}
}
dtItem = dt.Copy();
reslut = LigerGridSelectDataToJson(dtItem, dtItem.Rows.Count);
//reslut = gridDataToJson(dtSt, dtSt.Rows.Count, objtd);
return(reslut);
}
public string GetMonitorItemsJson(string strMonitor)
{
string reslut = "";
DataTable dtSt = new DataTable();
TBaseItemInfoVo objtd = new TBaseItemInfoVo();
objtd.IS_DEL = "0";
objtd.MONITOR_ID = strMonitor;
dtSt = new TBaseItemInfoLogic().SelectByTable(objtd);
reslut = LigerGridDataToJson(dtSt, dtSt.Rows.Count);
return(reslut);
}
//项目
private void GetItem_UnderSample(string strSampleID, ref string strItems)
{
TMisMonitorResultVo objResult = new TMisMonitorResultVo();
objResult.SAMPLE_ID = strSampleID;
DataTable dt = new TMisMonitorResultLogic().SelectByTable(objResult, 0, 0);
for (int i = 0; i < dt.Rows.Count; i++)
{
TBaseItemInfoVo objItemInfo = new TBaseItemInfoLogic().Details(dt.Rows[i]["ITEM_ID"].ToString());
if (!strItems.Contains(objItemInfo.ITEM_NAME))
{
strItems += (strItems.Length > 0 ? "、" : "") + objItemInfo.ITEM_NAME;
}
}
}
//项目
private void GetItem_UnderSample(string strSampleID, string strPointName, ref string strItems)
{
TMisMonitorResultVo objResult = new TMisMonitorResultVo();
objResult.SAMPLE_ID = strSampleID;
DataTable dt = new TMisMonitorResultLogic().SelectByTable(objResult, 0, 0);
strItems += (strItems.Length > 0 ? "\n" : "") + strPointName + "：";
for (int i = 0; i < dt.Rows.Count; i++)
{
TBaseItemInfoVo objItemInfo = new TBaseItemInfoLogic().Details(dt.Rows[i]["ITEM_ID"].ToString());
strItems += objItemInfo.ITEM_NAME + "、";
}
strItems = strItems.TrimEnd('、');
}
public static bool InsertSelectedUser(string strUserId, string strItemID, string strDutyType)
{
string strDutyID = "";
string strMonitorID = new TBaseItemInfoLogic().Details(strItemID).MONITOR_ID;
TSysDutyVo objDutySrh = new TSysDutyVo();
objDutySrh.MONITOR_TYPE_ID = strMonitorID;
objDutySrh.MONITOR_ITEM_ID = strItemID;
objDutySrh.DICT_CODE = strDutyType;
DataTable dtDuty = new TSysDutyLogic().SelectByTable(objDutySrh);
if (dtDuty.Rows.Count == 0)
{
//如果不存在岗位配置，增加
objDutySrh.ID = GetSerialNumber("duty_set_infor");
if (new TSysDutyLogic().Create(objDutySrh))
{
strDutyID = objDutySrh.ID;
}
}
else
{
strDutyID = dtDuty.Rows[0]["ID"].ToString();
}
TSysUserDutyVo objUserDutySrh = new TSysUserDutyVo();
objUserDutySrh.DUTY_ID = strDutyID;
DataTable dtUserDuty = new TSysUserDutyLogic().SelectByTable(objUserDutySrh);
//删除移除的
for (int i = 0; i < dtUserDuty.Rows.Count; i++)
{
string strTmpUserID = dtUserDuty.Rows[i]["USERID"].ToString();
if (!strUserId.Contains(strTmpUserID))
{
new TSysUserDutyLogic().Delete(dtUserDuty.Rows[i]["ID"].ToString());
}
}
string[] strUerArr = strUserId.Split(';');
new TSysUserDutyLogic().InsertSelectedUser(strUerArr, strDutyID);
return(true);
}
/// <summary>
/// 生成并保存监测结论
/// </summary>
/// <param name="strTaskID">监测任务ID</param>
/// <param name="strSubTaskID">监测子任务ID</param>
/// <returns>监测子任务结论</returns>
protected string GetConclusion(string strTaskID, string strSubTaskID)
{
string strConclusion = "";
//监测点位
TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointVo();
objTaskPoint.TASK_ID = strTaskID;
objTaskPoint.SUBTASK_ID = strSubTaskID;
objTaskPoint.IS_DEL = "0";
DataTable dtTaskItem = new TMisMonitorTaskPointLogic().SelectTaskItemByPoint(objTaskPoint);
if (dtTaskItem.Rows.Count > 0)
{
string strErrItem = ""; //超标项目
string strErrItemID = ""; //超标项目ID
for (int i = 0; i < dtTaskItem.Rows.Count; i++)
{
DataRow dr = dtTaskItem.Rows[i] as DataRow;
//生成监测结论
if (dr["CONDITION_ID"].ToString().Length > 0)
{
//获得标准、依据名称
strConclusion = getStandardName(dr["CONDITION_ID"].ToString());
//记录超标项目信息
strErrItemID += !strErrItemID.Contains(dr["ITEM_ID"].ToString()) ? (IsOver(dr["ITEM_ID"].ToString(), dr["TASK_POINT_ID"].ToString()) ? dr["ITEM_ID"].ToString() : "") + "、" : "";
if (strErrItemID.Contains(dr["ITEM_ID"].ToString()))
{
string strItemName = new TBaseItemInfoLogic().Details(dr["ITEM_ID"].ToString()).ITEM_NAME;
if (!strErrItem.Contains(strItemName))
{
strErrItem += strItemName + "、";
}
}
//构造监测结论语句
if (strErrItem.Length > 0)
{
strConclusion += "本次监测该单位" + dr["POINT_NAME"].ToString() + "除" + strErrItem.Remove(strErrItem.LastIndexOf("、")) + "外，其它项目达标";
}
else
{
strConclusion += "本次监测该单位" + dr["POINT_NAME"].ToString() + "达标排放";
}
}
}
}
return(strConclusion);
}
public static List <object> GetMonitorItems(string strMonitor)
{
List <object> reslut = new List <object>();
DataTable dtSt = new DataTable();
TBaseItemInfoVo objtd = new TBaseItemInfoVo();
objtd.IS_DEL = "0";
objtd.MONITOR_ID = strMonitor;
dtSt = new TBaseItemInfoLogic().SelectByTable(objtd);
reslut = LigerGridSelectDataToJson(dtSt, dtSt.Rows.Count);
//reslut = gridDataToJson(dtSt, dtSt.Rows.Count, objtd);
return(reslut);
}
//获取监测项目，仅为下拉框 弹出grid使用
private void GetItems()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
string strSrhMONITOR_ID = (Request.Params["monitorId"] != null) ? Request.Params["monitorId"] : "";
string strSrhItemName = (Request.Params["strSrhItemName"] != null) ? Request.Params["strSrhItemName"] : "";
TBaseItemInfoLogic logicItem = new TBaseItemInfoLogic();
int intTotalCount = logicItem.GetSelectResultCount_ForSelectItem_inBag(strSrhMONITOR_ID, strSrhItemName);;//总计的数据条数
DataTable dt = logicItem.SelectByTable_ForSelectItem_inBag(strSrhMONITOR_ID, strSrhItemName, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
}
/// <summary>
/// 获取监测点信息
/// </summary>
/// <returns></returns>
private string getOneGridInfo()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
string strSourceSampleId = Request["strSampleId"];
List <object> listResult = new List <object>();
DataTable objTable = new TBaseItemInfoLogic().SelectItemForQC(strSourceSampleId, "0");
objTable.Columns.Add("QC_ADD", System.Type.GetType("System.String"));
objTable.Columns.Add("IS_CHECKED", System.Type.GetType("System.String"));
//遍历数据集
foreach (DataRow row in objTable.Rows)
{
//监测项目
string strItemId = row["ID"].ToString();
//获取加标样结果表【T_MIS_MONITOR_QC_ADD】中的家标量数据
DataTable obj = new TMisMonitorResultLogic().getQcAddValue(strSourceSampleId, Request["strQcType"], strItemId);
if (obj.Rows.Count != 0)
{
row["QC_ADD"] = obj.Rows[0]["QC_ADD"].ToString();
row["REMARK1"] = obj.Rows[0]["REMARK1"].ToString();
row["REMARK2"] = obj.Rows[0]["REMARK2"].ToString();
row["REMARK3"] = obj.Rows[0]["REMARK3"].ToString();
row["IS_CHECKED"] = "1";
}
else
{
row["IS_CHECKED"] = "0";
}
}
int intTotalCount = objTable.Rows.Count;
string strJson = CreateToJson(objTable, intTotalCount);
return(strJson);
}
public static string EditItemBag(string strID, string strITEM_NAME)
{
bool isSuccess = true;
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.ID = strID;
objItem.ITEM_NAME = strITEM_NAME;
isSuccess = new TBaseItemInfoLogic().Edit(objItem);
if (isSuccess)
{
new PageBase().WriteLog("修改项目包", "", new PageBase().LogInfo.UserInfo.USER_NAME + "修改项目包" + objItem.ID + "成功");
return("1");
}
else
{
return("0");
}
}
//获取指定项目包的监测项目，即子项目
private void GetItems()
{
string strSelItemBagID = (Request.Params["selBagID"] != null) ? Request.Params["selBagID"] : "";
if (strSelItemBagID.Length <= 0)
{
Response.Write("");
return;
}
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
TBaseItemInfoLogic logicItem = new TBaseItemInfoLogic();
int intTotalCount = logicItem.GetSelectResultCount_ItemOfBag(strSelItemBagID);;//总计的数据条数
DataTable dt = logicItem.SelectByTable_ItemOfBag(strSelItemBagID, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
}
