/// <summary>
/// 获取监测项目信息
/// </summary>
/// <returns></returns>
private string getThreeGridInfo(string strTwoGridId, string strTaskID)
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
//当前页面
int intPageIndex = Convert.ToInt32(Request.Params["page"]);
//每页记录数
int intPageSize = Convert.ToInt32(Request.Params["pagesize"]);
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);
}
DataTable dt = new TMisMonitorSampleInfoLogic().getSamplingAllocationSheet_MAS(strTaskID, strTwoGridId, "1,2");
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.Count > 0 && !sampleIdList.Contains(dt.Rows[i]["ID"].ToString()))
{
continue;
}
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(dt.Rows[i]["ID"].ToString());
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
if (objSample.SAMPLE_CODE.Length == 0)
{
//objSample.SAMPLE_CODE = GetSampleCode_QHD(dt.Rows[i]["ID"].ToString());
TBaseSerialruleVo objSerial = new TBaseSerialruleVo();
objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE;
objSerial.SERIAL_TYPE = "2";
objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd");
if (objTask.TASK_TYPE == "1")
{
objSample.SAMPLE_CODE = objSample.SAMPLE_NAME;
}
else
{
objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask);
}
new TMisMonitorSampleInfoLogic().Edit(objSample);
dt.Rows[i]["SAMPLE_CODE"] = objSample.SAMPLE_CODE;
}
//样品状态,外委除外(废水、地表水)
if (objTask.CONTRACT_TYPE != "04")
{
DataTable dtAtt = new DataTable();
string strAttValue = string.Empty;
string strAttID = "''";
if (objSubtask.MONITOR_ID == "000000001" || objSubtask.MONITOR_ID == "EnvDrinkingSource")
{
strAttID = "'000000017'";
}
if (objSubtask.MONITOR_ID == "EnvRiver")
{
strAttID = "'000000211'";
}
dtAtt = new i3.BusinessLogic.Channels.Base.DynamicAttribute.TBaseAttributeInfoLogic().GetAttValue(strAttID, dt.Rows[i]["POINT_ID"].ToString());
for (int j = 0; j < dtAtt.Rows.Count; j++)
{
strAttValue += dtAtt.Rows[j]["ATTRBUTE_TEXT"].ToString() + "、";
}
dt.Rows[i]["SAMPLE_STATUS"] = strAttValue.TrimEnd('、');
}
newDT.Rows.Add(dt.Rows[i].ItemArray);
}
int intTotalCount = newDT.Rows.Count;
string strJson = CreateToJson(newDT, intTotalCount);
return(strJson);
}
/// <summary>
/// 获取监测项目信息
/// </summary>
/// <returns></returns>
private string getThreeGridInfo(string strTwoGridId, string strTaskID)
{
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 TMisMonitorSampleInfoLogic().getSamplingAllocationSheet(strTaskID, strTwoGridId, "021");
//样品编号生成
for (int i = 0; i < dt.Rows.Count; i++)
{
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoLogic().Details(dt.Rows[i]["ID"].ToString());
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(objSample.SUBTASK_ID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
if (objSample.SAMPLE_CODE.Length == 0)
{
//objSample.SAMPLE_CODE = GetSampleCode_QHD(dt.Rows[i]["ID"].ToString());
TBaseSerialruleVo objSerial = new TBaseSerialruleVo();
objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE;
objSerial.SERIAL_TYPE = "2";
objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd");
if (objTask.TASK_TYPE == "1")
{
objSample.SAMPLE_CODE = objSample.SAMPLE_NAME;
}
else
{
objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask);
}
new TMisMonitorSampleInfoLogic().Edit(objSample);
dt.Rows[i]["SAMPLE_CODE"] = objSample.SAMPLE_CODE;
}
//样品状态,外委除外(废水、地表水)
if (objTask.CONTRACT_TYPE != "04")
{
DataTable dtAtt = new DataTable();
string strAttValue = string.Empty;
string strAttID = "''";
if (objSubtask.MONITOR_ID == "000000001")
{
strAttID = "'000000017'";
}
if (objSubtask.MONITOR_ID == "EnvRiver")
{
strAttID = "'000000211'";
}
dtAtt = new i3.BusinessLogic.Channels.Base.DynamicAttribute.TBaseAttributeInfoLogic().GetAttValue(strAttID, dt.Rows[i]["POINT_ID"].ToString());
for (int j = 0; j < dtAtt.Rows.Count; j++)
{
strAttValue += dtAtt.Rows[j]["ATTRBUTE_TEXT"].ToString() + "、";
}
dt.Rows[i]["SAMPLE_STATUS"] = strAttValue.TrimEnd('、');
}
}
int intTotalCount = dt.Rows.Count;
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}