//获取点位信息
private string getPointList()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
if (strSortname == null || strSortname.Length < 0)
{
strSortname = TMisMonitorTaskPointVo.NUM_FIELD;
}
if (this.SUBTASK_ID.Value.Length == 0)
{
return("");
}
if (this.MONITOR_ID.Value.Trim() == "FunctionNoise")
{
//如果是功能区噪声需要按一天24小时拆分样品
SplitFunctionNoiseByHour(this.SUBTASK_ID.Value.Trim());
}
TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo();
objSampleInfo.SUBTASK_ID = this.SUBTASK_ID.Value;
objSampleInfo.QC_TYPE = "0";
objSampleInfo.SORT_FIELD = "POINT_ID";
objSampleInfo.SORT_TYPE = "asc";
DataTable dtSample = new DataTable();
DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTable(objSampleInfo, intPageIndex, intPageSize);
string strUnit = "";
if (this.MONITOR_ID.Value.Trim() == "000000004")
{
strUnit = "dB(A)";
}
dtSample = new TMisMonitorSubtaskLogic().getItemBySubTaskID(this.SUBTASK_ID.Value.Trim());
for (int i = 0; i < dtSample.Rows.Count; i++)
{
dt.Columns.Add(dtSample.Rows[i]["ID"].ToString() + "@@" + dtSample.Rows[i]["ITEM_NAME"].ToString() + strUnit, typeof(string));
}
for (int i = 0; i < dt.Rows.Count; i++)
{
dtSample = new TMisMonitorSubtaskLogic().getItemValueBySampleID(dt.Rows[i]["ID"].ToString());
for (int j = 0; j < dtSample.Rows.Count; j++)
{
dt.Rows[i][dtSample.Rows[j]["ID"].ToString() + "@@" + dtSample.Rows[j]["ITEM_NAME"].ToString() + strUnit] = dtSample.Rows[j]["ITEM_RESULT"].ToString();
}
}
int intTotalCount = new TMisMonitorSampleInfoLogic().GetSelectResultCount(objSampleInfo);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 发送到下一环节
/// </summary>
/// <param name="strTaskId">任务ID</param>
/// <returns></returns>
public string SendToNext(string strTaskId)
{
bool IsSuccess = true;
//把样品从交接发送到分配环节
DataTable dtSample = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheet_QHD(strTaskId, "", "021,02");
for (int i = 0; i < dtSample.Rows.Count; i++)
{
TMisMonitorSampleInfoVo objSampleVo = new TMisMonitorSampleInfoVo();
objSampleVo.ID = dtSample.Rows[i]["ID"].ToString();
objSampleVo.NOSAMPLE = "2";
IsSuccess = new TMisMonitorSampleInfoLogic().Edit(objSampleVo);
}
//如果子任务的样品都采样完，刚更新子任务的状态
DataTable dt = new TMisMonitorResultLogic().getItemTypeInfo_QHD(strTaskId, "021", "01", "2", true);
for (int i = 0; i < dt.Rows.Count; i++)
{
string strMonitorID = dt.Rows[i]["MONITOR_ID"].ToString();
TMisMonitorSubtaskVo objSsubtask = new TMisMonitorSubtaskVo();
objSsubtask.TASK_ID = strTaskId;
objSsubtask.MONITOR_ID = strMonitorID;
objSsubtask = new TMisMonitorSubtaskLogic().Details(objSsubtask);
objSsubtask.SAMPLE_ACCESS_ID = LogInfo.UserInfo.ID;
objSsubtask.TASK_STATUS = "03";
if (!new TMisMonitorSubtaskLogic().Edit(objSsubtask))
{
IsSuccess = false;
}
}
return(IsSuccess == true ? "1" : "0");
}
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);
}
}
public static string saveSampleCode(string id, string strSampleCode, string strIsOk, string strAskingdate)
{
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample.ID = id;
objSample.SAMPLE_CODE = strSampleCode;
objSample.REMARK4 = strIsOk == "" ? "###" : strIsOk;
objSample.REMARK5 = strAskingdate == "" ? "###" : UTCConvert(strAskingdate);
bool isSuccess = new TMisMonitorSampleInfoLogic().Edit(objSample);
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 更新样品子样数据
/// </summary>
/// <returns></returns>
public string UpdateSample()
{
string result = "";
TMisMonitorSampleInfoVo objItems = new TMisMonitorSampleInfoVo();
objItems.ID = strSampleId;
objItems.SUBSAMPLE_NUM = strSubSampleNum;
if (new TMisMonitorSampleInfoLogic().Edit(objItems))
{
result = "true";
}
return(result);
}
public static string saveSample(string id, string strSubtaskID, string strSampleCode, string strSampleName, string strOriginalNum, string strSampleDes)
{
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample = new TMisMonitorSampleInfoLogic().Details(id);
objSample.SAMPLE_CODE = strSampleCode;
objSample.SAMPLE_NAME = strSampleName;
objSample.REMARK2 = strOriginalNum == "" ? "###" : strOriginalNum;
objSample.REMARK3 = strSampleDes == "" ? "###" : strSampleDes;
bool isSuccess = new TMisMonitorSampleInfoLogic().Edit(objSample);
return(isSuccess == true ? "1" : "0");
}
//获取点位信息
private string getPointList()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
if (strSortname == null || strSortname.Length < 0)
{
strSortname = TMisMonitorTaskPointVo.NUM_FIELD;
}
string strSubtaskID = this.SUBTASK_ID.Value;
if (strSubtaskID.Length == 0)
{
return("");
}
TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo();
objSampleInfo.SUBTASK_ID = strSubtaskID;
//objSampleInfo.QC_TYPE = "0";
objSampleInfo.SORT_FIELD = "ISNULL(SAMPLE_COUNT,'9999'),POINT_ID,ID";
objSampleInfo.NOSAMPLE = "0";
DataTable dtSample = new DataTable();
DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, intPageIndex, intPageSize);
dtSample = dt.Clone();
for (int i = 0; i < dt.Rows.Count; i++)
{
dtSample.ImportRow(dt.Rows[i]);
//objSampleInfo.QC_TYPE = "";
//objSampleInfo.QC_SOURCE_ID = dt.Rows[i]["ID"].ToString();
//objSampleInfo.SORT_FIELD = "QC_TYPE";
//objSampleInfo.NOSAMPLE = "0";
//DataTable dtQcSample = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, 0, 0);
//for (int j = 0; j < dtQcSample.Rows.Count; j++)
//{
// DataRow dr = dt.NewRow();
// dr = dtQcSample.Rows[j];
// dtSample.ImportRow(dr);
//}
}
int intTotalCount = dtSample.Rows.Count;
string strJson = CreateToJson(dtSample, intTotalCount);
return(strJson);
}
public string SaveUserInfo()
{
var sampleIds = this.strSampleIds.Value;
bool isSuccess = true;
var logic = new TMisMonitorSampleInfoLogic();
var sampleIdList = sampleIds.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries);
foreach (var sampleId in sampleIdList)
{
TMisMonitorSampleInfoVo vo = logic.Details(sampleId);
vo.REMARK5 = Request["DEFAULT_USER"];
logic.Edit(vo);
}
return(isSuccess == true ? "1" : "0");
}
//获取点位信息
private string getPointList()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
if (strSortname == null || strSortname.Length < 0)
{
strSortname = TMisMonitorTaskPointVo.NUM_FIELD;
}
string strSubtaskID = this.SUBTASK_ID.Value;
if (strSubtaskID.Length == 0)
{
return("");
}
TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo();
objSampleInfo.SUBTASK_ID = strSubtaskID;
objSampleInfo.QC_TYPE = "0";
objSampleInfo.SORT_FIELD = "POINT_ID";
DataTable dtSample = new DataTable();
DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, intPageIndex, intPageSize);
dtSample = dt.Clone();
for (int i = 0; i < dt.Rows.Count; i++)
{
dtSample.ImportRow(dt.Rows[i]);
objSampleInfo.QC_TYPE = "";
objSampleInfo.QC_SOURCE_ID = dt.Rows[i]["ID"].ToString();
objSampleInfo.SORT_FIELD = "QC_TYPE";
DataTable dtQcSample = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, 0, 0);
for (int j = 0; j < dtQcSample.Rows.Count; j++)
{
DataRow dr = dt.NewRow();
dr = dtQcSample.Rows[j];
//清远 生成样品编号（质控）
TMisMonitorSampleInfoVo objSampleQc = new TMisMonitorSampleInfoLogic().Details(dr["ID"].ToString());
if (objSampleQc.SAMPLE_CODE.Length == 0)
{
objSampleQc.SAMPLE_CODE = GetSampleCode(dr["ID"].ToString());
objSampleQc.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd");
new TMisMonitorSampleInfoLogic().Edit(objSampleQc);
dr["SAMPLE_CODE"] = objSampleQc.SAMPLE_CODE;
}
dtSample.ImportRow(dr);
}
//清远 采样时自动生成样品编号（原始样）
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(dt.Rows[i]["ID"].ToString());
if (objSample.SAMPLE_CODE.Length == 0)
{
objSample.SAMPLE_CODE = GetSampleCode(dt.Rows[i]["ID"].ToString());
objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd");
new TMisMonitorSampleInfoLogic().Edit(objSample);
dtSample.Rows[i]["SAMPLE_CODE"] = objSample.SAMPLE_CODE;
}
}
int intTotalCount = dtSample.Rows.Count;
string strJson = CreateToJson(dtSample, intTotalCount);
return(strJson);
}
