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");
}
//获取点位信息
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);
}
//获取点位对应的动态属性值
private void GetAttrValue(string strID)
{
TBaseCompanyPointVo objPoint = new TBaseCompanyPointLogic().Details(strID);
TBaseAttrbuteValueVo objAttrValue = new TBaseAttrbuteValueVo();
objAttrValue.IS_DEL = "0";
objAttrValue.OBJECT_ID = strID;
DataTable dt = new TBaseAttrbuteValueLogic().SelectByTable(objAttrValue);
string strJson = DataTableToJson(dt);
Response.Write(strJson);
Response.End();
}
//获取数据
private void GetData(string strID)
{
TBaseCompanyPointVo objPoint = new TBaseCompanyPointLogic().Details(strID);
TBaseEvaluationConInfoLogic logicCon = new TBaseEvaluationConInfoLogic();
TBaseEvaluationInfoLogic logicSt = new TBaseEvaluationInfoLogic();
//按行、地、国标优先顺序进行标准的选定
//国标条件项
if (objPoint.NATIONAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.NATIONAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.NATIONAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidNATIONAL_ST_CON = objCon.ID;
}
//地标条件项
if (objPoint.LOCAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.LOCAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.LOCAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidLOCAL_ST_CON = objCon.ID;
}
//行标条件项
if (objPoint.INDUSTRY_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.INDUSTRY_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.INDUSTRY_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidINDUSTRY_ST_CON = objCon.ID;
}
string strJson = ToJson(objPoint);
Response.Write(strJson);
Response.End();
}
//获取数据
private void GetData(string strID)
{
TBaseCompanyPointVo objPoint = new TBaseCompanyPointLogic().Details(strID);
TBaseEvaluationConInfoLogic logicCon = new TBaseEvaluationConInfoLogic();
TBaseEvaluationInfoLogic logicSt = new TBaseEvaluationInfoLogic();
if (objPoint.NATIONAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.NATIONAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.NATIONAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidNATIONAL_ST_CON = objCon.ID;
}
if (objPoint.LOCAL_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.LOCAL_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.LOCAL_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidLOCAL_ST_CON = objCon.ID;
}
if (objPoint.INDUSTRY_ST_CONDITION_ID.Length > 0)
{
TBaseEvaluationConInfoVo objCon = logicCon.Details(objPoint.INDUSTRY_ST_CONDITION_ID);
TBaseEvaluationInfoVo objSt = logicSt.Details(objCon.STANDARD_ID);
objPoint.INDUSTRY_ST_CONDITION_ID = objSt.STANDARD_CODE + "" + objSt.STANDARD_NAME;
objPoint.hidINDUSTRY_ST_CON = objCon.ID;
}
objPoint.CREATE_DATE = objPoint.CREATE_DATE.Replace(" 0:00:00", "");
string strJson = ToJson(objPoint);
Response.Write(strJson);
Response.End();
}
//获取点位信息
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);
}
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");
}
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 = "导入成功!!!!!!!!!!!!!!!!!!";
}
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 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("");
}
}
