public static string AddSample(string strSampleID)
{
bool IsSuccess = false;
//获取原始样信息
TMisMonitorSampleInfoVo TMisMonitorSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(strSampleID);
//根据原始样获取监测结果ID
TMisMonitorResultVo TMisMonitorResultVo = new TMisMonitorResultVo();
TMisMonitorResultVo.SAMPLE_ID = TMisMonitorSampleInfoVo.ID;
List <TMisMonitorResultVo> resultList = new TMisMonitorResultLogic().SelectByObject(TMisMonitorResultVo, 0, 1000000);
string strNewSampleId = GetSerialNumber("MonitorSampleId");
TMisMonitorSampleInfoVo.ID = strNewSampleId;
new TMisMonitorSampleInfoLogic().Create(TMisMonitorSampleInfoVo);
foreach (TMisMonitorResultVo TMisMonitorResultTemp in resultList)
{
string strOldResultId = TMisMonitorResultTemp.ID;
string strNewResultId = GetSerialNumber("MonitorResultId");
TMisMonitorResultTemp.ID = strNewResultId;
TMisMonitorResultTemp.SAMPLE_ID = strNewSampleId;
new TMisMonitorResultLogic().Create(TMisMonitorResultTemp);
TMisMonitorResultAppVo TMisMonitorResultAppVo = new TMisMonitorResultAppVo();
TMisMonitorResultAppVo.RESULT_ID = strOldResultId;
TMisMonitorResultAppVo TMisMonitorResultAppVoTemp = new TMisMonitorResultAppLogic().SelectByObject(TMisMonitorResultAppVo);
TMisMonitorResultAppVoTemp.ID = GetSerialNumber("MonitorResultAppId");
TMisMonitorResultAppVoTemp.RESULT_ID = strNewResultId;
new TMisMonitorResultAppLogic().Create(TMisMonitorResultAppVoTemp);
}
return(IsSuccess == true ? "1" : "0");
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorResultApp">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorResultAppVo tMisMonitorResultApp)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorResultApp, TMisMonitorResultAppVo.T_MIS_MONITOR_RESULT_APP_TABLE);
strSQL += string.Format(" where ID='{0}' ", tMisMonitorResultApp.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisMonitorResultApp">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisMonitorResultAppVo tMisMonitorResultApp, int iIndex, int iCount)
{
string strSQL = " select * from T_MIS_MONITOR_RESULT_APP {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tMisMonitorResultApp));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorResultApp_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisMonitorResultApp_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorResultAppVo tMisMonitorResultApp_UpdateSet, TMisMonitorResultAppVo tMisMonitorResultApp_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisMonitorResultApp_UpdateSet, TMisMonitorResultAppVo.T_MIS_MONITOR_RESULT_APP_TABLE);
strSQL += this.BuildWhereStatement(tMisMonitorResultApp_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 饼图绑定
/// </summary>
public void FillChart()
{
dt = new DataTable();
TMisMonitorResultAppVo objItems = new TMisMonitorResultAppVo();
objItems.REMARK3 = strYear;
objItems.REMARK4 = strMonth;
objItems.REMARK5 = strQuarter;
dt = new TMisMonitorResultAppLogic().GetAnalyseResultFinishedCount(objItems, strContractCode, strDept, strUserName);
if (dt.Rows.Count == 0)
{
DataRow dr = dt.NewRow();
dr["FINISHSUM"] = "0";
dr["FINISHTYPE"] = "无数据集";
dt.Rows.Add(dr);
dt.AcceptChanges();
}
ReportDataSource rds = new ReportDataSource("DataSet2", dt);
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
this.reportViewer2.LocalReport.DataSources.Add(rds);
this.reportViewer2.LocalReport.Refresh();
}
public static string getDefaultUserName(string strResultId)
{
DataTable dt = new DataTable();
dt.Columns.Add("UserId", typeof(string));
dt.Columns.Add("UserName", typeof(string));
TMisMonitorResultAppVo TMisMonitorResultAppVo = new TMisMonitorResultAppVo();
TMisMonitorResultAppVo.RESULT_ID = strResultId;
DataTable objTable = new TMisMonitorResultAppLogic().SelectByTable(TMisMonitorResultAppVo);
if (objTable.Rows.Count == 0)
{
return(DataTableToJson(dt));
}
string strUserId = objTable.Rows[0]["HEAD_USERID"].ToString();
if (strUserId == "")
{
return(DataTableToJson(dt));
}
//将获取用户ID信息转换成用户名称进行返回
string strUserName = new i3.BusinessLogic.Sys.General.TSysUserLogic().Details(strUserId).REAL_NAME;
DataRow row = dt.NewRow();
row["UserId"] = strUserId;
row["UserName"] = strUserName;
dt.Rows.Add(row);
return(DataTableToJson(dt));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisMonitorResultAppVo tMisMonitorResultApp)
{
string strSQL = "delete from T_MIS_MONITOR_RESULT_APP ";
strSQL += this.BuildWhereStatement(tMisMonitorResultApp);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public void SplitFunctionNoiseByHour(string strSubTaskID)
{
TMisMonitorSubtaskVo objSubtaskVo = new TMisMonitorSubtaskLogic().Details(strSubTaskID);
if (objSubtaskVo.SAMPLING_METHOD != "1") //SAMPLE_METHOD='1'时表示该任务已进行了拆分
{
objSubtaskVo.SAMPLING_METHOD = "1";
List <TMisMonitorSampleInfoVo> listSample = new List <TMisMonitorSampleInfoVo>();
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample.SUBTASK_ID = strSubTaskID;
TMisMonitorSampleInfoVo objSampleSet = new TMisMonitorSampleInfoVo();
objSampleSet.ENV_HOUR = "0";
new TMisMonitorSampleInfoLogic().Edit(objSampleSet, objSample);
listSample = new TMisMonitorSampleInfoLogic().SelectByObject(objSample, 0, 0);
for (int i = 0; i < listSample.Count; i++)
{
objSample = listSample[i];
TMisMonitorResultVo objResultVo = new TMisMonitorResultVo();
objResultVo.SAMPLE_ID = objSample.ID;
List <TMisMonitorResultVo> listResult = new List <TMisMonitorResultVo>();
listResult = new TMisMonitorResultLogic().SelectByObject(objResultVo, 0, 0);
for (int j = 1; j < 24; j++)
{
objSampleSet = new TMisMonitorSampleInfoVo();
CopyObject(objSample, objSampleSet);
objSampleSet.ID = GetSerialNumber("MonitorSampleId");
objSampleSet.ENV_HOUR = j.ToString();
for (int k = 0; k < listResult.Count; k++)
{
objResultVo = listResult[k];
TMisMonitorResultVo objResultAdd = new TMisMonitorResultVo();
CopyObject(objResultVo, objResultAdd);
objResultAdd.ID = GetSerialNumber("MonitorResultId");
objResultAdd.SAMPLE_ID = objSampleSet.ID;
TMisMonitorResultAppVo objResultAppVo = new TMisMonitorResultAppVo();
objResultAppVo.RESULT_ID = objResultVo.ID;
objResultAppVo = new TMisMonitorResultAppLogic().Details(objResultAppVo);
TMisMonitorResultAppVo objResultAppAdd = new TMisMonitorResultAppVo();
CopyObject(objResultAppVo, objResultAppAdd);
objResultAppAdd.ID = GetSerialNumber("MonitorResultAppId");
objResultAppAdd.RESULT_ID = objResultAdd.ID;
new TMisMonitorResultLogic().Create(objResultAdd);
new TMisMonitorResultAppLogic().Create(objResultAppAdd);
}
new TMisMonitorSampleInfoLogic().Create(objSampleSet);
}
}
new TMisMonitorSubtaskLogic().Edit(objSubtaskVo);
}
}
/// <summary>
/// 获取正常完成的列表
/// </summary>
public void GetAnalyseFinishing()
{
dt = new DataTable();
TMisMonitorResultAppVo objItems = new TMisMonitorResultAppVo();
objItems.REMARK3 = strYear;
objItems.REMARK4 = strMonth;
objItems.REMARK5 = strQuarter;
dt = new TMisMonitorResultAppLogic().GetAnalyseResultFinished(objItems, strContractCode, strDept, strUserName, false);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
this.reportViewer2.LocalReport.DataSources.Clear();
this.reportViewer2.LocalReport.DataSources.Add(rds);
this.reportViewer2.LocalReport.Refresh();
}
/// <summary>
/// 新增结果分析执行表信息
/// </summary>
/// <returns></returns>
private static void InsertResultAPP(string strResultID)
{
TMisMonitorResultVo objResult = new TMisMonitorResultVo();
objResult.ID = strResultID;
DataTable dt = new TMisMonitorResultLogic().SelectManagerByTable(objResult);
TMisMonitorResultAppVo objResultApp = new TMisMonitorResultAppVo();
objResultApp.ID = GetSerialNumber("MonitorResultAppId");
objResultApp.RESULT_ID = strResultID;
if (dt.Rows.Count > 0)
{
objResultApp.HEAD_USERID = dt.Rows[0]["ANALYSIS_MANAGER"].ToString();
objResultApp.ASSISTANT_USERID = dt.Rows[0]["ANALYSIS_ID"].ToString();
}
new TMisMonitorResultAppLogic().Create(objResultApp);
}
public static string getDefaultUserExName(string strResultId)
{
DataTable dt = new DataTable();
dt.Columns.Add("UserId", typeof(string));
dt.Columns.Add("UserName", typeof(string));
TMisMonitorResultAppVo TMisMonitorResultAppVo = new TMisMonitorResultAppVo();
TMisMonitorResultAppVo.RESULT_ID = strResultId;
DataTable objTable = new TMisMonitorResultAppLogic().SelectByTable(TMisMonitorResultAppVo);
if (objTable.Rows.Count == 0)
{
return(DataTableToJson(dt));
}
string strUserExIds = objTable.Rows[0]["ASSISTANT_USERID"].ToString();
if (strUserExIds == "")
{
return(DataTableToJson(dt));
}
List <string> list = strUserExIds.Split(',').ToList();
string strSumUserExName = "";
string spit = "";
foreach (string strUserExId in list)
{
string strUserName = new i3.BusinessLogic.Sys.General.TSysUserLogic().Details(strUserExId).REAL_NAME;
strSumUserExName = strSumUserExName + spit + strUserName;
spit = ",";
}
DataRow row = dt.NewRow();
row["UserId"] = strUserExIds;
row["UserName"] = strSumUserExName;
dt.Rows.Add(row);
return(DataTableToJson(dt));
}
public static string saveItemFinishDate(string id, string strFinishDate)
{
bool isSuccess = true;
TMisMonitorResultAppVo resultapp = new TMisMonitorResultAppVo();
resultapp.RESULT_ID = id;
DataTable dt = new TMisMonitorResultAppLogic().SelectByTable(resultapp);
if (dt.Rows.Count > 0)
{
resultapp.ID = dt.Rows[0]["ID"].ToString();
resultapp.FINISH_DATE = strFinishDate;
isSuccess = new TMisMonitorResultAppLogic().Edit(resultapp);
}
else
{
isSuccess = false;
}
return(isSuccess == true ? "1" : "0");
}
public static string getAskingDate(string strResultId)
{
DataTable dt = new DataTable();
TMisMonitorResultAppVo TMisMonitorResultAppVo = new TMisMonitorResultAppVo();
TMisMonitorResultAppVo.RESULT_ID = strResultId;
DataTable objTable = new TMisMonitorResultAppLogic().SelectByTable(TMisMonitorResultAppVo);
if (objTable.Rows.Count == 0)
{
return(DataTableToJson(dt));
}
string strAskingDate = objTable.Rows[0]["ASKING_DATE"].ToString();
if (strAskingDate != "")
{
strAskingDate = DateTime.Parse(strAskingDate).ToString("yyyy-MM-dd");
}
return(strAskingDate);
}
/// <summary>
/// 获取污染源监测列表
/// </summary>
public void GetAnalyseFinished()
{
dt = new DataTable();
TMisContractVo objItems = new TMisContractVo();
objItems.REMARK3 = strMonitor;
objItems.REMARK4 = strContractType;
objItems.REMARK5 = strYear;
TMisMonitorResultAppVo objItemsFree = new TMisMonitorResultAppVo();
objItemsFree.REMARK3 = strCompanyName;
objItemsFree.REMARK4 = strItemName;
objItemsFree.REMARK5 = strPointName;
dt = new TMisMonitorResultAppLogic().GetPollutantSourceReport(objItemsFree, objItems);
ReportDataSource rds = new ReportDataSource("DataSet1", dt);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
}
public static string saveItemInfo(string id, string strItemResult, string strAnalysisMethod)
{
TMisMonitorResultVo TMisMonitorResultVo = new TMisMonitorResultVo();
TMisMonitorResultVo.ID = id;
TMisMonitorResultVo.ITEM_RESULT = strItemResult == "" ? "###" : strItemResult;
TMisMonitorResultVo.ANALYSIS_METHOD_ID = strAnalysisMethod;
bool isSuccess = new TMisMonitorResultLogic().Edit(TMisMonitorResultVo);
TMisMonitorResultAppVo TMisMonitorResultAppVo = new TMisMonitorResultAppVo();
TMisMonitorResultAppVo.RESULT_ID = id;
string strResultAppId = new TMisMonitorResultAppLogic().Details(TMisMonitorResultAppVo).ID;
TMisMonitorResultAppVo TMisMonitorResultAppVoTemp = new TMisMonitorResultAppVo();
TMisMonitorResultAppVoTemp.ID = strResultAppId;
TMisMonitorResultAppVoTemp.FINISH_DATE = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
new TMisMonitorResultAppLogic().Edit(TMisMonitorResultAppVoTemp);
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 饼图绑定
/// </summary>
public void FillChart()
{
dt = new DataTable();
TMisContractVo objItems = new TMisContractVo();
objItems.REMARK3 = strMonitor;
objItems.REMARK4 = strContractType;
objItems.REMARK5 = strYear;
TMisMonitorResultAppVo objItemsFree = new TMisMonitorResultAppVo();
objItemsFree.REMARK3 = strCompanyName;
objItemsFree.REMARK4 = strItemName;
objItemsFree.REMARK5 = strPointName;
dt = new TMisMonitorResultAppLogic().GetPollutantSourceReport(objItemsFree, objItems);
if (dt.Rows.Count == 0)
{
//return;
}
ReportDataSource rds = new ReportDataSource("DataSet2", dt);
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.LocalReport.Refresh();
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisMonitorResultAppVo tMisMonitorResultApp)
{
return(access.Delete(tMisMonitorResultApp));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisMonitorResultAppVo tMisMonitorResultApp)
{
return(access.Create(tMisMonitorResultApp));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorResultApp">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorResultAppVo tMisMonitorResultApp)
{
return(access.Edit(tMisMonitorResultApp));
}
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>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisMonitorResultApp"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisMonitorResultAppVo tMisMonitorResultApp)
{
return(access.SelectByTable(tMisMonitorResultApp));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisMonitorResultApp">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisMonitorResultAppVo tMisMonitorResultApp, int iIndex, int iCount)
{
return(access.SelectByTable(tMisMonitorResultApp, iIndex, iCount));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisMonitorResultApp">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisMonitorResultAppVo> SelectByObject(TMisMonitorResultAppVo tMisMonitorResultApp, int iIndex, int iCount)
{
return(access.SelectByObject(tMisMonitorResultApp, iIndex, iCount));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisMonitorResultApp">对象条件</param>
/// <returns>对象</returns>
public TMisMonitorResultAppVo Details(TMisMonitorResultAppVo tMisMonitorResultApp)
{
return(access.Details(tMisMonitorResultApp));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisMonitorResultApp">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisMonitorResultAppVo tMisMonitorResultApp)
{
return(access.GetSelectResultCount(tMisMonitorResultApp));
}
public TMisMonitorResultAppLogic(TMisMonitorResultAppVo _tMisMonitorResultApp)
{
tMisMonitorResultApp = _tMisMonitorResultApp;
access = new TMisMonitorResultAppAccess();
}
/// <summary>
/// 获取指定年份、企业、监测类别、点位、监测项目等数据，构造曲线图表 胡方扬 2013-03-07
/// </summary>
/// <param name="tMisMonitorResultApp"></param>
/// <param name="tMisContract"></param>
/// <returns></returns>
public DataTable GetPollutantSourceReport(TMisMonitorResultAppVo tMisMonitorResultApp, TMisContractVo tMisContract)
{
return(access.GetPollutantSourceReport(tMisMonitorResultApp, tMisContract));
}
/// <summary>
/// 获取完成及时率列表
/// </summary>
/// <param name="type">true,h获取超时的，false获取正常完成的</param>
/// <returns></returns>
public DataTable GetAnalyseResultFinishedCount(TMisMonitorResultAppVo tMisMonitorResultApp, string strContract_Code, string strDept, string strUserName)
{
return(access.GetAnalyseResultFinishedCount(tMisMonitorResultApp, strContract_Code, strDept, strUserName));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisMonitorResultApp_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisMonitorResultApp_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisMonitorResultAppVo tMisMonitorResultApp_UpdateSet, TMisMonitorResultAppVo tMisMonitorResultApp_UpdateWhere)
{
return(access.Edit(tMisMonitorResultApp_UpdateSet, tMisMonitorResultApp_UpdateWhere));
}
