/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisContractSamplePlan">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisContractSamplePlanVo tMisContractSamplePlan, int iIndex, int iCount)
{
string strSQL = " select * from T_MIS_CONTRACT_SAMPLE_PLAN {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tMisContractSamplePlan));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractSamplePlan">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisContractSamplePlan, TMisContractSamplePlanVo.T_MIS_CONTRACT_SAMPLE_PLAN_TABLE);
strSQL += string.Format(" where ID='{0}' ", tMisContractSamplePlan.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractSamplePlan_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisContractSamplePlan_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractSamplePlanVo tMisContractSamplePlan_UpdateSet, TMisContractSamplePlanVo tMisContractSamplePlan_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tMisContractSamplePlan_UpdateSet, TMisContractSamplePlanVo.T_MIS_CONTRACT_SAMPLE_PLAN_TABLE);
strSQL += this.BuildWhereStatement(tMisContractSamplePlan_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 自送样流程结束自动插入采样计划数据
/// </summary>
/// <param name="task_id"></param>
/// <param name="strFreq"></param>
/// <returns></returns>
public bool CreateSamplePlan(string task_id, string strFreq)
{
ArrayList arrVo = new ArrayList();
int IntFreq = 0;
IntFreq = Convert.ToInt32(strFreq);
TMisContractSamplePlanVo objItems = new TMisContractSamplePlanVo();
if (IntFreq > 0)
{
for (int i = 0; i < IntFreq; i++)
{
objItems.ID = GetSerialNumber("t_mis_contract_SamplePlanId");
objItems.CONTRACT_ID = task_id;
objItems.FREQ = strFreq;
objItems.IF_PLAN = "0";
objItems.NUM = (i + 1).ToString();
string strSQL = String.Format(" INSERT INTO T_MIS_CONTRACT_SAMPLE_PLAN(ID,CONTRACT_ID,FREQ,NUM,IF_PLAN) VALUES('{0}','{1}','{2}','{3}','{4}')", objItems.ID, objItems.CONTRACT_ID, objItems.FREQ, objItems.NUM, objItems.IF_PLAN);
arrVo.Add(strSQL);
strSQL = String.Format(" UPDATE T_MIS_CONTRACT_SAMPLE SET SAMPLE_PLAN_ID='{0}' WHERE CONTRACT_ID='{1}'", objItems.ID, task_id);
arrVo.Add(strSQL);
}
}
return(SqlHelper.ExecuteSQLByTransaction(arrVo));
}
/// <summary>
/// 根据对象构造条件语句
/// </summary>
/// <param name="tMisContractSamplePlan"></param>
/// <returns></returns>
public string BuildWhereStatement(TMisContractSamplePlanVo tMisContractSamplePlan)
{
StringBuilder strWhereStatement = new StringBuilder(" Where 1=1 ");
if (null != tMisContractSamplePlan)
{
//ID
if (!String.IsNullOrEmpty(tMisContractSamplePlan.ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND ID = '{0}'", tMisContractSamplePlan.ID.ToString()));
}
//委托书ID
if (!String.IsNullOrEmpty(tMisContractSamplePlan.CONTRACT_ID.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND CONTRACT_ID = '{0}'", tMisContractSamplePlan.CONTRACT_ID.ToString()));
}
//监测频次
if (!String.IsNullOrEmpty(tMisContractSamplePlan.FREQ.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND FREQ = '{0}'", tMisContractSamplePlan.FREQ.ToString()));
}
//执行序号
if (!String.IsNullOrEmpty(tMisContractSamplePlan.NUM.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND NUM = '{0}'", tMisContractSamplePlan.NUM.ToString()));
}
//是否已预约
if (!String.IsNullOrEmpty(tMisContractSamplePlan.IF_PLAN.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND IF_PLAN = '{0}'", tMisContractSamplePlan.IF_PLAN.ToString()));
}
//备注1
if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK1.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK1 = '{0}'", tMisContractSamplePlan.REMARK1.ToString()));
}
//备注2
if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK2.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK2 = '{0}'", tMisContractSamplePlan.REMARK2.ToString()));
}
//备注3
if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK3.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK3 = '{0}'", tMisContractSamplePlan.REMARK3.ToString()));
}
//备注4
if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK4.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK4 = '{0}'", tMisContractSamplePlan.REMARK4.ToString()));
}
//备注5
if (!String.IsNullOrEmpty(tMisContractSamplePlan.REMARK5.ToString().Trim()))
{
strWhereStatement.Append(string.Format(" AND REMARK5 = '{0}'", tMisContractSamplePlan.REMARK5.ToString()));
}
}
return(strWhereStatement.ToString());
}
/// <summary>
/// 获取自送样计划监测类别 胡方扬 2012-12-29
/// </summary>
/// <param name="tMisContractSamplePlan"></param>
/// <returns></returns>
public DataTable GetSamplePlanMonitor(TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = String.Format("SELECT MONITOR_ID FROM dbo.T_MIS_CONTRACT_SAMPLE A " +
" INNER JOIN dbo.T_MIS_CONTRACT_SAMPLE_PLAN B ON B.ID=A.SAMPLE_PLAN_ID " +
" WHERE B.ID='{0}' GROUP BY A.MONITOR_ID", tMisContractSamplePlan.ID);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = "delete from T_MIS_CONTRACT_SAMPLE_PLAN ";
strSQL += this.BuildWhereStatement(tMisContractSamplePlan);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 获取自送样计划样品监测项目 胡方扬 2012-12-29
/// </summary>
/// <param name="tMisContractSamplePlan"></param>
/// <returns></returns>
public DataTable GetSamplePlanItems(TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = String.Format("SELECT " +
" A.ID AS SAMPLE_ID,A.CONTRACT_ID,A.MONITOR_ID,A.SAMPLE_TYPE,A.SAMPLE_NAME,A.SAMPLE_COUNT, " +
" B.ID AS PLAN_ID,B.FREQ,B.NUM,B.IF_PLAN," +
" C.ID AS PLAN_ITEM_ID,C.ITEM_ID," +
" D.ITEM_NAME,E.MONITOR_TYPE_NAME" +
" FROM dbo.T_MIS_CONTRACT_SAMPLE A" +
" LEFT JOIN dbo.T_MIS_CONTRACT_SAMPLE_PLAN B ON B.ID=A.SAMPLE_PLAN_ID " +
" LEFT JOIN dbo.T_MIS_CONTRACT_SAMPLEITEM C ON C.CONTRACT_SAMPLE_ID=A.ID" +
" LEFT JOIN dbo.T_BASE_ITEM_INFO D ON D.ID=C.ITEM_ID" +
" LEFT JOIN dbo.T_BASE_MONITOR_TYPE_INFO E ON E.ID=A.MONITOR_ID" +
" WHERE B.ID='{0}'", tMisContractSamplePlan.ID);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 自送样插入采样计划数据
/// </summary>
/// <param name="task_id"></param>
/// <param name="strFreq"></param>
/// <returns></returns>
public bool CreateSamplePlan(TMisContractSamplePlanVo tMisContractSamplePlan, string strCompany_Name)
{
ArrayList arrVo = new ArrayList();
int IntFreq = 0;
//string sql = "select ID from T_BASE_COMPANY_INFO Where 1=1 AND IS_DEL = '0' and Company_Name ='" + strCompany_Name + "'";
//strNew_id = SqlHelper.ExecuteScalar(sql).ToString();
if (!String.IsNullOrEmpty(tMisContractSamplePlan.FREQ))
{
IntFreq = Convert.ToInt32(tMisContractSamplePlan.FREQ);
if (IntFreq > 0)
{
for (int i = 0; i < IntFreq; i++)
{
tMisContractSamplePlan.NUM = (i + 1).ToString();
string strSQL = String.Format(" INSERT INTO T_MIS_CONTRACT_SAMPLE_PLAN(ID,CONTRACT_ID,FREQ,NUM,IF_PLAN) VALUES('{0}','{1}','{2}','{3}','{4}')", tMisContractSamplePlan.ID, tMisContractSamplePlan.CONTRACT_ID, tMisContractSamplePlan.FREQ, tMisContractSamplePlan.NUM, tMisContractSamplePlan.IF_PLAN);
arrVo.Add(strSQL);
}
}
}
return(SqlHelper.ExecuteSQLByTransaction(arrVo));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractSamplePlan">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.Edit(tMisContractSamplePlan));
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.Create(tMisContractSamplePlan));
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisContractSamplePlan"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.SelectByTable(tMisContractSamplePlan));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisContractSamplePlan">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisContractSamplePlanVo> SelectByObject(TMisContractSamplePlanVo tMisContractSamplePlan, int iIndex, int iCount)
{
return(access.SelectByObject(tMisContractSamplePlan, iIndex, iCount));
}
public DataTable GetSamplePlanMonitor(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.GetSamplePlanMonitor(tMisContractSamplePlan));
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tMisContractSamplePlan">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TMisContractSamplePlanVo> SelectByObject(TMisContractSamplePlanVo tMisContractSamplePlan, int iIndex, int iCount)
{
string strSQL = String.Format("select * from T_MIS_CONTRACT_SAMPLE_PLAN " + this.BuildWhereStatement(tMisContractSamplePlan));
return(SqlHelper.ExecuteObjectList(tMisContractSamplePlan, BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisContractSamplePlan">对象条件</param>
/// <returns>对象</returns>
public TMisContractSamplePlanVo Details(TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = String.Format("select * from T_MIS_CONTRACT_SAMPLE_PLAN " + this.BuildWhereStatement(tMisContractSamplePlan));
return(SqlHelper.ExecuteObject(new TMisContractSamplePlanVo(), strSQL));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisContractSamplePlan">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = "select Count(*) from T_MIS_CONTRACT_SAMPLE_PLAN " + this.BuildWhereStatement(tMisContractSamplePlan);
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tMisContractSamplePlan_UpdateSet">UpdateSet用户对象</param>
/// <param name="tMisContractSamplePlan_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TMisContractSamplePlanVo tMisContractSamplePlan_UpdateSet, TMisContractSamplePlanVo tMisContractSamplePlan_UpdateWhere)
{
return(access.Edit(tMisContractSamplePlan_UpdateSet, tMisContractSamplePlan_UpdateWhere));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.Delete(tMisContractSamplePlan));
}
/// <summary>
/// 自送样插入采样计划数据
/// </summary>
/// <param name="task_id"></param>
/// <param name="strFreq"></param>
/// <returns></returns>
public bool CreateSamplePlan(TMisContractSamplePlanVo tMisContractSamplePlan, string strCompany_Name)
{
return(access.CreateSamplePlan(tMisContractSamplePlan, strCompany_Name));
}
/// <summary>
/// 获取自送样计划样品监测项目 胡方扬 2012-12-29
/// </summary>
/// <param name="tMisContractSamplePlan"></param>
/// <returns></returns>
public DataTable GetSamplePlanItems(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.GetSamplePlanItems(tMisContractSamplePlan));
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tMisContractSamplePlan">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.GetSelectResultCount(tMisContractSamplePlan));
}
public TMisContractSamplePlanLogic(TMisContractSamplePlanVo _tMisContractSamplePlan)
{
tMisContractSamplePlan = _tMisContractSamplePlan;
access = new TMisContractSamplePlanAccess();
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tMisContractSamplePlan"></param>
/// <returns></returns>
public DataTable SelectByTable(TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = "select * from T_MIS_CONTRACT_SAMPLE_PLAN " + this.BuildWhereStatement(tMisContractSamplePlan);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tMisContractSamplePlan">对象条件</param>
/// <returns>对象</returns>
public TMisContractSamplePlanVo Details(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.Details(tMisContractSamplePlan));
}
/// <summary>
/// 获取自送样采样计划
/// </summary>
/// <param name="tMisContract"></param>
/// <returns></returns>
public DataTable GetContractInforUnionSamplePlan(TMisContractVo tMisContract, TMisContractSamplePlanVo tMisContractSamplePlan)
{
string strSQL = "SELECT A.ID,A.CONTRACT_CODE,A.CONTRACT_YEAR,A.PROJECT_NAME,A.CONTRACT_TYPE,A.TEST_TYPES,A.CLIENT_COMPANY_ID,A.TESTED_COMPANY_ID,A.ASKING_DATE,A.SAMPLE_FREQ,A.PROJECT_ID,A.SAMPLE_SOURCE," +
" B.ID AS SAMPLE_ID,B.FREQ,B.NUM AS SAMPLENUM,B.IF_PLAN,C.COMPANY_NAME,C.CONTACT_NAME,C.PHONE,D.ID AS TASK_ID,D.TICKET_NUM,D.ASKING_DATE,E.ID AS SUBTASK_ID,F.COMPANY_NAME AS CLIENT_COMPANY_NAME,F.CONTACT_NAME AS CLIENT_CONTACT_NAME,F.PHONE AS CLIENT_PNONE,G.ID AS REPORT_ID,G.REPORT_CODE FROM T_MIS_CONTRACT A " +
" INNER JOIN T_MIS_CONTRACT_SAMPLE_PLAN B ON B.CONTRACT_ID=A.ID" +
" INNER JOIN T_MIS_CONTRACT_COMPANY C ON C.ID=A.CLIENT_COMPANY_ID" +
" INNER JOIN dbo.T_MIS_MONITOR_TASK D ON D.CONTRACT_ID=B.CONTRACT_ID AND D.PLAN_ID=B.ID" +
" INNER JOIN dbo.T_MIS_MONITOR_SUBTASK E ON E.TASK_ID=D.ID" +
" INNER JOIN T_MIS_CONTRACT_COMPANY F ON F.ID=A.CLIENT_COMPANY_ID " +
" INNER JOIN dbo.T_MIS_MONITOR_REPORT G ON G.TASK_ID=D.ID " +
" WHERE 1=1";
if (!String.IsNullOrEmpty(tMisContract.ID))
{
strSQL += String.Format(" AND A.ID='{0}'", tMisContract.ID);
}
if (!String.IsNullOrEmpty(tMisContract.BOOKTYPE))
{
strSQL += String.Format(" AND A.BOOKTYPE='{0}' ", tMisContract.BOOKTYPE);
}
if (!String.IsNullOrEmpty(tMisContractSamplePlan.IF_PLAN))
{
strSQL += String.Format(" AND B.IF_PLAN='{0}' ", tMisContractSamplePlan.IF_PLAN);
}
if (!String.IsNullOrEmpty(tMisContractSamplePlan.ID))
{
strSQL += String.Format(" AND B.ID='{0}' ", tMisContractSamplePlan.ID);
}
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tMisContractSamplePlan">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TMisContractSamplePlanVo tMisContractSamplePlan, int iIndex, int iCount)
{
return(access.SelectByTable(tMisContractSamplePlan, iIndex, iCount));
}
protected void btnExport_Click(object sender, EventArgs e)
{
FileStream file = new FileStream(HttpContext.Current.Server.MapPath("../Monitor/sampling/template/WorkTaskSheetQY.xls"), FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
string strTaskType = "", strMonitorList = "", strWorkContent = "";
TMisMonitorTaskVo objTask = new TMisMonitorTaskVo();
objTask.ID = strWorkTask_Id;
TMisContractSamplePlanVo objPlan = new TMisContractSamplePlanVo();
objPlan.ID = strPlanId;
DataTable dt = new TMisMonitorTaskLogic().GetContractInforUnionSamplePlan(objTask, objPlan);
//插入委托书单号
if (dt.Rows.Count > 0)
{
sheet.GetRow(4).GetCell(1).SetCellValue(dt.Rows[0]["TICKET_NUM"].ToString());
sheet.GetRow(4).GetCell(6).SetCellValue(dt.Rows[0]["REPORT_CODE"].ToString());
strTaskType = getDictName(dt.Rows[0]["CONTRACT_TYPE"].ToString(), "Contract_Type");
sheet.GetRow(5).GetCell(1).SetCellValue(strTaskType + "任务");
sheet.GetRow(5).GetCell(7).SetCellValue(dt.Rows[0]["CONTRACT_CODE"].ToString());
string[] strMonitroTypeArr = dt.Rows[0]["TEST_TYPE"].ToString().Split(';');
//foreach (string str in strMonitroTypeArr)
//{
// string strMonitor = "";
// strMonitor = GetMonitorName(str);
// strMonitorList += (strMonitor == "水和废水" ? "废水" : (strMonitor == "气和废气" ? "废气" : strMonitor)) + "、";
//}
//strMonitorList = strMonitorList.Substring(0, strMonitorList.Length - 1);
sheet.GetRow(6).GetCell(1).SetCellValue(dt.Rows[0]["CLIENT_COMPANY_NAME"].ToString());
TMisContractPointFreqVo objItems = new TMisContractPointFreqVo();
objItems.CONTRACT_ID = "";
DataTable dts = new TMisContractPointFreqLogic().GetPointMonitorInforForPlan(objItems, dt.Rows[0]["ID"].ToString());
if (dts.Rows.Count > 0)
{
strMonitorList = dts.Rows[0][1].ToString();
}
sheet.GetRow(7).GetCell(1).SetCellValue(strMonitorList);
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)
{
strWorkContent = strWorkContent.Substring(0, strWorkContent.Length - 1);
strWorkContent += "(送样)\n";
}
}
}
DataTable dtPoint = GetSampleDateTable();
string strPoint = "", strPoint_Name = "", strItems = "", strPointItems = "";
int IS_SAMPLEDEPT = 0; //是否存在现场监测项目
int IS_CERTIFICATE = 0; //是否存在实验室监测项目
if (dtPoint.Rows.Count > 0)
{
foreach (DataRow dr in dtPoint.Rows)
{
strPoint += dr["SAMPLE_NAME"].ToString() + "、";
DataTable dtPointItems = GetSampleItemsDateTable(dr["ID"].ToString());
if (dtPointItems.Rows.Count > 0)
{
strPoint_Name = dr["SAMPLE_NAME"].ToString() + "：";
strItems = "";
foreach (DataRow drr in dtPointItems.Rows)
{
strItems += drr["ITEM_NAME"].ToString() + "、";
if (drr["IS_SAMPLEDEPT"].ToString() == "是")
{
IS_SAMPLEDEPT = 1;
}
if (drr["LAB_CERTIFICATE"].ToString() == "是")
{
IS_CERTIFICATE = 1;
}
}
}
if (!String.IsNullOrEmpty(strItems))
{
strItems = strItems.Substring(0, strItems.Length - 1);
}
strPointItems += strPoint_Name + strItems + "；";
}
if (!String.IsNullOrEmpty(strPoint))
{
strPoint = strPoint.Substring(0, strPoint.Length - 1);
}
}
strWorkContent += "监测样品：" + strPoint + "\n";
strWorkContent += "监测因子与频次：\n" + strPointItems;
sheet.GetRow(9).GetCell(1).SetCellValue(strWorkContent);
//接收科室
string strJSKS = "";
if (IS_SAMPLEDEPT == 1)
{
strJSKS += "现场室、";
}
if (IS_CERTIFICATE == 1)
{
strJSKS += "实验室、";
}
sheet.GetRow(8).GetCell(1).SetCellValue(strJSKS.TrimEnd('、'));
string strLinkPerple = "";
//if (dt.Rows[0]["CONTRACT_TYPE"].ToString() == "02" || dt.Rows[0]["CONTRACT_TYPE"].ToString() == "03")//应急或者管理类的 strMonitorList
if (strMonitorList == "02" || strMonitorList == "03")//应急或者管理类的 strMonitorList
{
strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n";
strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
strLinkPerple += "报告编写人：韩永博 \n";
}
else
{
#region//暂不用代码
//string[] strMonitroType = dt.Rows[0]["TEST_TYPE"].ToString().Split(';');
//foreach (string strs in strMonitroType)
//{
// string strMonitors = "";
// strMonitors = GetMonitorName(strs);
// if (strMonitors == "水和废水")
// {
// Monitor = "水";
// }
// else if (strMonitors == "气和废气")
// {
// Monitor = "气";
// }
// else if (strMonitors == "固废和土壤")
// {
// Monitor = "固体";
// }
// else if (strMonitors.Contains("噪声"))
// {
// Monitor = "噪声";
// }
// Monitor = Monitor + "、";
//}
//Monitor = Monitor.Substring(0, Monitor.Length - 1);
#endregion
if (strMonitorList == "水" || strMonitorList == "固体")
{
strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n";
strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
strLinkPerple += "报告编写人：韩永博 \n";
}
else if (strMonitorList == "气" || strMonitorList == "噪声")
{
strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n";
strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
strLinkPerple += "报告编写人：马振芳\n";
}
else if (strMonitorList == "水、气、声、固体")
{
strLinkPerple += "联系人：" + dt.Rows[0]["CONTACT_NAME"].ToString() + " \n";
strLinkPerple += "联系电话：" + dt.Rows[0]["PHONE"].ToString() + "\n";
strLinkPerple += "报告编写人：王志远\n";
}
}
sheet.GetRow(10).GetCell(1).SetCellValue(strLinkPerple);
if (!String.IsNullOrEmpty(dt.Rows[0]["ASKING_DATE"].ToString()))
{
sheet.GetRow(11).GetCell(1).SetCellValue(DateTime.Parse(dt.Rows[0]["ASKING_DATE"].ToString()).ToString("yyyy-MM-dd"));
}
//sheet.GetRow(11).GetCell(3).SetCellValue(LogInfo.UserInfo.REAL_NAME);
sheet.GetRow(11).GetCell(6).SetCellValue(DateTime.Now.ToString("yyyy-MM-dd"));
}
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>
/// 获取自送样采样计划
/// </summary>
/// <param name="tMisContract"></param>
/// <returns></returns>
public DataTable GetContractInforUnionSamplePlan(TMisMonitorTaskVo tMisTaskContract, TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.GetContractInforUnionSamplePlan(tMisTaskContract, tMisContractSamplePlan));
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tMisContractSamplePlan">对象</param>
/// <returns></returns>
public TMisContractSamplePlanVo SelectByObject(TMisContractSamplePlanVo tMisContractSamplePlan)
{
return(access.SelectByObject(tMisContractSamplePlan));
}
