//获取指定点位的监测项目信息
private string getItemList()
{
string strSortname = Request.Params["sortname"];
string strSortorder = Request.Params["sortorder"];
int intPageIdx = Convert.ToInt32(Request.Params["page"]);
int intPagesize = Convert.ToInt32(Request.Params["pagesize"]);
string strSelPointID = (Request.Params["pId"] != null) ? Request.Params["pId"] : "";
if (strSelPointID.Length <= 0)
{
return("");
}
if (strSortname == null || strSortname.Length < 0)
{
strSortname = TBaseCompanyPointItemVo.ID_FIELD;
}
TBaseCompanyPointItemVo objPointItem = new TBaseCompanyPointItemVo();
objPointItem.IS_DEL = "0";
objPointItem.POINT_ID = strSelPointID;
objPointItem.SORT_FIELD = strSortname;
objPointItem.SORT_TYPE = strSortorder;
TBaseCompanyPointItemLogic logicPointItem = new TBaseCompanyPointItemLogic();
int intTotalCount = logicPointItem.GetSelectResultCount(objPointItem);;//总计的数据条数
DataTable dt = logicPointItem.SelectByTable(objPointItem, intPageIdx, intPagesize);
string strJson = CreateToJson(dt, intTotalCount);
return(strJson);
}
public static string CopyPointItem(string strCopyID, string strPastID)
{
bool isSuccess = true;
TBaseCompanyPointItemVo objPointItemCopy = new TBaseCompanyPointItemVo();
objPointItemCopy.IS_DEL = "0";
objPointItemCopy.POINT_ID = strCopyID;
DataTable dtCopy = new TBaseCompanyPointItemLogic().SelectByTable(objPointItemCopy);
TBaseCompanyPointItemVo objPointItemPast = new TBaseCompanyPointItemVo();
objPointItemPast.IS_DEL = "0";
objPointItemPast.POINT_ID = strPastID;
DataTable dtPast = new TBaseCompanyPointItemLogic().SelectByTable(objPointItemPast);
string strIsExistItem = "";
for (int i = 0; i < dtPast.Rows.Count; i++)
{
strIsExistItem += "," + dtPast.Rows[i]["ITEM_ID"].ToString();
}
strIsExistItem += strIsExistItem.Length > 0 ? "," : "";
for (int i = 0; i < dtCopy.Rows.Count; i++)
{
DataRow dr = dtCopy.Rows[i];
string strCopyItemID = dr["ITEM_ID"].ToString();
if (!strIsExistItem.Contains(strCopyItemID))
{
TBaseCompanyPointItemVo objPointItem = new TBaseCompanyPointItemVo();
objPointItem.ID = GetSerialNumber("t_base_company_point_item_id");
objPointItem.IS_DEL = "0";
objPointItem.POINT_ID = strPastID;
objPointItem.ITEM_ID = strCopyItemID;
isSuccess = new TBaseCompanyPointItemLogic().Create(objPointItem);
if (isSuccess)
{
new PageBase().WriteLog("新增监测点位明细表", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增监测点位明细表" + objPointItem.ID + "成功");
}
}
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
protected void BindList()
{
TBaseItemInfoVo objItem = new TBaseItemInfoVo();
objItem.IS_DEL = "0";
objItem.MONITOR_ID = this.Request["MonitorType"].ToString();
List <TBaseItemInfoVo> lstItem = new TBaseItemInfoLogic().SelectByObject(objItem, 0, 0);
lstItem.Sort(delegate(TBaseItemInfoVo a, TBaseItemInfoVo b) { return(a.ORDER_NUM.CompareTo(b.ORDER_NUM)); });
this.ListBox1.DataSource = lstItem;
this.ListBox1.DataValueField = TBaseItemInfoVo.ID_FIELD;
this.ListBox1.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD;
this.ListBox1.DataBind();
TBaseCompanyPointItemVo objPointItem = new TBaseCompanyPointItemVo();
objPointItem.IS_DEL = "0";
objPointItem.POINT_ID = this.Request["PointID"].ToString();
List <TBaseCompanyPointItemVo> lstPointItem = new TBaseCompanyPointItemLogic().SelectByObject(objPointItem, 0, 0);
string strPointItemIDs = "";
for (int i = 0; i < lstPointItem.Count; i++)
{
strPointItemIDs += "," + lstPointItem[i].ITEM_ID;
}
strPointItemIDs = strPointItemIDs + ",";
for (int i = lstItem.Count - 1; i >= 0; i--)
{
if (!strPointItemIDs.Contains(lstItem[i].ID))
{
lstItem.RemoveAt(i);
}
}
this.ListBox2.DataSource = lstItem;
this.ListBox2.DataValueField = TBaseItemInfoVo.ID_FIELD;
this.ListBox2.DataTextField = TBaseItemInfoVo.ITEM_NAME_FIELD;
this.ListBox2.DataBind();
for (int i = 0; i < ListBox2.Items.Count; i++)
{
ListItem item = ListBox2.Items[i];
ListBox1.Items.Remove(item);
}
}
public static string SaveDataItem(string strPointID, string strSelItem_IDs)
{
bool isSuccess = true;
string[] arrSelItemId = strSelItem_IDs.Split(',');
TBaseCompanyPointItemVo objPointItemSet = new TBaseCompanyPointItemVo();
objPointItemSet.IS_DEL = "1";
TBaseCompanyPointItemVo objPointItemWhere = new TBaseCompanyPointItemVo();
objPointItemWhere.IS_DEL = "0";
objPointItemWhere.POINT_ID = strPointID;
if (new TBaseCompanyPointItemLogic().Edit(objPointItemSet, objPointItemWhere))
{
new PageBase().WriteLog("删除监测点位明细表", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除监测点位" + strPointID + "的明细表成功");
}
if (strSelItem_IDs.Length > 0)
{
for (int i = 0; i < arrSelItemId.Length; i++)
{
TBaseCompanyPointItemVo objPointItem = new TBaseCompanyPointItemVo();
objPointItem.ID = GetSerialNumber("t_base_company_point_item_id");
objPointItem.IS_DEL = "0";
objPointItem.POINT_ID = strPointID;
objPointItem.ITEM_ID = arrSelItemId[i];
isSuccess = new TBaseCompanyPointItemLogic().Create(objPointItem);
if (isSuccess)
{
new PageBase().WriteLog("新增监测点位明细表", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增监测点位明细表" + objPointItem.ID + "成功");
}
}
}
if (isSuccess)
{
return("1");
}
else
{
return("0");
}
}
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 = "导入成功!!!!!!!!!!!!!!!!!!";
}
