public static string AddMehod(string strItemID, string strANALYSISID, string strAPPARATUS_ID, string strLOWER_CHECKOUT, string strUnitCode, string strPRECISION)
{
bool isSuccess = true;
TBaseItemAnalysisVo objItemAnalysisSet = new TBaseItemAnalysisVo();
objItemAnalysisSet.ID = GetSerialNumber("t_base_item_analysis_id");
objItemAnalysisSet.IS_DEL = "0";
objItemAnalysisSet.ITEM_ID = strItemID;
objItemAnalysisSet.ANALYSIS_METHOD_ID = strANALYSISID;
objItemAnalysisSet.INSTRUMENT_ID = strAPPARATUS_ID;
objItemAnalysisSet.LOWER_CHECKOUT = strLOWER_CHECKOUT;
objItemAnalysisSet.UNIT = strUnitCode;
objItemAnalysisSet.IS_DEFAULT = "否";
objItemAnalysisSet.PRECISION = strPRECISION;
isSuccess = new TBaseItemAnalysisLogic().Create(objItemAnalysisSet);
if (isSuccess)
{
new PageBase().WriteLog("添加分析方法", "", new PageBase().LogInfo.UserInfo.USER_NAME + "添加分析方法" + objItemAnalysisSet.ID + "成功");
return("1");
}
else
{
return("0");
}
}
public static string EditMehod(string strID, string strANALYSISID, string strAPPARATUS_ID, string strLOWER_CHECKOUT, string strUnitCode, string strPRECISION)
{
bool isSuccess = true;
TBaseItemAnalysisVo objItemAnalysisSet = new TBaseItemAnalysisVo();
objItemAnalysisSet.ID = strID;
objItemAnalysisSet.ANALYSIS_METHOD_ID = strANALYSISID;
objItemAnalysisSet.INSTRUMENT_ID = strAPPARATUS_ID;
objItemAnalysisSet.LOWER_CHECKOUT = strLOWER_CHECKOUT;
objItemAnalysisSet.UNIT = strUnitCode;
objItemAnalysisSet.PRECISION = strPRECISION;
isSuccess = new TBaseItemAnalysisLogic().Edit(objItemAnalysisSet);
if (isSuccess)
{
new PageBase().WriteLog("编辑分析方法", "", new PageBase().LogInfo.UserInfo.USER_NAME + "编辑分析方法" + objItemAnalysisSet.ID + "成功");
return("1");
}
else
{
return("0");
}
}
public static string delMethod(string strDelIDs)
{
if (strDelIDs.Length == 0)
{
return("0");
}
string[] arrDelIDs = strDelIDs.Split(',');
bool isSuccess = true;
for (int i = 0; i < arrDelIDs.Length; i++)
{
TBaseItemAnalysisVo objItemAnalysisSet = new TBaseItemAnalysisVo();
objItemAnalysisSet.ID = arrDelIDs[i];
objItemAnalysisSet.IS_DEL = "1";
isSuccess = new TBaseItemAnalysisLogic().Edit(objItemAnalysisSet);
}
if (isSuccess)
{
new PageBase().WriteLog("删除项目分析方法", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除项目分析方法" + strDelIDs[0].ToString() + "成功");
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseItemAnalysis">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseItemAnalysisVo tBaseItemAnalysis, int iIndex, int iCount)
{
string strSQL = " select * from T_BASE_ITEM_ANALYSIS {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tBaseItemAnalysis));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 为监测类别复制监测项目
/// </summary>
/// <param name="tBaseItemInfo"></param>
/// <returns></returns>
public bool CopySameMonitorItemInfor(TBaseItemInfoVo tBaseItemInfo, string strToId)
{
string strSQL = "";
ArrayList objArr = new ArrayList();
DataTable dt = SelectByTable(tBaseItemInfo);
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string strItemId = GetSerialNumber("t_base_item_info_id");
strSQL = string.Format(" INSERT INTO T_BASE_ITEM_INFO (ID,ITEM_NAME,MONITOR_ID,IS_SAMPLEDEPT,HAS_SUB_ITEM,IS_SUB,ITEM_NUM,ANALYSE_NUM,TEST_POINT_NUM,PRETREATMENT_FEE,TEST_ANSY_FEE,CHARGE,TEST_POWER_FEE,LAB_CERTIFICATE,MEASURE_CERTIFICATE,TWIN_VALUE,ADD_MIN,ADD_MAX,ORDER_NUM,IS_DEL) SELECT '{0}',ITEM_NAME,'{1}',IS_SAMPLEDEPT,HAS_SUB_ITEM,IS_SUB,ITEM_NUM,ANALYSE_NUM,TEST_POINT_NUM,PRETREATMENT_FEE,TEST_ANSY_FEE,CHARGE,TEST_POWER_FEE,LAB_CERTIFICATE,MEASURE_CERTIFICATE,TWIN_VALUE,ADD_MIN,ADD_MAX,ORDER_NUM,IS_DEL FROM T_BASE_ITEM_INFO WHERE ID='{2}'", strItemId, strToId, dr["ID"].ToString());
objArr.Add(strSQL);
TBaseItemAnalysisVo objAnsy = new TBaseItemAnalysisVo();
objAnsy.ITEM_ID = dr["ID"].ToString();
DataTable dtAnsy = new TBaseItemAnalysisAccess().SelectByTable(objAnsy);
if (dtAnsy.Rows.Count > 0)
{
foreach (DataRow drr in dtAnsy.Rows)
{
string strAnsyId = GetSerialNumber("t_base_item_analysis_id");
strSQL = string.Format(" INSERT INTO T_BASE_ITEM_ANALYSIS (ID,ITEM_ID,ANALYSIS_METHOD_ID,INSTRUMENT_ID,UNIT,PRECISION,UPPER_LIMIT,LOWER_LIMIT,LOWER_CHECKOUT,IS_DEFAULT,IS_DEL) SELECT '{0}','{1}',ANALYSIS_METHOD_ID,INSTRUMENT_ID,UNIT,PRECISION,UPPER_LIMIT,LOWER_LIMIT,LOWER_CHECKOUT,IS_DEFAULT,IS_DEL FROM T_BASE_ITEM_ANALYSIS WHERE ID='{2}'", strAnsyId, strItemId, drr["ID"].ToString());
objArr.Add(strSQL);
}
}
}
}
return(SqlHelper.ExecuteSQLByTransaction(objArr));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseItemAnalysis_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseItemAnalysis_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseItemAnalysisVo tBaseItemAnalysis_UpdateSet, TBaseItemAnalysisVo tBaseItemAnalysis_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseItemAnalysis_UpdateSet, TBaseItemAnalysisVo.T_BASE_ITEM_ANALYSIS_TABLE);
strSQL += this.BuildWhereStatement(tBaseItemAnalysis_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseItemAnalysis">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseItemAnalysisVo tBaseItemAnalysis)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseItemAnalysis, TBaseItemAnalysisVo.T_BASE_ITEM_ANALYSIS_TABLE);
strSQL += string.Format(" where ID='{0}' ", tBaseItemAnalysis.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取指定监测项目的分析方法
/// </summary>
private void GetMethods()
{
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 strSelItemID = (Request.Params["selItemID"] != null) ? Request.Params["selItemID"] : "";
if (strSelItemID.Length <= 0)
{
Response.Write("");
return;
}
if (strSortname == null || strSortname.Length < 0)
{
strSortname = TBaseItemAnalysisVo.ID_FIELD;
}
TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo();
objItemAnalysis.IS_DEL = "0";
objItemAnalysis.ITEM_ID = strSelItemID;
objItemAnalysis.SORT_FIELD = strSortname;
objItemAnalysis.SORT_TYPE = strSortorder;
TBaseItemAnalysisLogic logicItemAnalysis = new TBaseItemAnalysisLogic();
int intTotalCount = logicItemAnalysis.GetSelectResultCount(objItemAnalysis);;//总计的数据条数
DataTable dt = logicItemAnalysis.SelectByTable_ByJoin(objItemAnalysis, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
}
public static string getItemUnit(string strItemID)
{
TBaseItemAnalysisVo objItemAna = new TBaseItemAnalysisVo();
objItemAna.ITEM_ID = strItemID;
objItemAna = new TBaseItemAnalysisLogic().Details(objItemAna);
return(getDictName(objItemAna.UNIT, "item_unit"));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseItemAnalysisVo tBaseItemAnalysis)
{
string strSQL = "delete from T_BASE_ITEM_ANALYSIS ";
strSQL += this.BuildWhereStatement(tBaseItemAnalysis);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public static string saveCheckInfo(string strItemID, string strcheckID, string strLowResult, string strAnalysisMethod)
{
bool isSuccess = false;
TBaseItemAnalysisVo objItemAnalysisSet = new TBaseItemAnalysisVo();
objItemAnalysisSet.ID = strcheckID;
objItemAnalysisSet.ITEM_ID = strItemID;
objItemAnalysisSet.ANALYSIS_METHOD_ID = strAnalysisMethod;
objItemAnalysisSet.LOWER_CHECKOUT = strLowResult;
isSuccess = new TBaseItemAnalysisLogic().Edit(objItemAnalysisSet);
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 获取对象DataTable,不分页 by 熊卫华2012.11.04
/// </summary>
/// <param name="tBaseItemAnalysis">分析方法对象</param>
/// <returns></returns>
public DataTable SelectByTable_ByJoin(TBaseItemAnalysisVo tBaseItemAnalysis)
{
string strSQL1 = " select is_del,ID,ITEM_ID,ANALYSIS_METHOD_ID,INSTRUMENT_ID,UNIT as Unitcode,PRECISION,UPPER_LIMIT,LOWER_LIMIT,LOWER_CHECKOUT,IS_DEFAULT from T_BASE_ITEM_ANALYSIS {0} ";
strSQL1 = String.Format(strSQL1, BuildWhereStatement(tBaseItemAnalysis));
string strSQL = "select a.ANALYSIS_NAME as ANALYSIS_METHOD,a.METHOD_ID,m.METHOD_CODE as METHOD,ai.[NAME] as INSTRUMENT,ii.ITEM_NAME,d.DICT_TEXT as UNIT";
strSQL += ",i.* from (" + strSQL1 + ")i";
strSQL += " join T_BASE_METHOD_ANALYSIS a on a.id=i.ANALYSIS_METHOD_ID";
strSQL += " join T_BASE_METHOD_INFO m on m.id=a.METHOD_ID";
strSQL += " join T_BASE_ITEM_INFO ii on ii.id=i.ITEM_ID";
strSQL += " left join T_BASE_APPARATUS_INFO ai on ai.id=i.INSTRUMENT_ID and ai.is_del='0'";
strSQL += " join T_SYS_DICT d on d.DICT_CODE=i.Unitcode and d.DICT_TYPE='item_unit'";
strSQL += " where i.is_del='0' and a.is_del='0' and m.is_del='0' and ii.is_del='0'";
strSQL += " order by i.id";
return(SqlHelper.ExecuteDataTable(strSQL));
}
//获取项目中的分析方法、仪器，仅为下拉框 弹出grid使用
private void GetItemAnalysis(string strItemID)
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo();
objItemAnalysis.IS_DEL = "0";
objItemAnalysis.ITEM_ID = strItemID;
objItemAnalysis.SORT_FIELD = strSortname;
objItemAnalysis.SORT_TYPE = strSortorder;
TBaseItemAnalysisLogic logicItemAnalysis = new TBaseItemAnalysisLogic();
//int intTotalCount = logicItemAnalysis.GetSelectResultCount(objItemAnalysis); ;//总计的数据条数
DataTable dt = logicItemAnalysis.SelectByTable_ByJoin(objItemAnalysis, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, dt.Rows.Count);
Response.Write(strJson);
}
public static string deleteItem(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);
TBaseItemAnalysisVo objItemAnalysisSet = new TBaseItemAnalysisVo();
objItemAnalysisSet.IS_DEL = "1";
TBaseItemAnalysisVo objItemAnalysisWhere = new TBaseItemAnalysisVo();
objItemAnalysisWhere.ITEM_ID = arrDelIDs[i];
if (new TBaseItemAnalysisLogic().Edit(objItemAnalysisSet, objItemAnalysisWhere))
{
new PageBase().WriteLog("删除项目分析方法", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除项目ID" + objItemAnalysisWhere.ITEM_ID + "的分析方法成功");
}
}
if (isSuccess)
{
new PageBase().WriteLog("删除项目", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除项目" + arrDelIDs[0].ToString() + "成功");
return("1");
}
else
{
return("0");
}
}
public static string defMethod(string strItemID, string strMethodID)
{
bool isSuccess = true;
if (strItemID.Length == 0)
{
return("0");
}
if (strMethodID.Length == 0)
{
return("0");
}
TBaseItemAnalysisVo objItemAnalysisWhere = new TBaseItemAnalysisVo();
objItemAnalysisWhere.ITEM_ID = strItemID;
TBaseItemAnalysisVo objItemAnalysisSet = new TBaseItemAnalysisVo();
objItemAnalysisSet.IS_DEFAULT = "否";
isSuccess = new TBaseItemAnalysisLogic().Edit(objItemAnalysisSet, objItemAnalysisWhere);
TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo();
objItemAnalysis.ID = strMethodID;
objItemAnalysis.IS_DEFAULT = "是";
isSuccess = new TBaseItemAnalysisLogic().Edit(objItemAnalysis);
if (isSuccess)
{
new PageBase().WriteLog("设置项目的默认分析方法数据", "", new PageBase().LogInfo.UserInfo.USER_NAME + "设置项目的默认分析方法数据" + strMethodID + "成功");
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 获取指定监测项目的默认分析方法、依据
/// </summary>
/// <param name="strItemID">监测项目ID</param>
/// <param name="strAnalysisID">分析方法ID</param>
/// <param name="strStandardID">方法依据ID</param>
/// <param name="strCheckOut">最底检出限</param>
protected void getMethod(string strItemID, ref string strAnalysisID, ref string strStandardID, ref string strCheckOut)
{
TBaseItemAnalysisVo objAnalysis = new TBaseItemAnalysisVo();
objAnalysis.ITEM_ID = strItemID;
objAnalysis.IS_DEL = "0";
DataTable dtItemAnalysis = new TBaseItemAnalysisLogic().SelectByTable(objAnalysis);
if (dtItemAnalysis.Rows.Count > 0)
{
for (int i = 0; i < dtItemAnalysis.Rows.Count; i++)
{
if (dtItemAnalysis.Rows[i]["IS_DEFAULT"].ToString() == "是")//默认负责人，否则取第一条方法
{
strAnalysisID = dtItemAnalysis.Rows[i]["ID"].ToString();
strCheckOut = dtItemAnalysis.Rows[i]["LOWER_CHECKOUT"].ToString();
TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(dtItemAnalysis.Rows[i]["ANALYSIS_METHOD_ID"].ToString());
if (objMethod != null)
{
strStandardID = objMethod.METHOD_ID;
}
break;//默认方法 唯一
}
else
{
strAnalysisID = dtItemAnalysis.Rows[0]["ID"].ToString();
strCheckOut = dtItemAnalysis.Rows[0]["LOWER_CHECKOUT"].ToString();
TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(dtItemAnalysis.Rows[0]["ANALYSIS_METHOD_ID"].ToString());
if (objMethod != null)
{
strStandardID = objMethod.METHOD_ID;
}
}
}
}
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tBaseItemAnalysis">对象</param>
/// <returns></returns>
public TBaseItemAnalysisVo SelectByObject(TBaseItemAnalysisVo tBaseItemAnalysis)
{
return(access.SelectByObject(tBaseItemAnalysis));
}
public void InsertData()
{
string strsql = "select ID,Item_Name,Monitor_ID,IS_SAMPLEDEPT from T_BASE_ITEM_INFO Where 1=1 AND MONITOR_ID = '000000002' AND HAS_SUB_ITEM = '0' AND IS_SUB = '1' AND IS_DEL = '0' and ID like '%FQ%'";
DataTable DT = SqlHelper.ExecuteDataTable(strsql);
if (DT.Rows.Count > 0)
{
foreach (DataRow dr in DT.Rows)
{
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.ID = dr["ID"].ToString().Replace('F', 'K');
objItem.IS_DEL = "0";
objItem.HAS_SUB_ITEM = "0";//监测项目管理默认直接子项目。说明，父项目，在用户界面以项目包形式存在，不属于项目范畴；子项目、项目包，在数据库存一个表，对用户应该是两个概念。
objItem.IS_SUB = "1";
objItem.MONITOR_ID = "001000019";
objItem.ITEM_NAME = dr["Item_Name"].ToString();
objItem.IS_SAMPLEDEPT = dr["IS_SAMPLEDEPT"].ToString();
objItem.LAB_CERTIFICATE = "是";
objItem.MEASURE_CERTIFICATE = "是";
objItem.IS_ANYSCENE_ITEM = "0";
objItem.REMARK1 = "空气类";
string strLog = SqlHelper.BuildInsertExpress(objItem, TBaseItemInfoVo.T_BASE_ITEM_INFO_TABLE);
WriteLog(strLog);
string sql = "select ID,Item_id,ANALYSIS_METHOD_ID from T_BASE_ITEM_ANALYSIS where item_id='" + dr["ID"].ToString() + "'";
DataTable dts = SqlHelper.ExecuteDataTable(sql);
if (dts.Rows.Count > 0)
{
int count = 1;
foreach (DataRow drs in dts.Rows)
{
TBaseItemAnalysisVo objItemAnalysisSet = new TBaseItemAnalysisVo();
if (drs["ID"].ToString().Contains("FQ"))
{
if (dts.Rows.Count >= 2)
{
if (count == 1)
{
objItemAnalysisSet.ID = objItem.ID;
objItemAnalysisSet.IS_DEL = "0";
objItemAnalysisSet.ITEM_ID = objItem.ID;
objItemAnalysisSet.ANALYSIS_METHOD_ID = drs["ANALYSIS_METHOD_ID"].ToString();
objItemAnalysisSet.IS_DEFAULT = "否";
objItemAnalysisSet.PRECISION = "0";
objItemAnalysisSet.REMARK1 = "空气类";
count++;
}
else
{
string joinid = string.Empty;
string ID = objItem.ID.Substring(2, 7);
int newID = Convert.ToInt32(ID) + (count - 1);
if (newID <= 9)
{
joinid = "KQ000000" + newID.ToString();
}
else
{
joinid = "KQ00000" + newID.ToString();
}
objItemAnalysisSet.ID = joinid;
objItemAnalysisSet.IS_DEL = "0";
objItemAnalysisSet.ITEM_ID = joinid;
objItemAnalysisSet.ANALYSIS_METHOD_ID = drs["ANALYSIS_METHOD_ID"].ToString();
objItemAnalysisSet.IS_DEFAULT = "否";
objItemAnalysisSet.PRECISION = "0";
objItemAnalysisSet.REMARK1 = "空气类";
count++;
}
}
else
{
objItemAnalysisSet.ID = objItem.ID;
objItemAnalysisSet.IS_DEL = "0";
objItemAnalysisSet.ITEM_ID = objItem.ID;
objItemAnalysisSet.ANALYSIS_METHOD_ID = drs["ANALYSIS_METHOD_ID"].ToString();
objItemAnalysisSet.IS_DEFAULT = "否";
objItemAnalysisSet.PRECISION = "0";
objItemAnalysisSet.REMARK1 = "空气类";
}
}
else
{
objItemAnalysisSet.ID = GetSerialNumber("t_base_item_analysis_id");
objItemAnalysisSet.IS_DEL = "0";
objItemAnalysisSet.ITEM_ID = objItem.ID;
objItemAnalysisSet.ANALYSIS_METHOD_ID = drs["ANALYSIS_METHOD_ID"].ToString();
objItemAnalysisSet.IS_DEFAULT = "否";
objItemAnalysisSet.PRECISION = "0";
objItemAnalysisSet.REMARK1 = "空气类";
}
string strSQL = SqlHelper.BuildInsertExpress(objItemAnalysisSet, TBaseItemAnalysisVo.T_BASE_ITEM_ANALYSIS_TABLE);
WriteLog(strSQL);
}
if (dts.Rows.Count < count)
{
count = 1;
}
}
}
}
string strsqls = "select ID,Item_Name,Monitor_ID,IS_SAMPLEDEPT from T_BASE_ITEM_INFO Where 1=1 AND MONITOR_ID = '000000002' AND HAS_SUB_ITEM = '0' AND IS_SUB = '1' AND IS_DEL = '0' and ID NOT like '%FQ%'";
DataTable DTs = SqlHelper.ExecuteDataTable(strsqls);
if (DTs.Rows.Count > 0)
{
foreach (DataRow dr in DTs.Rows)
{
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 = "001000019";
objItem.ITEM_NAME = dr["Item_Name"].ToString();
objItem.IS_SAMPLEDEPT = dr["IS_SAMPLEDEPT"].ToString();
objItem.LAB_CERTIFICATE = "是";
objItem.MEASURE_CERTIFICATE = "是";
objItem.IS_ANYSCENE_ITEM = "0";
objItem.REMARK1 = "空气类";
string strLog = SqlHelper.BuildInsertExpress(objItem, TBaseItemInfoVo.T_BASE_ITEM_INFO_TABLE);
WriteLog(strLog);
string sql = "select ID,Item_id,ANALYSIS_METHOD_ID from T_BASE_ITEM_ANALYSIS where item_id='" + dr["ID"].ToString() + "'";
DataTable dts = SqlHelper.ExecuteDataTable(sql);
if (dts.Rows.Count > 0)
{
foreach (DataRow drs in dts.Rows)
{
TBaseItemAnalysisVo objItemAnalysisSet = new TBaseItemAnalysisVo();
objItemAnalysisSet.ID = GetSerialNumber("t_base_item_analysis_id");
objItemAnalysisSet.IS_DEL = "0";
objItemAnalysisSet.ITEM_ID = objItem.ID;
objItemAnalysisSet.ANALYSIS_METHOD_ID = drs["ANALYSIS_METHOD_ID"].ToString();
objItemAnalysisSet.IS_DEFAULT = "否";
objItemAnalysisSet.PRECISION = "0";
objItemAnalysisSet.REMARK1 = "空气类";
string strSQL = SqlHelper.BuildInsertExpress(objItemAnalysisSet, TBaseItemAnalysisVo.T_BASE_ITEM_ANALYSIS_TABLE);
WriteLog(strSQL);
}
}
}
}
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseItemAnalysis">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseItemAnalysisVo tBaseItemAnalysis, int iIndex, int iCount)
{
return(access.SelectByTable(tBaseItemAnalysis, iIndex, iCount));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseItemAnalysis">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseItemAnalysisVo> SelectByObject(TBaseItemAnalysisVo tBaseItemAnalysis, int iIndex, int iCount)
{
return(access.SelectByObject(tBaseItemAnalysis, iIndex, iCount));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseItemAnalysis">对象条件</param>
/// <returns>对象</returns>
public TBaseItemAnalysisVo Details(TBaseItemAnalysisVo tBaseItemAnalysis)
{
return(access.Details(tBaseItemAnalysis));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseItemAnalysis">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount_ByJoin(TBaseItemAnalysisVo tBaseItemAnalysis)
{
return(access.GetSelectResultCount_ByJoin(tBaseItemAnalysis));
}
public TBaseItemAnalysisLogic(TBaseItemAnalysisVo _tBaseItemAnalysis)
{
tBaseItemAnalysis = _tBaseItemAnalysis;
access = new TBaseItemAnalysisAccess();
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseItemAnalysisVo tBaseItemAnalysis)
{
return(access.Delete(tBaseItemAnalysis));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseItemAnalysis_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseItemAnalysis_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseItemAnalysisVo tBaseItemAnalysis_UpdateSet, TBaseItemAnalysisVo tBaseItemAnalysis_UpdateWhere)
{
return(access.Edit(tBaseItemAnalysis_UpdateSet, tBaseItemAnalysis_UpdateWhere));
}
public static string CopyPointItem(string strCopyID, string strPastID, string strSubtaskID)
{
bool isSuccess = true;
string strCopyPointID = new TMisMonitorSampleInfoLogic().Details(strCopyID).POINT_ID;
string strPastPointID = new TMisMonitorSampleInfoLogic().Details(strPastID).POINT_ID;
TMisMonitorTaskItemVo objPointItemCopy = new TMisMonitorTaskItemVo();
objPointItemCopy.IS_DEL = "0";
objPointItemCopy.TASK_POINT_ID = strCopyPointID;
DataTable dtCopy = new TMisMonitorTaskItemLogic().SelectByTable(objPointItemCopy);
TMisMonitorTaskItemVo objPointItemPast = new TMisMonitorTaskItemVo();
objPointItemPast.IS_DEL = "0";
objPointItemPast.TASK_POINT_ID = strPastPointID;
DataTable dtPast = new TMisMonitorTaskItemLogic().SelectByTable(objPointItemPast);
string strIsExistItem = "";
for (int i = 0; i < dtPast.Rows.Count; i++)
{
strIsExistItem += "," + dtPast.Rows[i]["ITEM_ID"].ToString();
}
strIsExistItem += strIsExistItem.Length > 0 ? "," : "";
//获取粘贴样品ID，填充结果表数据
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strPastID);
for (int i = 0; i < dtCopy.Rows.Count; i++)
{
DataRow dr = dtCopy.Rows[i];
string strCopyItemID = dr["ITEM_ID"].ToString();
if (!strIsExistItem.Contains(strCopyItemID))
{
TMisMonitorTaskItemVo objPointItem = new TMisMonitorTaskItemVo();
objPointItem.ID = GetSerialNumber("t_base_company_point_item_id");
objPointItem.IS_DEL = "0";
objPointItem.TASK_POINT_ID = strPastPointID;
objPointItem.ITEM_ID = strCopyItemID;
isSuccess = new TMisMonitorTaskItemLogic().Create(objPointItem);
TMisMonitorResultVo objResult = new TMisMonitorResultVo();
objResult.ID = GetSerialNumber("MonitorResultId");
objResult.SAMPLE_ID = objSample.ID;
objResult.ITEM_ID = strCopyItemID;
objResult.QC_TYPE = objSample.QC_TYPE;
objResult.RESULT_STATUS = "01";
//填充默认分析方法和方法依据
TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo();
objItemAnalysis.ITEM_ID = strCopyItemID;
objItemAnalysis.IS_DEFAULT = "是";
objItemAnalysis.IS_DEL = "0";
objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis);
if (objItemAnalysis.ID.Length > 0)
{
TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(objItemAnalysis.ANALYSIS_METHOD_ID);
objResult.ANALYSIS_METHOD_ID = objMethod.ID;
objMethod.METHOD_ID = objMethod.METHOD_ID;
}
isSuccess = new TMisMonitorResultLogic().Create(objResult);
string strAnalysisManagerID = "";
string strAnalysisManID = "";
TMisMonitorResultVo objResultTemp = new TMisMonitorResultVo();
objResultTemp.ID = objResult.ID;
DataTable dtManager = new TMisMonitorResultLogic().SelectManagerByTable(objResultTemp);
if (dtManager.Rows.Count > 0)
{
strAnalysisManagerID = dtManager.Rows[0]["ANALYSIS_MANAGER"].ToString();
strAnalysisManID = dtManager.Rows[0]["ANALYSIS_ID"].ToString();
}
TMisMonitorResultAppVo objResultApp = new TMisMonitorResultAppVo();
objResultApp.ID = GetSerialNumber("MonitorResultAppId");
objResultApp.RESULT_ID = objResult.ID;
objResultApp.HEAD_USERID = strAnalysisManagerID;
objResultApp.ASSISTANT_USERID = strAnalysisManID;
isSuccess = new TMisMonitorResultAppLogic().Create(objResultApp);
}
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
public static string SaveDataItem(string strSubtaskID, string strSample, string strSelItem_IDs)
{
bool isSuccess = true;
string[] arrSelItemId = strSelItem_IDs.Split(',');
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(strSample);
TMisMonitorTaskItemVo objPointItemSet = new TMisMonitorTaskItemVo();
objPointItemSet.IS_DEL = "1";
TMisMonitorTaskItemVo objPointItemWhere = new TMisMonitorTaskItemVo();
objPointItemWhere.IS_DEL = "0";
objPointItemWhere.TASK_POINT_ID = objSample.POINT_ID;
new TMisMonitorTaskItemLogic().Edit(objPointItemSet, objPointItemWhere);
TMisMonitorResultVo objResult = new TMisMonitorResultVo();
objResult = new TMisMonitorResultVo();
if (strSample.Length > 0)
{
objResult.SAMPLE_ID = strSample;
new TMisMonitorResultLogic().Delete(objResult);
}
if (strSelItem_IDs.Length > 0)
{
for (int i = 0; i < arrSelItemId.Length; i++)
{
TMisMonitorTaskItemVo objPointItem = new TMisMonitorTaskItemVo();
objPointItem.ID = GetSerialNumber("t_mis_monitor_task_item_id");
objPointItem.IS_DEL = "0";
objPointItem.TASK_POINT_ID = objSample.POINT_ID;
objPointItem.ITEM_ID = arrSelItemId[i];
isSuccess = new TMisMonitorTaskItemLogic().Create(objPointItem);
objResult = new TMisMonitorResultVo();
objResult.ID = GetSerialNumber("MonitorResultId");
objResult.SAMPLE_ID = objSample.ID;
objResult.ITEM_ID = arrSelItemId[i];
objResult.QC_TYPE = objSample.QC_TYPE;
objResult.RESULT_STATUS = "01";
//填充默认分析方法和方法依据
TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo();
objItemAnalysis.ITEM_ID = arrSelItemId[i];
objItemAnalysis.IS_DEFAULT = "是";
objItemAnalysis.IS_DEL = "0";
objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis);
if (objItemAnalysis.ID.Length > 0)
{
TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(objItemAnalysis.ANALYSIS_METHOD_ID);
objResult.ANALYSIS_METHOD_ID = objMethod.ID;
objMethod.METHOD_ID = objMethod.METHOD_ID;
}
isSuccess = new TMisMonitorResultLogic().Create(objResult);
string strAnalysisManagerID = "";
string strAnalysisManID = "";
TMisMonitorResultVo objResultTemp = new TMisMonitorResultVo();
objResultTemp.ID = objResult.ID;
DataTable dtManager = new TMisMonitorResultLogic().SelectManagerByTable(objResultTemp);
if (dtManager.Rows.Count > 0)
{
strAnalysisManagerID = dtManager.Rows[0]["ANALYSIS_MANAGER"].ToString();
strAnalysisManID = dtManager.Rows[0]["ANALYSIS_ID"].ToString();
}
TMisMonitorResultAppVo objResultApp = new TMisMonitorResultAppVo();
objResultApp.ID = GetSerialNumber("MonitorResultAppId");
objResultApp.RESULT_ID = objResult.ID;
objResultApp.HEAD_USERID = strAnalysisManagerID;
objResultApp.ASSISTANT_USERID = strAnalysisManID;
isSuccess = new TMisMonitorResultAppLogic().Create(objResultApp);
}
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseItemAnalysisVo tBaseItemAnalysis)
{
return(access.Create(tBaseItemAnalysis));
}
private static bool createQcInfo(string strSubTaskId, string strQcType, string strItemId)
{
bool isSuccess = true;
if (strItemId == "")
{
return(isSuccess);
}
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
string strQcSampleId = GetSerialNumber("MonitorSampleId");
objSample.ID = strQcSampleId;
objSample.SUBTASK_ID = strSubTaskId;
objSample.QC_TYPE = strQcType;
//objSample.SAMPLE_CODE = GetSampleCode_QHD(strQcSampleId);
//新增点位时候，自动生成该点位的样品编码
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
TBaseSerialruleVo objSerial = new TBaseSerialruleVo();
objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE;
objSerial.SERIAL_TYPE = "2";
objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd");
objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask);
objSample.NOSAMPLE = "1";
if (strQcType == "10")
{
objSample.SAMPLE_NAME = "空白加标样";
}
objSample.SAMPLE_COUNT = "";
//在样品表中添加样品数据
if (!new TMisMonitorSampleInfoLogic().Create(objSample))
{
isSuccess = false;
}
//遍历监测项目信息，将监测项目信息添加到结果表、结果分析执行表、空白加标表中
for (int i = 0; i < strItemId.Split(',').Length; i++)
{
//将数据写入结果表中
TMisMonitorResultVo objResult = new TMisMonitorResultVo();
objResult.ID = GetSerialNumber("MonitorResultId");
objResult.SAMPLE_ID = strQcSampleId;
objResult.QC_TYPE = strQcType;
objResult.ITEM_ID = strItemId.Split(',')[i];
//填充默认分析方法和方法依据
TBaseItemAnalysisVo objItemAnalysis = new TBaseItemAnalysisVo();
objItemAnalysis.ITEM_ID = objResult.ITEM_ID;
objItemAnalysis.IS_DEFAULT = "是";
objItemAnalysis.IS_DEL = "0";
objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis);
if (objItemAnalysis.ID.Length == 0)
{
objItemAnalysis = new TBaseItemAnalysisVo();
objItemAnalysis.ITEM_ID = objResult.ITEM_ID;
objItemAnalysis.IS_DEL = "0";
objItemAnalysis = new TBaseItemAnalysisLogic().Details(objItemAnalysis);
}
if (objItemAnalysis.ID.Length > 0)
{
TBaseMethodAnalysisVo objMethod = new TBaseMethodAnalysisLogic().Details(objItemAnalysis.ANALYSIS_METHOD_ID);
objResult.ANALYSIS_METHOD_ID = objMethod.ID;
objResult.STANDARD_ID = objMethod.METHOD_ID;
}
objResult.ANALYSIS_METHOD_ID = "";
objResult.STANDARD_ID = "";
objResult.TASK_TYPE = "发送";
objResult.RESULT_STATUS = "01";
if (!new TMisMonitorResultLogic().Create(objResult))
{
isSuccess = false;
}
//将数据写入结果分析执行表中
InsertResultAPP(objResult.ID);
//将结果写入分析样结果表中
TMisMonitorQcAddQhdVo objQcAdd = new TMisMonitorQcAddQhdVo();
objQcAdd.ID = GetSerialNumber("QcAddId_QHD");
objQcAdd.RESULT_ID_ADD = objResult.ID;
objQcAdd.QC_TYPE = strQcType;
if (!new TMisMonitorQcAddQhdLogic().Create(objQcAdd))
{
isSuccess = false;
}
}
return(isSuccess);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseItemAnalysis">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseItemAnalysisVo tBaseItemAnalysis)
{
return(access.Edit(tBaseItemAnalysis));
}
