public static string deletePoint(string strValue)
{
TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo();
objPoint.ID = strValue;
objPoint.IS_DEL = "1";
bool isSuccess = new TBaseCompanyPointLogic().Edit(objPoint);
TBaseAttrbuteValueVo objAttrValueDelWhere = new TBaseAttrbuteValueVo();
objAttrValueDelWhere.OBJECT_ID = strValue;
objAttrValueDelWhere.IS_DEL = "0";
TBaseAttrbuteValueVo objAttrValueDelSet = new TBaseAttrbuteValueVo();
objAttrValueDelSet.IS_DEL = "1";
if (new TBaseAttrbuteValueLogic().Edit(objAttrValueDelSet, objAttrValueDelWhere))
{
new PageBase().WriteLog("删除点位属性", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除对象ID" + objPoint.ID + "的点位属性成功");
}
if (isSuccess)
{
new PageBase().WriteLog("删除点位", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除点位" + objPoint.ID + "成功");
}
return(isSuccess == true ? "1" : "0");
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseCompanyPoint">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseCompanyPointVo tBaseCompanyPoint, int iIndex, int iCount)
{
string strSQL = " select * from T_BASE_COMPANY_POINT {0} order by MONITOR_ID,NUM";
strSQL = String.Format(strSQL, BuildWhereStatement(tBaseCompanyPoint));
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseCompanyPoint_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseCompanyPoint_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseCompanyPointVo tBaseCompanyPoint_UpdateSet, TBaseCompanyPointVo tBaseCompanyPoint_UpdateWhere)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseCompanyPoint_UpdateSet, TBaseCompanyPointVo.T_BASE_COMPANY_POINT_TABLE);
strSQL += this.BuildWhereStatement(tBaseCompanyPoint_UpdateWhere);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
//获取点位信息
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 = TBaseCompanyPointVo.NUM_FIELD;
}
string strCompanyID = Request.Params["comId"];
if (strCompanyID == null || strCompanyID.Length == 0)
{
return("");
}
TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo();
objPoint.IS_DEL = "0";
objPoint.COMPANY_ID = strCompanyID;
objPoint.SORT_FIELD = strSortname;
objPoint.SORT_TYPE = strSortorder;
DataTable dt = new TBaseCompanyPointLogic().SelectByTable(objPoint, intPageIndex, intPageSize);
int intTotalCount = new TBaseCompanyPointLogic().GetSelectResultCount(objPoint);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseCompanyPoint">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseCompanyPointVo tBaseCompanyPoint)
{
string strSQL = SqlHelper.BuildUpdateExpress(tBaseCompanyPoint, TBaseCompanyPointVo.T_BASE_COMPANY_POINT_TABLE);
strSQL += string.Format(" where ID='{0}' ", tBaseCompanyPoint.ID);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseCompanyPointVo tBaseCompanyPoint)
{
string strSQL = "delete from T_BASE_COMPANY_POINT ";
strSQL += this.BuildWhereStatement(tBaseCompanyPoint);
return(SqlHelper.ExecuteNonQuery(CommandType.Text, strSQL) > 0 ? true : false);
}
public int SelectByTableForPlanCount(TBaseCompanyPointVo tBaseCompanyPoint, string strPointIdList)
{
string strPointId = strPointIdList.Replace(";", "','");
string strSQL = "select Count(*) from T_BASE_COMPANY_POINT " + this.BuildWhereStatement(tBaseCompanyPoint);
if (!String.IsNullOrEmpty(strPointId))
{
strSQL += String.Format(" AND ID NOT IN('{0}')", strPointId);
}
return(Convert.ToInt32(SqlHelper.ExecuteScalar(strSQL)));
}
public DataTable SelectByTableForPlan(TBaseCompanyPointVo tBaseCompanyPoint, string strPointIdList, int iIndex, int iCount)
{
string strPointId = strPointIdList.Replace(";", "','");
string strSQL = " select * from T_BASE_COMPANY_POINT {0} ";
strSQL = String.Format(strSQL, BuildWhereStatement(tBaseCompanyPoint));
if (!String.IsNullOrEmpty(strPointId))
{
strSQL += String.Format(" AND ID NOT IN('{0}')", strPointId);
}
return(SqlHelper.ExecuteDataTable(BuildPagerExpress(strSQL, iIndex, iCount)));
}
//获取点位信息
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 = TBaseCompanyPointVo.NUM_FIELD;
}
string strCompanyID = Request.Params["CompanyID"];
if (strCompanyID.Length == 0)
{
return("");
}
TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo();
objPoint.IS_DEL = "0";
objPoint.COMPANY_ID = strCompanyID;
objPoint.SORT_FIELD = strSortname;
objPoint.SORT_TYPE = strSortorder;
DataTable dt = new TBaseCompanyPointLogic().SelectByTable(objPoint, intPageIndex, intPageSize);
for (int i = 0; i < dt.Rows.Count; i++)
{
TBaseMonitorTypeInfoVo MonitorTypeInfoVo = new TBaseMonitorTypeInfoVo();
MonitorTypeInfoVo = new TBaseMonitorTypeInfoLogic().Details(dt.Rows[i]["MONITOR_ID"].ToString());
dt.Rows[i]["REMARK1"] = MonitorTypeInfoVo.REMARK1;
}
int intTotalCount = new TBaseCompanyPointLogic().GetSelectResultCount(objPoint);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
/// <summary>
/// 对象添加
/// </summary>
/// <param name="sysRole">对象</param>
/// <returns>是否成功</returns>
public bool Create(TBaseCompanyPointVo tBaseCompanyPoint)
{
return(access.Create(tBaseCompanyPoint));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseCompanyPoint">用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseCompanyPointVo tBaseCompanyPoint)
{
return(access.Edit(tBaseCompanyPoint));
}
public static string SaveCompanyPointDataEx(string strPointID, string strCompanyID, string strPOINT_NAME, string strMONITOR_ID, string strPOINT_TYPE, string strDYNAMIC_ATTRIBUTE_ID, string strSAMPLE_DAY, string strSAMPLE_FREQ, string strFREQ,
string strCREATE_DATE, string strADDRESS, string strLONGITUDE, string strLATITUDE, string strNUM, string strAttribute,
string strNATIONAL_ST_CONDITION_ID, string strLOCAL_ST_CONDITION_ID, string strINDUSTRY_ST_CONDITION_ID)
{
bool isSuccess = true;
string strPointIDs = string.Empty;
string[] strPointNames;
if (strPointID.Length > 0)
{
strPointNames = strPOINT_NAME.Split('|');
}
else
{
strPointNames = strPOINT_NAME.Split('、');
}
for (int j = 0; j < strPointNames.Length; j++)
{
TBaseCompanyPointVo objPoint = new TBaseCompanyPointVo();
objPoint.ID = strPointID.Length > 0 ? strPointID : GetSerialNumber("t_base_company_point_id");
objPoint.IS_DEL = "0";
objPoint.COMPANY_ID = strCompanyID;
objPoint.POINT_NAME = strPointNames[j].ToString();
objPoint.MONITOR_ID = strMONITOR_ID;
objPoint.POINT_TYPE = strPOINT_TYPE;
objPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID;
objPoint.SAMPLE_DAY = strSAMPLE_DAY;
objPoint.SAMPLE_FREQ = strSAMPLE_FREQ;
objPoint.FREQ = "1";
objPoint.CREATE_DATE = strCREATE_DATE;
objPoint.ADDRESS = strADDRESS;
objPoint.LONGITUDE = strLONGITUDE;
objPoint.LATITUDE = strLATITUDE;
objPoint.NUM = strNUM;
objPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID;
objPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID;
objPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID;
if (strPointID.Length > 0)
{
isSuccess = new TBaseCompanyPointLogic().Edit(objPoint);
if (isSuccess)
{
new PageBase().WriteLog("编辑点位", "", new PageBase().LogInfo.UserInfo.USER_NAME + "编辑点位" + objPoint.ID + "成功");
}
}
else
{
isSuccess = new TBaseCompanyPointLogic().Create(objPoint);
if (isSuccess)
{
new PageBase().WriteLog("新增点位", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增点位" + objPoint.ID + "成功");
}
}
strPointIDs += objPoint.ID + "、";
TBaseAttrbuteValueLogic logicAttrValue = new TBaseAttrbuteValueLogic();
//清掉原有动态属性值
TBaseAttrbuteValueVo objAttrValueDelWhere = new TBaseAttrbuteValueVo();
objAttrValueDelWhere.OBJECT_ID = objPoint.ID;
objAttrValueDelWhere.IS_DEL = "0";
TBaseAttrbuteValueVo objAttrValueDelSet = new TBaseAttrbuteValueVo();
objAttrValueDelSet.IS_DEL = "1";
if (logicAttrValue.Edit(objAttrValueDelSet, objAttrValueDelWhere))
{
new PageBase().WriteLog("清掉动态属性值", "", new PageBase().LogInfo.UserInfo.USER_NAME + "清掉对象ID" + objPoint.ID + "的动态属性值成功");
}
//新增动态属性值
if (strAttribute.Length > 0)
{
string[] arrAttribute = strAttribute.Split('-');
for (int i = 0; i < arrAttribute.Length; i++)
{
string[] arrAttrValue = arrAttribute[i].Split('|');
TBaseAttrbuteValueVo objAttrValueAdd = new TBaseAttrbuteValueVo();
objAttrValueAdd.ID = GetSerialNumber("t_base_attribute_value_id");
objAttrValueAdd.IS_DEL = "0";
objAttrValueAdd.OBJECT_TYPE = arrAttrValue[0];
objAttrValueAdd.OBJECT_ID = objPoint.ID;
objAttrValueAdd.ATTRBUTE_CODE = arrAttrValue[1];
objAttrValueAdd.ATTRBUTE_VALUE = arrAttrValue[2];
if (isSuccess = logicAttrValue.Create(objAttrValueAdd))
{
new PageBase().WriteLog("新增动态属性值", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增动态属性值" + objAttrValueAdd.ID + "成功");
}
}
}
}
if (isSuccess)
{
return(strPointIDs.TrimEnd('、'));
}
else
{
return("");
}
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tBaseCompanyPoint"></param>
/// <returns></returns>
public DataTable SelectByTable(TBaseCompanyPointVo tBaseCompanyPoint)
{
string strSQL = "select * from T_BASE_COMPANY_POINT " + this.BuildWhereStatement(tBaseCompanyPoint);
return(SqlHelper.ExecuteDataTable(strSQL));
}
/// <summary>
/// 获取对象DataTable
/// </summary>
/// <param name="tBaseCompanyPoint">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public DataTable SelectByTable(TBaseCompanyPointVo tBaseCompanyPoint, int iIndex, int iCount)
{
return(access.SelectByTable(tBaseCompanyPoint, iIndex, iCount));
}
/// <summary>
/// 对象明细
/// </summary>
/// <param name="tBaseCompanyPoint">对象条件</param>
/// <returns>对象</returns>
public TBaseCompanyPointVo Details(TBaseCompanyPointVo tBaseCompanyPoint)
{
return(access.Details(tBaseCompanyPoint));
}
public TBaseCompanyPointLogic(TBaseCompanyPointVo _tBaseCompanyPoint)
{
tBaseCompanyPoint = _tBaseCompanyPoint;
access = new TBaseCompanyPointAccess();
}
public DataTable SelectByTableForPlan(TBaseCompanyPointVo tBaseCompanyPoint, string strPointIdList, int iIndex, int iCount)
{
return(access.SelectByTableForPlan(tBaseCompanyPoint, strPointIdList, iIndex, iCount));
}
/// <summary>
/// 对象编辑
/// </summary>
/// <param name="tBaseCompanyPoint_UpdateSet">UpdateSet用户对象</param>
/// <param name="tBaseCompanyPoint_UpdateWhere">UpdateWhere用户对象</param>
/// <returns>是否成功</returns>
public bool Edit(TBaseCompanyPointVo tBaseCompanyPoint_UpdateSet, TBaseCompanyPointVo tBaseCompanyPoint_UpdateWhere)
{
return(access.Edit(tBaseCompanyPoint_UpdateSet, tBaseCompanyPoint_UpdateWhere));
}
/// <summary>
/// 对象删除
/// </summary>
/// <param name="Id">ID</param>
/// <returns>是否成功</returns>
public bool Delete(TBaseCompanyPointVo tBaseCompanyPoint)
{
return(access.Delete(tBaseCompanyPoint));
}
public static string SaveDataPoint(string strSubTaskID, string strPointName, string strMonitorID)
{
bool isSuccess = true;
TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo();
objPoint.ID = GetSerialNumber("t_mis_monitor_taskpointId");
objPoint.IS_DEL = "0";
objPoint.SUBTASK_ID = strSubTaskID;
objPoint.POINT_NAME = strPointName;
objPoint.MONITOR_ID = strMonitorID;
objPoint.FREQ = "1";
objPoint.CREATE_DATE = DateTime.Now.ToString();
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubTaskID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
objPoint.TASK_ID = objTask.ID;
//监测任务出现新增排口时，基础资料企业表也要新增
TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo();
objnewPoint.ID = GetSerialNumber("t_base_company_point_id");
objnewPoint.IS_DEL = "0";
objnewPoint.POINT_NAME = strPointName;
objnewPoint.MONITOR_ID = strMonitorID;
objnewPoint.FREQ = "1";
objnewPoint.CREATE_DATE = DateTime.Now.ToString();
TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo();
//objTaskCompany.TASK_ID = objTask.ID; ;
objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID);
objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID;
isSuccess = new TBaseCompanyPointLogic().Create(objnewPoint);
objPoint.POINT_ID = objnewPoint.ID;
isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint);
//增加点位样品信息
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample.ID = GetSerialNumber("MonitorSampleId");
objSample.SUBTASK_ID = strSubTaskID;
objSample.QC_TYPE = "0";
objSample.NOSAMPLE = "0";
objSample.POINT_ID = objPoint.ID;
objSample.SAMPLE_NAME = objPoint.POINT_NAME;
isSuccess = new TMisMonitorSampleInfoLogic().Create(objSample);
//为新增的测点添加监测项目
DataTable dt = new TMisMonitorSubtaskLogic().getItemBySubTaskID(strSubTaskID);
string strItemIDs = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
strItemIDs += dt.Rows[i]["ID"].ToString() + ",";
}
isSuccess = SaveDataItem(strSubTaskID, objSample.ID, strItemIDs.TrimEnd(','), true);
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
public int SelectByTableForPlanCount(TBaseCompanyPointVo tBaseCompanyPoint, string strPointIdList)
{
return(access.SelectByTableForPlanCount(tBaseCompanyPoint, strPointIdList));
}
/// <summary>
/// 判断存在性
/// </summary>
/// <param name="strType"></param>
/// <param name="strItem"></param>
/// <param name="strMethod"></param>
protected bool PointExist(TBaseCompanyPointVo objItemVo)
{
return(new TBaseCompanyPointLogic().GetSelectResultCount(objItemVo) > 0 ? true : false);
}
/// <summary>
/// 获得查询结果总行数，用于分页
/// </summary>
/// <param name="tBaseCompanyPoint">对象</param>
/// <returns>返回行数</returns>
public int GetSelectResultCount(TBaseCompanyPointVo tBaseCompanyPoint)
{
return(access.GetSelectResultCount(tBaseCompanyPoint));
}
protected void ExcelExportIn(string excelFilePath)
{
try
{
#region excel 打开工作簿
FileStream file = new FileStream(excelFilePath, FileMode.Open, FileAccess.Read);
HSSFWorkbook hssfworkbook = new HSSFWorkbook(file);
ISheet mySheet = hssfworkbook.GetSheetAt(0);
#endregion
//选择导入的信息
string strExportIndex = this.SelectExportInfo.SelectedValue;
//定义错误日志
//string strLog = "";
//定义错误数
int ErrorCount = 0;
//定义导入对象数组
ArrayList arrVo = new ArrayList();
if (strExportIndex == "0")//仪器
{
for (int i = 1; ; i++)
{
IRow row = mySheet.GetRow(i);
if (row == null)
{
break;
}
string cell1 = row.GetCell(1) != null?row.GetCell(1).ToString() : ""; //名称
string cell2 = row.GetCell(2) != null?row.GetCell(2).ToString() : ""; //性别
string cell3 = row.GetCell(3) != null?row.GetCell(3).ToString() : ""; //年龄
string cell4 = row.GetCell(4) != null?row.GetCell(4).ToString() : ""; //出生
string cell5 = row.GetCell(5) != null?row.GetCell(5).ToString() : ""; //身份证
string cell6 = row.GetCell(6) != null?row.GetCell(6).ToString() : ""; //政治面貌
string cell7 = row.GetCell(7) != null?row.GetCell(7).ToString() : ""; //学历
string cell8 = row.GetCell(8) != null?row.GetCell(8).ToString() : ""; //专业
string cell9 = row.GetCell(9) != null?row.GetCell(9).ToString() : ""; //职称
string cell10 = row.GetCell(10) != null?row.GetCell(10).ToString() : ""; //城市
string cell11 = row.GetCell(11) != null?row.GetCell(11).ToString() : ""; //单位
string cell12 = row.GetCell(12) != null?row.GetCell(12).ToString() : ""; //参加工作时间
TBaseApparatusInfoVo objvo = new TBaseApparatusInfoVo();
objvo.NAME = cell1.ToString().Replace("\n", "").Replace(" ", ""); //仪器名称
objvo.MODEL = cell2.ToString().Replace("\n", "").Replace(" ", ""); //规格
objvo.SERIAL_NO = cell3.ToString().Replace("\n", "").Replace(" ", ""); //出厂编号
objvo.APPARATUS_PROVIDER = cell4.ToString().Replace("\n", "").Replace(" ", ""); //生产商
objvo.BUY_TIME = cell6.ToString().Replace("\n", "").Replace(" ", ""); //购置时间
objvo.APPARATUS_CODE = cell8.ToString().Replace("\n", "").Replace(" ", ""); //管理编号
objvo.POSITION = cell10.ToString().Replace("\n", "").Replace(" ", ""); //地点
objvo.KEEPER = cell11.ToString().Replace("\n", "").Replace(" ", ""); //保管人
objvo.REMARK1 = cell12.ToString().Replace("\n", "").Replace(" ", ""); //备注
objvo.IS_DEL = "0";
if (cell1.ToString() == "")
{
break;
}
if (!ItemExist(objvo))
{
arrVo.Add(objvo);
}
}
//批量保存数据
if (ErrorCount <= 0)
{
if (new TBaseApparatusInfoLogic().SaveData(arrVo))
{
Alert("导入完成！");
}
}
}
else if (strExportIndex == "1")//点位
{
for (int i = 1; ; i++)
{
IRow row = mySheet.GetRow(i);
if (row == null)
{
break;
}
string cell0 = row.GetCell(0) != null?row.GetCell(0).ToString().Replace("\n", "").Replace(" ", "") : ""; //企业ID
string cell1 = row.GetCell(1) != null?row.GetCell(1).ToString().Replace("\n", "").Replace(" ", "") : ""; //企业名称
string cell2 = row.GetCell(2) != null?row.GetCell(2).ToString().Replace("\n", "").Replace(" ", "") : ""; //点位信息
if (cell2.Length > 0)
{
int intNum = 0; //点位序号
string[] strMonitor = cell2.Split(';'); //监测类别
foreach (string str in strMonitor)
{
string[] strPoint = str.Split(':');//监测类别与点位分隔
//点位信息
string[] strPointInfo = strPoint[1].ToString().Split('、');
foreach (string Point in strPointInfo)
{
//点位信息处理
TBaseCompanyPointVo objvo = new TBaseCompanyPointVo();
intNum++;
objvo.MONITOR_ID = strPoint[0].ToString();
objvo.POINT_NAME = Point;
objvo.POINT_TYPE = "01";
objvo.FREQ = "1";
objvo.COMPANY_ID = cell0.ToString();
objvo.IS_DEL = "0";
objvo.NUM = intNum.ToString();
arrVo.Add(objvo);
}
}
}
if (cell0.ToString() == "")
{
break;
}
}
//批量保存数据
if (ErrorCount <= 0)
{
if (new TBaseCompanyPointLogic().SaveData(arrVo))
{
Alert("导入完成！");
}
}
}
#region excel 关闭 释放资源
System.GC.Collect();
#endregion
}
catch (Exception ex)
{
Alert("<script>alert('未能读取Excel，请稍候再试！" + ex.Message + "')</script>");
}
}
/// <summary>
/// 获取对象List
/// </summary>
/// <param name="tBaseCompanyPoint">对象</param>
/// <param name="iIndex">起始页码</param>
/// <param name="iCount">每页数目</param>
/// <returns>返回结果</returns>
public List <TBaseCompanyPointVo> SelectByObject(TBaseCompanyPointVo tBaseCompanyPoint, int iIndex, int iCount)
{
return(access.SelectByObject(tBaseCompanyPoint, iIndex, iCount));
}
protected void btnImport_Click(object sender, EventArgs e)
{
bool isSuccess = false;
if (this.importFiles.PostedFile.ContentLength <= 0)
{
return;
}
Stream stream = this.importFiles.FileContent;
HSSFWorkbook hssfworkbook = new HSSFWorkbook(stream);
ISheet sheet = hssfworkbook.GetSheet("Sheet1");
string strSql = "";
ArrayList list = new ArrayList();
DataTable dt = RenderFromExcel(sheet, 0);
TBaseCompanyInfoVo CompanyInfoVo = new TBaseCompanyInfoVo();
string strCompanyID = "";
TBaseCompanyPointVo CompanyPointVo = new TBaseCompanyPointVo();
string strCompanyPointID = "";
TBaseCompanyPointItemVo CompanyPointItemVo = new TBaseCompanyPointItemVo();
string strCompanyPointItemID = "";
string[] strArr;
for (int i = 0; i < dt.Rows.Count; i++)
{
strCompanyID = "";
strCompanyPointID = "";
strCompanyPointItemID = "";
CompanyInfoVo = new TBaseCompanyInfoVo();
CompanyInfoVo.COMPANY_NAME = dt.Rows[i][0].ToString().Trim();
CompanyInfoVo.IS_DEL = "0";
CompanyInfoVo = new TBaseCompanyInfoLogic().SelectByObject(CompanyInfoVo);
strCompanyID = CompanyInfoVo.ID;
if (strCompanyID == "")
{
strCompanyID = GetSerialNumber("Company_Id");
CompanyInfoVo.ID = strCompanyID;
CompanyInfoVo.COMPANY_NAME = dt.Rows[i][0].ToString().Trim();
CompanyInfoVo.IS_DEL = "0";
new TBaseCompanyInfoLogic().Create(CompanyInfoVo);
}
CompanyPointVo = new TBaseCompanyPointVo();
CompanyPointVo.COMPANY_ID = strCompanyID;
CompanyPointVo.POINT_NAME = dt.Rows[i][3].ToString().Trim();
CompanyPointVo.MONITOR_ID = dt.Rows[i][4].ToString().Trim();
CompanyPointVo.IS_DEL = "0";
CompanyPointVo = new TBaseCompanyPointLogic().SelectByObject(CompanyPointVo);
strCompanyPointID = CompanyPointVo.ID;
if (strCompanyPointID == "")
{
strCompanyPointID = GetSerialNumber("t_base_company_point_id");
CompanyPointVo.ID = strCompanyPointID;
CompanyPointVo.COMPANY_ID = strCompanyID;
CompanyPointVo.POINT_NAME = dt.Rows[i][3].ToString().Trim();
CompanyPointVo.MONITOR_ID = dt.Rows[i][4].ToString().Trim();
CompanyPointVo.SAMPLE_DAY = dt.Rows[i][1].ToString().Trim();
CompanyPointVo.SAMPLE_FREQ = dt.Rows[i][2].ToString().Trim();
CompanyPointVo.IS_DEL = "0";
new TBaseCompanyPointLogic().Create(CompanyPointVo);
}
else
{
CompanyPointVo.SAMPLE_DAY = dt.Rows[i][1].ToString().Trim();
CompanyPointVo.SAMPLE_FREQ = dt.Rows[i][2].ToString().Trim();
new TBaseCompanyPointLogic().Edit(CompanyPointVo);
}
strArr = dt.Rows[i][5].ToString().Trim().Split(',');
for (int j = 0; j < strArr.Length; j++)
{
strCompanyPointItemID = "";
CompanyPointItemVo = new TBaseCompanyPointItemVo();
CompanyPointItemVo.POINT_ID = strCompanyPointID;
CompanyPointItemVo.ITEM_ID = strArr[j].ToString().Trim();
CompanyPointItemVo.IS_DEL = "0";
CompanyPointItemVo = new TBaseCompanyPointItemLogic().SelectByObject(CompanyPointItemVo);
strCompanyPointItemID = CompanyPointItemVo.ID;
if (strCompanyPointItemID == "")
{
strCompanyPointItemID = GetSerialNumber("t_base_company_point_item_id");
CompanyPointItemVo.ID = strCompanyPointItemID;
CompanyPointItemVo.POINT_ID = strCompanyPointID;
CompanyPointItemVo.ITEM_ID = strArr[j].ToString().Trim();
CompanyPointItemVo.IS_DEL = "0";
new TBaseCompanyPointItemLogic().Create(CompanyPointItemVo);
}
}
}
labMsg.Text = "导入成功!!!!!!!!!!!!!!!!!!";
}
/// <summary>
/// 根据对象获取全部数据，用Table承载
/// 数据量较小时使用【不推荐】
/// </summary>
/// <param name="tBaseCompanyPoint"></param>
/// <returns></returns>
public DataTable SelectByTable(TBaseCompanyPointVo tBaseCompanyPoint)
{
return(access.SelectByTable(tBaseCompanyPoint));
}
public static string SaveItemSplit(string strSampleID, string strPointName, string strResultItems, string strItems, string strMonitorID, string strSubTaskID)
{
bool isSuccess = true;
TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo();
objPoint.ID = GetSerialNumber("t_mis_monitor_taskpointId");
objPoint.IS_DEL = "0";
objPoint.SUBTASK_ID = strSubTaskID;
objPoint.POINT_NAME = strPointName;
objPoint.MONITOR_ID = strMonitorID;
objPoint.FREQ = "1";
objPoint.CREATE_DATE = DateTime.Now.ToString();
TMisMonitorSampleInfoVo objSampleVo = new TMisMonitorSampleInfoLogic().Details(strSampleID);
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubTaskID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
objPoint.TASK_ID = objTask.ID;
//监测任务出现新增排口时，基础资料企业表也要新增
TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo();
objnewPoint.ID = GetSerialNumber("t_base_company_point_id");
objnewPoint.IS_DEL = "0";
objnewPoint.POINT_NAME = strPointName;
objnewPoint.MONITOR_ID = strMonitorID;
objnewPoint.FREQ = "1";
objnewPoint.CREATE_DATE = DateTime.Now.ToString();
TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo();
objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTask.TESTED_COMPANY_ID);
TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID);
objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID;
isSuccess = new TBaseCompanyPointLogic().Create(objnewPoint);
objPoint.POINT_ID = objnewPoint.ID;
isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint);
//增加点位样品信息
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample.ID = GetSerialNumber("MonitorSampleId");
objSample.SUBTASK_ID = strSubTaskID;
objSample.QC_TYPE = "0";
objSample.NOSAMPLE = "0";
objSample.POINT_ID = objPoint.ID;
objSample.SAMPLE_NAME = objPoint.POINT_NAME;
//新增点位时候，自动生成该点位的样品编码
TBaseSerialruleVo objSerial = new TBaseSerialruleVo();
objSerial.SAMPLE_SOURCE = objTask.SAMPLE_SOURCE;
objSerial.SERIAL_TYPE = "2";
objSample.SAMPLECODE_CREATEDATE = DateTime.Now.ToString("yyyy-MM-dd");
objSample.SAMPLE_CODE = CreateBaseDefineCodeForSample(objSerial, objTask, objSubtask);
isSuccess = new TMisMonitorSampleInfoLogic().Create(objSample);
isSuccess = new TMisMonitorSampleInfoLogic().UpdateSetWhere("T_Mis_MONITOR_RESULT", "SAMPLE_ID='" + objSample.ID + "'", "ID in(" + strResultItems.TrimEnd(',') + ")");
isSuccess = new TMisMonitorSampleInfoLogic().UpdateSetWhere("T_Mis_MONITOR_TASK_ITEM", "TASK_POINT_ID='" + objPoint.ID + "'", "TASK_POINT_ID='" + objSampleVo.POINT_ID + "' AND ITEM_ID in(" + strItems.TrimEnd(',') + ")");
return(isSuccess ? "true" : "false");
}
public static string SaveData(string strPointID, string strSubtaskID, string strPOINT_NAME, string strMONITOR_ID, string strPOINT_TYPE, string strDYNAMIC_ATTRIBUTE_ID, string strFREQ,
string strCREATE_DATE, string strADDRESS, string strLONGITUDE, string strLATITUDE, string strNUM, string strAttribute,
string strNATIONAL_ST_CONDITION_ID, string strLOCAL_ST_CONDITION_ID, string strINDUSTRY_ST_CONDITION_ID)
{
bool isSuccess = true;
TMisMonitorTaskPointVo objPoint = new TMisMonitorTaskPointVo();
objPoint.ID = strPointID.Length > 0 ? strPointID : GetSerialNumber("t_mis_monitor_taskpointId");
objPoint.IS_DEL = "0";
objPoint.SUBTASK_ID = strSubtaskID;
objPoint.POINT_NAME = strPOINT_NAME;
objPoint.MONITOR_ID = strMONITOR_ID;
objPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID;
objPoint.FREQ = strFREQ;
objPoint.CREATE_DATE = strCREATE_DATE;
objPoint.ADDRESS = strADDRESS;
objPoint.LONGITUDE = strLONGITUDE;
objPoint.LATITUDE = strLATITUDE;
objPoint.NUM = strNUM;
objPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID;
objPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID;
objPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID;
TMisMonitorSubtaskVo objSubtask = new TMisMonitorSubtaskLogic().Details(strSubtaskID);
TMisMonitorTaskVo objTask = new TMisMonitorTaskLogic().Details(objSubtask.TASK_ID);
objPoint.TASK_ID = objTask.ID;
//监测任务出现新增排口时，基础资料企业表也要新增
TBaseCompanyPointVo objnewPoint = new TBaseCompanyPointVo();
if (strPointID.Length == 0)
{
objnewPoint.ID = GetSerialNumber("t_base_company_point_id");
objnewPoint.IS_DEL = "0";
objnewPoint.POINT_NAME = strPOINT_NAME;
objnewPoint.MONITOR_ID = strMONITOR_ID;
objnewPoint.DYNAMIC_ATTRIBUTE_ID = strDYNAMIC_ATTRIBUTE_ID;
objnewPoint.FREQ = strFREQ;
objnewPoint.CREATE_DATE = strCREATE_DATE;
objnewPoint.ADDRESS = strADDRESS;
objnewPoint.LONGITUDE = strLONGITUDE;
objnewPoint.LATITUDE = strLATITUDE;
objnewPoint.NUM = strNUM;
objnewPoint.NATIONAL_ST_CONDITION_ID = strNATIONAL_ST_CONDITION_ID;
objnewPoint.LOCAL_ST_CONDITION_ID = strLOCAL_ST_CONDITION_ID;
objnewPoint.INDUSTRY_ST_CONDITION_ID = strINDUSTRY_ST_CONDITION_ID;
TMisMonitorTaskCompanyVo objTaskCompany = new TMisMonitorTaskCompanyVo();
objTaskCompany.TASK_ID = objTask.ID;;
objTaskCompany = new TMisMonitorTaskCompanyLogic().Details(objTaskCompany);
TMisContractCompanyVo objContractCompany = new TMisContractCompanyLogic().Details(objTaskCompany.COMPANY_ID);
objnewPoint.COMPANY_ID = objContractCompany.COMPANY_ID;
new TBaseCompanyPointLogic().Create(objnewPoint);
objPoint.POINT_ID = objnewPoint.ID;
}
if (strPointID.Length > 0)
{
isSuccess = new TMisMonitorTaskPointLogic().Edit(objPoint);
}
else
{
isSuccess = new TMisMonitorTaskPointLogic().Create(objPoint);
//增加点位样品信息
TMisMonitorSampleInfoVo objSample = new TMisMonitorSampleInfoVo();
objSample.ID = GetSerialNumber("MonitorSampleId");
objSample.SUBTASK_ID = strSubtaskID;
objSample.QC_TYPE = "0";
objSample.NOSAMPLE = "0";
objSample.POINT_ID = objPoint.ID;
objSample.SAMPLE_NAME = objPoint.POINT_NAME;
string[] strSampleCode = new string[2] {
"S" + DateTime.Now.Year + DateTime.Now.Month, i3.View.PageBase.GetSerialNumber("monitor_samplecode")
};
objSample.SAMPLE_CODE = CreateSerialNumber(strSampleCode);
new TMisMonitorSampleInfoLogic().Create(objSample);
}
TBaseAttrbuteValue3Logic logicAttrValue = new TBaseAttrbuteValue3Logic();
//清掉原有动态属性值
TBaseAttrbuteValue3Vo objAttrValueDelWhere = new TBaseAttrbuteValue3Vo();
objAttrValueDelWhere.OBJECT_ID = objPoint.ID;
objAttrValueDelWhere.IS_DEL = "0";
TBaseAttrbuteValue3Vo objAttrValueDelSet = new TBaseAttrbuteValue3Vo();
objAttrValueDelSet.IS_DEL = "1";
logicAttrValue.Edit(objAttrValueDelSet, objAttrValueDelWhere);
//新增动态属性值
if (strAttribute.Length > 0)
{
string[] arrAttribute = strAttribute.Split('-');
for (int i = 0; i < arrAttribute.Length; i++)
{
string[] arrAttrValue = arrAttribute[i].Split('|');
TBaseAttrbuteValue3Vo objAttrValueAdd = new TBaseAttrbuteValue3Vo();
objAttrValueAdd.ID = GetSerialNumber("t_base_attribute_value3_id");
objAttrValueAdd.IS_DEL = "0";
objAttrValueAdd.OBJECT_TYPE = arrAttrValue[0];
objAttrValueAdd.OBJECT_ID = objPoint.ID;
objAttrValueAdd.ATTRBUTE_CODE = arrAttrValue[1];
objAttrValueAdd.ATTRBUTE_VALUE = arrAttrValue[2];
isSuccess = logicAttrValue.Create(objAttrValueAdd);
}
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
/// <summary>
/// 根据对象特征获取单一对象
/// </summary>
/// <param name="tBaseCompanyPoint">对象</param>
/// <returns></returns>
public TBaseCompanyPointVo SelectByObject(TBaseCompanyPointVo tBaseCompanyPoint)
{
return(access.SelectByObject(tBaseCompanyPoint));
}
