//点位
private void GetPoint_UnderTask(string strContractID, string strSubTaskID, ref string strPointNames, ref string strFREQ, ref string strItemS)
{
TMisMonitorSampleInfoVo objSampleInfo = new TMisMonitorSampleInfoVo();
objSampleInfo.SUBTASK_ID = strSubTaskID;
DataTable dt = new TMisMonitorSampleInfoLogic().SelectByTableForPoint(objSampleInfo, 0, 0);
string strtmpPointNameS = "";
string strtmpItems = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
TMisMonitorTaskPointVo objTaskPoint = new TMisMonitorTaskPointLogic().Details(dt.Rows[i]["POINT_ID"].ToString());
if (!strtmpPointNameS.Contains(objTaskPoint.POINT_NAME))
{
strtmpPointNameS += (strtmpPointNameS.Length > 0 ? "、" : "") + objTaskPoint.POINT_NAME;
GetItem_UnderSample(dt.Rows[i]["ID"].ToString(), objTaskPoint.POINT_NAME, ref strtmpItems);
TMisContractPointVo objContractPointVo = new TMisContractPointVo();
objContractPointVo = new TMisContractPointLogic().Details(objTaskPoint.CONTRACT_POINT_ID);
strFREQ += (strFREQ.Length > 0 ? "\n" : "") + objTaskPoint.POINT_NAME + "：连续" + (objContractPointVo.SAMPLE_DAY == "" ? "1" : objContractPointVo.SAMPLE_DAY) + "天，每天" + (objContractPointVo.SAMPLE_FREQ == "" ? "1" : objContractPointVo.SAMPLE_FREQ) + "次";
}
}
strItemS += (strItemS.Length > 0 ? "\n" : "") + strtmpItems;
strPointNames += (strPointNames.Length > 0 ? "\r\n" : "") + strtmpPointNameS;
}
public static string getTestTypes(string strValue)
{
TMisContractPointVo objContractPoint = new TMisContractPointVo();
objContractPoint.CONTRACT_ID = strValue;
objContractPoint.IS_DEL = "0";
DataTable dt = new TMisContractPointLogic().SelectByTable(objContractPoint, 0, 0);
string strTypeIDs = "";
string strTypeNames = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
string strTypeID = dt.Rows[i]["MONITOR_ID"].ToString();
if (!strTypeIDs.Contains(strTypeID))
{
strTypeIDs += (strTypeIDs.Length == 0 ? "" : ",") + strTypeID;
}
}
if (strTypeIDs.Length > 0)
{
string[] arrTypeID = strTypeIDs.Split(',');
for (int i = 0; i < arrTypeID.Length; i++)
{
string strTypeName = new TBaseMonitorTypeInfoLogic().Details(arrTypeID[i]).MONITOR_TYPE_NAME;
strTypeNames += (strTypeNames.Length > 0 ? "," : "") + strTypeName;
}
}
return(strTypeNames);
}
public static string InsertEnvContractPoint_Pan(string strPlanId, string strEvnTypeId, string strPointItem, string strPointItemName, string strProjectName, string strTableName, string strKeyColumns)
{
string flag = "0";
removeRepeatPoint(ref strPointItem, ref strPointItemName);
TMisContractPointVo objItems = new TMisContractPointVo();
objItems.MONITOR_ID = strEvnTypeId;
objItems.POINT_ID = strPointItem;
objItems.POINT_NAME = strPointItemName;
//if (new TMisContractPointLogic().InsertEnvPoints(objItems, strPlanId, strKeyColumns, strTableName))
//{
SavePlanPeopleForEnv(strPlanId);
flag = "1";
//}
return(flag);
}
/// <summary>
/// 获得委托点位信息
/// </summary>
/// <param name="strContractID">委托书ID</param>
/// <returns></returns>
protected void getContractPoint(string strContractID)
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
//构造查询对象
TMisContractPointVo objPoint = new TMisContractPointVo();
TMisContractPointLogic objPointLogic = new TMisContractPointLogic();
if (strSortname == null || strSortname.Length == 0)
{
strSortname = TMisContractPointVo.NUM_FIELD;
}
objPoint.SORT_FIELD = strSortname;
objPoint.SORT_TYPE = strSortorder;
objPoint.CONTRACT_ID = strContractID;
objPoint.IS_DEL = "0";
int intTotalCount = objPointLogic.GetSelectResultCount(objPoint);//总计的数据条数
DataTable dt = objPointLogic.SelectByTable(objPoint, intPageIdx, intPagesize);
//插入委托书编号
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
dr["REMARK1"] = new TMisContractLogic().Details(strContractID).CONTRACT_CODE;
}
}
string strJson = CreateToJson(dt, intTotalCount);
Response.Write(strJson);
Response.End();
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisContractPoint">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisContractPointVo tMisContractPoint)
{
return(access.GetSelectResultCount(tMisContractPoint));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisContractPoint">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisContractPointVo tMisContractPoint, int iIndex, int iCount)
{
return(access.SelectByTable(tMisContractPoint, iIndex, iCount));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisContractPoint"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisContractPointVo tMisContractPoint)
{
return(access.SelectByTable(tMisContractPoint));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisContractPoint">对象条件</param>
/// <returns>对象</returns>
public TMisContractPointVo Details(TMisContractPointVo tMisContractPoint)
{
return(access.Details(tMisContractPoint));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisContractPoint">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisContractPointVo> SelectByObject(TMisContractPointVo tMisContractPoint, int iIndex, int iCount)
{
return(access.SelectByObject(tMisContractPoint, iIndex, iCount));
}
/// <summary>
/// 根据监测天数拆分任务（验收监测） Create By:weilin 2014-12-04
/// </summary>
/// <param name="strTaskID"></param>
/// <returns></returns>
private static bool SplitAcceptTask(string strTaskID, TBaseSerialruleVo objSerial)
{
bool bResult = true;
TMisMonitorTaskVo objTaskVo = new TMisMonitorTaskLogic().Details(strTaskID);
TMisMonitorReportVo objReportVo = new TMisMonitorReportVo();
if (objTaskVo.CONTRACT_TYPE == "05") //验收监测
{
TMisContractVo objContractVo = new TMisContractLogic().Details(objTaskVo.CONTRACT_ID);
TMisContractPointVo objContractPointVo = new TMisContractPointVo();
objContractPointVo.CONTRACT_ID = objTaskVo.CONTRACT_ID;
objContractPointVo.IS_DEL = "0";
objContractPointVo = new TMisContractPointLogic().Details(objContractPointVo);
if (objContractPointVo.SAMPLE_DAY != "" && IsNumeric(objContractPointVo.SAMPLE_DAY) && objContractVo.REMARK5 == "")
{
int iSampleDay = int.Parse(objContractPointVo.SAMPLE_DAY);
TMisMonitorTaskCompanyVo objClient = new TMisMonitorTaskCompanyLogic().Details(objTaskVo.CLIENT_COMPANY_ID);
TMisMonitorTaskCompanyVo objTested = new TMisMonitorTaskCompanyLogic().Details(objTaskVo.TESTED_COMPANY_ID);
for (int i = 1; i < iSampleDay; i++)
{
TMisMonitorTaskVo objTaskAddVo = new TMisMonitorTaskVo();
objTaskAddVo.ID = GetSerialNumber("t_mis_monitor_taskId");
objTaskAddVo.CONTRACT_ID = objTaskVo.CONTRACT_ID;
objTaskAddVo.PLAN_ID = objTaskVo.PLAN_ID;
objTaskAddVo.CONTRACT_CODE = objTaskVo.CONTRACT_CODE;
objTaskAddVo.TICKET_NUM = objTaskVo.TICKET_NUM + "-" + (i + 1).ToString();
objTaskAddVo.PROJECT_NAME = objTaskVo.PROJECT_NAME;
objTaskAddVo.CONTRACT_YEAR = objTaskVo.CONTRACT_YEAR;
objTaskAddVo.CONTRACT_TYPE = objTaskVo.CONTRACT_TYPE;
objTaskAddVo.TEST_TYPE = objTaskVo.TEST_TYPE;
objTaskAddVo.TEST_PURPOSE = objTaskVo.TEST_PURPOSE;
objTaskAddVo.ASKING_DATE = objTaskVo.ASKING_DATE;
objTaskAddVo.SAMPLE_SOURCE = objTaskVo.SAMPLE_SOURCE;
objTaskAddVo.CREATOR_ID = objTaskVo.CREATOR_ID;
objTaskAddVo.CREATE_DATE = objTaskVo.CREATE_DATE;
objTaskAddVo.TASK_STATUS = objTaskVo.TASK_STATUS;
objTaskAddVo.REMARK1 = objTaskVo.REMARK1;
objTaskAddVo.REMARK2 = objTaskVo.REMARK2;
objTaskAddVo.REMARK3 = objTaskVo.REMARK3;
objTaskAddVo.QC_STATUS = objTaskVo.QC_STATUS;
objTaskAddVo.COMFIRM_STATUS = objTaskVo.COMFIRM_STATUS;
objTaskAddVo.ALLQC_STATUS = objTaskVo.ALLQC_STATUS;
objTaskAddVo.REPORT_HANDLE = objTaskVo.REPORT_HANDLE;
//构造监测任务委托企业信息
TMisMonitorTaskCompanyVo objClientAdd = new TMisMonitorTaskCompanyVo();
PageBase.CopyObject(objClient, objClientAdd);//复制对象
objClientAdd.ID = PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId");
objClientAdd.TASK_ID = objTaskAddVo.ID;
//构造监测任务受检企业信息
TMisMonitorTaskCompanyVo objTestedAdd = new TMisMonitorTaskCompanyVo();
PageBase.CopyObject(objTested, objTestedAdd);//复制对象
objTestedAdd.ID = PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId");
objTestedAdd.TASK_ID = objTaskAddVo.ID;
objTaskAddVo.CLIENT_COMPANY_ID = objClientAdd.ID;
objTaskAddVo.TESTED_COMPANY_ID = objTestedAdd.ID;
TMisMonitorReportVo objReportAdd = new TMisMonitorReportVo();
objReportVo.ID = GetSerialNumber("t_mis_monitor_report_id");
objReportVo.REPORT_CODE = objReportVo.REPORT_CODE + "-" + (i + 1).ToString();
objReportVo.TASK_ID = objTaskAddVo.ID;
objReportVo.IF_GET = "0";
//监测子任务信息 根据委托书监测类别进行构造
ArrayList arrSubTask = new ArrayList(); //监测子任务集合
ArrayList arrSubTaskApp = new ArrayList();
ArrayList arrTaskPoint = new ArrayList(); //监测点位集合
ArrayList arrPointItem = new ArrayList(); //监测点位明细集合
ArrayList arrSample = new ArrayList(); //样品集合
ArrayList arrSampleResult = new ArrayList(); //样品结果集合
ArrayList arrSampleResultApp = new ArrayList(); //样品分析执行表
List <TMisMonitorSubtaskVo> listSubTask = new TMisMonitorSubtaskLogic().SelectByObject(new TMisMonitorSubtaskVo()
{
TASK_ID = objTaskVo.ID
}, 0, 0);
for (int j = 0; j < listSubTask.Count; j++)
{
TMisMonitorSubtaskVo objSubTaskAdd = new TMisMonitorSubtaskVo();
CopyObject(listSubTask[j], objSubTaskAdd);
objSubTaskAdd.ID = GetSerialNumber("t_mis_monitor_subtaskId");
objSubTaskAdd.TASK_ID = objTaskAddVo.ID;
arrSubTask.Add(objSubTaskAdd);
TMisMonitorSubtaskAppVo objSubTaskApp = new TMisMonitorSubtaskAppVo();
objSubTaskApp.SUBTASK_ID = listSubTask[j].ID;
objSubTaskApp = new TMisMonitorSubtaskAppLogic().Details(objSubTaskApp);
TMisMonitorSubtaskAppVo objSubTaskAppAdd = new TMisMonitorSubtaskAppVo();
CopyObject(objSubTaskApp, objSubTaskAppAdd);
objSubTaskAppAdd.ID = GetSerialNumber("TMisMonitorSubtaskAppID");
objSubTaskAppAdd.SUBTASK_ID = objSubTaskAdd.ID;
arrSubTaskApp.Add(objSubTaskAppAdd);
List <TMisMonitorTaskPointVo> listTaskPoint = new TMisMonitorTaskPointLogic().SelectByObject(new TMisMonitorTaskPointVo()
{
TASK_ID = objTaskVo.ID, SUBTASK_ID = listSubTask[j].ID, IS_DEL = "0"
}, 0, 0);
for (int k = 0; k < listTaskPoint.Count; k++)
{
TMisMonitorTaskPointVo objTaskPointAdd = new TMisMonitorTaskPointVo();
CopyObject(listTaskPoint[k], objTaskPointAdd);
objTaskPointAdd.ID = GetSerialNumber("t_mis_monitor_taskpointId");
objTaskPointAdd.TASK_ID = objTaskAddVo.ID;
arrTaskPoint.Add(objTaskPointAdd);
TMisMonitorSampleInfoVo objSampleInfoVo = new TMisMonitorSampleInfoVo();
objSampleInfoVo.SUBTASK_ID = listSubTask[j].ID;
objSampleInfoVo.POINT_ID = listTaskPoint[k].ID;
objSampleInfoVo = new TMisMonitorSampleInfoLogic().Details(objSampleInfoVo);
TMisMonitorSampleInfoVo objSampleInfoAdd = new TMisMonitorSampleInfoVo();
CopyObject(objSampleInfoVo, objSampleInfoAdd);
objSampleInfoAdd.ID = GetSerialNumber("MonitorSampleId");
objSampleInfoAdd.SUBTASK_ID = objSubTaskAdd.ID;
objSampleInfoAdd.POINT_ID = objTaskPointAdd.ID;
objSampleInfoAdd.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTaskAddVo, objSubTaskAdd);
arrSample.Add(objSampleInfoAdd);
List <TMisMonitorTaskItemVo> listTaskItem = new TMisMonitorTaskItemLogic().SelectByObject(new TMisMonitorTaskItemVo()
{
TASK_POINT_ID = listTaskPoint[k].ID, IS_DEL = "0"
}, 0, 0);
for (int l = 0; l < listTaskItem.Count; l++)
{
TMisMonitorTaskItemVo objTaskItemAdd = new TMisMonitorTaskItemVo();
CopyObject(listTaskItem[l], objTaskItemAdd);
objTaskItemAdd.ID = GetSerialNumber("t_mis_monitor_task_item_id");
objTaskItemAdd.TASK_POINT_ID = objTaskPointAdd.ID;
arrPointItem.Add(objTaskItemAdd);
}
List <TMisMonitorResultVo> listResult = new TMisMonitorResultLogic().SelectByObject(new TMisMonitorResultVo()
{
SAMPLE_ID = objSampleInfoVo.ID
}, 0, 0);
for (int l = 0; l < listResult.Count; l++)
{
TMisMonitorResultVo objResultAdd = new TMisMonitorResultVo();
CopyObject(listResult[l], objResultAdd);
objResultAdd.ID = GetSerialNumber("MonitorResultId");
objResultAdd.SAMPLE_ID = objSampleInfoAdd.ID;
arrSampleResult.Add(objResultAdd);
TMisMonitorResultAppVo objResultAppVo = new TMisMonitorResultAppVo();
objResultAppVo.RESULT_ID = listResult[l].ID;
objResultAppVo = new TMisMonitorResultAppLogic().Details(objResultAppVo);
TMisMonitorResultAppVo objResultAppAdd = new TMisMonitorResultAppVo();
CopyObject(objResultAppVo, objResultAppAdd);
objResultAppAdd.ID = GetSerialNumber("MonitorResultAppId");
objResultAppAdd.RESULT_ID = objResultAdd.ID;
arrSampleResultApp.Add(objResultAppAdd);
}
}
}
if (new TMisMonitorTaskLogic().SaveTrans(objTaskAddVo, objClientAdd, objTestedAdd, objReportVo, arrTaskPoint, arrSubTask, arrSubTaskApp, arrPointItem, arrSample, arrSampleResult, arrSampleResultApp))
{
bResult = true;
}
}
//更新任务单号
objTaskVo.TICKET_NUM = objTaskVo.TICKET_NUM + "-1";
new TMisMonitorTaskLogic().Edit(objTaskVo);
//更新报告单号
objReportVo.REPORT_CODE = objReportVo.REPORT_CODE + "-1";
new TMisMonitorReportLogic().Edit(objReportVo);
//更新验收委托书任务已经拆分任务的标志
objContractVo.REMARK5 = "1";
new TMisContractLogic().Edit(objContractVo);
}
}
return(bResult);
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tMisContractPoint">对象</param>
/// <returns></returns>
public TMisContractPointVo SelectByObject(TMisContractPointVo tMisContractPoint)
{
return(access.SelectByObject(tMisContractPoint));
}
public TMisContractPointLogic(TMisContractPointVo _tMisContractPoint)
{
tMisContractPoint = _tMisContractPoint;
access = new TMisContractPointAccess();
}
/// <summary>
/// 创建原因：取指定委托书尚未预约的点位列表
/// 创建人：胡方扬
/// 创建日期：2013-07-04
/// </summary>
/// <param name="strPointId"></param>
/// <returns></returns>
public DataTable GetContractPointCondtion(TMisContractPointVo tMisContractPoint, int iIndex, int iCount)
{
return(access.GetContractPointCondtion(tMisContractPoint, iIndex, iCount));
}
/// <summary>
/// 插入环境质量点位及其相关点位项目
/// </summary>
/// <param name="tMisContractPointitem"></param>
/// <returns></returns>
public bool InsertEnvPoints(TMisContractPointVo tMisContractPoint, string PlanId, string KeyCloumns, string TableName)
{
return(access.InsertEnvPoints(tMisContractPoint, PlanId, KeyCloumns, TableName));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisContractPointVo tMisContractPoint)
{
return(access.Delete(tMisContractPoint));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractPoint_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisContractPoint_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractPointVo tMisContractPoint_UpdateSet, TMisContractPointVo tMisContractPoint_UpdateWhere)
{
return(access.Edit(tMisContractPoint_UpdateSet, tMisContractPoint_UpdateWhere));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractPoint">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractPointVo tMisContractPoint)
{
return(access.Edit(tMisContractPoint));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisContractPointVo tMisContractPoint)
{
return(access.Create(tMisContractPoint));
}
protected void btnExport_QY_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
TMisContractVo objItems = new TMisContractVo();
string strWorkContent = "";
if (!String.IsNullOrEmpty(task_id))
{
objItems.ID = task_id;
}
dt = new TMisContractLogic().GetExportInforData(objItems);
FileStream file = new FileStream(HttpContext.Current.Server.MapPath("TempFile/QY/ContractInforSheet.xls"), FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
//插入委托书单号
sheet.GetRow(2).GetCell(6).SetCellValue("No:" + dt.Rows[0]["CONTRACT_CODE"].ToString());
sheet.GetRow(4).GetCell(2).SetCellValue(dt.Rows[0]["COMPANY_NAME"].ToString()); //委托单位
sheet.GetRow(4).GetCell(5).SetCellValue(dt.Rows[0]["CONTACT_NAME"].ToString()); //联系人
sheet.GetRow(4).GetCell(8).SetCellValue(dt.Rows[0]["PHONE"].ToString()); //联系电话
sheet.GetRow(5).GetCell(2).SetCellValue(dt.Rows[0]["CONTACT_ADDRESS"].ToString()); //地址
sheet.GetRow(5).GetCell(5).SetCellValue(dt.Rows[0]["POST"].ToString()); //邮编
sheet.GetRow(9).GetCell(2).SetCellValue(dt.Rows[0]["TESTED_COMPANY_NAME"].ToString()); //受检单位
sheet.GetRow(9).GetCell(4).SetCellValue(dt.Rows[0]["TESTED_PHONE"].ToString()); //联系电话
sheet.GetRow(9).GetCell(8).SetCellValue(dt.Rows[0]["TESTED_CONTACT_ADDRESS"].ToString()); //地址
sheet.GetRow(9).GetCell(6).SetCellValue(dt.Rows[0]["TESTED_POST"].ToString()); //邮编
DataTable dtDict = PageBase.getDictList("RPT_WAY");
DataTable dtSampleSource = PageBase.getDictList("SAMPLE_SOURCE");
string strWay = "", strSampleWay = "";;
if (dtDict != null)
{
foreach (DataRow dr in dtDict.Rows)
{
strWay += dr["DICT_TEXT"].ToString();
if (dr["DICT_CODE"].ToString() == dt.Rows[0]["RPT_WAY"].ToString())
{
strWay += "■ ";
}
else
{
strWay += "□ ";
}
}
}
if (dtSampleSource != null)
{
foreach (DataRow dr in dtSampleSource.Rows)
{
strSampleWay += dr["DICT_TEXT"].ToString();
if (dr["DICT_TEXT"].ToString() == dt.Rows[0]["SAMPLE_SOURCE"].ToString())
{
strSampleWay += "■ ";
}
else
{
strSampleWay += "□ ";
}
}
}
sheet.GetRow(5).GetCell(8).SetCellValue(strWay); //领取方式
sheet.GetRow(6).GetCell(2).SetCellValue(strSampleWay); //监测类型
sheet.GetRow(7).GetCell(2).SetCellValue(dt.Rows[0]["TEST_PURPOSE"].ToString()); //监测目的
sheet.GetRow(8).GetCell(2).SetCellValue(dt.Rows[0]["PROVIDE_DATA"].ToString()); //提供资料
sheet.GetRow(10).GetCell(2).SetCellValue(dt.Rows[0]["OTHER_ASKING"].ToString()); //其他要求
sheet.GetRow(15).GetCell(1).SetCellValue(dt.Rows[0]["MONITOR_ACCORDING"].ToString()); //监测依据
sheet.GetRow(20).GetCell(1).SetCellValue(dt.Rows[0]["REMARK2"].ToString()); //备注
string strExplain = @"1.是否有分包：□是[□电话确认；□其它： ] □否
是否使用非标准方法： □是 □否
2.监测收费参照广东省物价局粤价函[1996]64号文规定执行。委托单位到本站办公室（603室）领取《清远市非税收入缴款通知书》限期到通知书列明的银行所属任何一个网点缴监测费{0}元（{1}），到颁行缴款后应将盖有银行收讫章的广东省非税收入（电子）票据执收单位联送回给本站综合室。
3.本站在确认已缴监测费用和委托方提供了必要的监测条件后60个工作日内完成监测。";
string strBUDGET = dt.Rows[0]["BUDGET"].ToString() == "" ? "0" : dt.Rows[0]["BUDGET"].ToString();
strExplain = string.Format(strExplain, strBUDGET, DaXie(strBUDGET));
sheet.GetRow(18).GetCell(1).SetCellValue(strExplain);
//监测内容
string[] strMonitroTypeArr = dt.Rows[0]["TEST_TYPES"].ToString().Split(';');
if (dt.Rows[0]["SAMPLE_SOURCE"].ToString() == "送样")
{
//strWorkContent += "地表水、地下水(送样)\n";
int intLen = strMonitroTypeArr.Length;
int INTSHOWLEN = 0;
foreach (string strMonitor in strMonitroTypeArr)
{
INTSHOWLEN++;
strWorkContent += GetMonitorName(strMonitor) + "、";
if (INTSHOWLEN == intLen - 1)
{
strWorkContent += "(送样)\n";
}
}
}
//获取当前监测点信息
TMisContractPointVo ContractPointVo = new TMisContractPointVo();
ContractPointVo.CONTRACT_ID = task_id;
ContractPointVo.IS_DEL = "0";
DataTable dtPoint = new TMisContractPointLogic().SelectByTable(ContractPointVo);
string strOutValuePoint = "", strOutValuePointItems = "";
if (strMonitroTypeArr.Length > 0)
{
foreach (string strMonitor in strMonitroTypeArr)
{
string strMonitorName = "", strPointName = "";
DataRow[] drPoint = dtPoint.Select("MONITOR_ID='" + strMonitor + "'");
if (drPoint.Length > 0)
{
foreach (DataRow drrPoint in drPoint)
{
string strPointNameForItems = "", strPointItems = "";
strMonitorName = GetMonitorName(strMonitor) + "：";
strPointName += drrPoint["POINT_NAME"].ToString() + "、";
//获取当前点位的监测项目
TMisContractPointitemVo ContractPointitemVo = new TMisContractPointitemVo();
ContractPointitemVo.CONTRACT_POINT_ID = drrPoint["ID"].ToString();
DataTable dtPointItems = new TMisContractPointitemLogic().GetItemsForPoint(ContractPointitemVo);
if (dtPointItems.Rows.Count > 0)
{
foreach (DataRow drItems in dtPointItems.Rows)
{
strPointNameForItems = strMonitorName.Substring(0, strMonitorName.Length - 1) + drrPoint["POINT_NAME"] + "(" + (drrPoint["SAMPLE_DAY"].ToString() == "" ? "1" : drrPoint["SAMPLE_DAY"].ToString()) + "天" + (drrPoint["SAMPLE_FREQ"].ToString() == "" ? "1" : drrPoint["SAMPLE_FREQ"].ToString()) + "次):";
strPointItems += drItems["ITEM_NAME"].ToString() + "、";
}
strOutValuePointItems += strPointNameForItems + strPointItems.Substring(0, strPointItems.Length - 1) + "；\n";
}
}
//获取输出监测类型监测点位信息
strOutValuePoint += strMonitorName + strPointName.Substring(0, strPointName.Length - 1) + "；\n";
}
}
}
strWorkContent += "监测点位：\n" + strOutValuePoint;
strWorkContent += "监测因子与频次：\n" + strOutValuePointItems;
sheet.GetRow(12).GetCell(1).SetCellValue(strWorkContent);
using (MemoryStream stream = new MemoryStream())
{
hssfworkbook.Write(stream);
HttpContext curContext = HttpContext.Current;
// 设置编码和附件格式
curContext.Response.ContentType = "application/vnd.ms-excel";
curContext.Response.ContentEncoding = Encoding.UTF8;
curContext.Response.Charset = "";
curContext.Response.AppendHeader("Content-Disposition",
"attachment;filename=" + HttpUtility.UrlEncode("委托监测协议书-" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls", Encoding.UTF8));
curContext.Response.BinaryWrite(stream.GetBuffer());
curContext.Response.End();
}
}
/// <summary>
/// 创建原因：取指定委托书尚未预约的点位个数
/// 创建人：胡方扬
/// 创建日期：2013-07-04
/// </summary>
/// <param name="strPointId"></param>
/// <returns></returns>
public int GetContractPointCondtionCount(TMisContractPointVo tMisContractPoint)
{
return(access.GetContractPointCondtionCount(tMisContractPoint));
}
