private string InsertContractCompanyInfo(string strReqTaskId, string strReqCompanyId) { string result = ""; DataTable dt = new DataTable(); TMisMonitorTaskCompanyVo objTmc = new TMisMonitorTaskCompanyVo(); //Update By SSZ 将基础资料企业信息复制到委托书企业信息 //基础企业资料信息 TBaseCompanyInfoVo objCompanyInfo = new TBaseCompanyInfoLogic().Details(strReqCompanyId); //将相同字段的数据进行复制 CopyObject(objCompanyInfo, objTmc); objTmc.TASK_ID = strReqTaskId; objTmc.COMPANY_ID = strReqCompanyId; objTmc.IS_DEL = "0"; objTmc.ID = i3.View.PageBase.GetSerialNumber("t_mis_monitor_taskcompanyId"); if (new TMisMonitorTaskCompanyLogic().Create(objTmc)) { result = objTmc.ID.ToString(); string strMessage = LogInfo.UserInfo.USER_NAME + "添加任务企业" + objTmc.ID + "成功"; //WriteLog(i3.ValueObject.ObjectBase.LogType.AddContractCompanyInfo, "", strMessage); } return(result); }
/// <summary> /// 获取企业信息 /// </summary> /// <returns></returns> private string getCompanyInfo() { string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TBaseCompanyInfoVo TBaseCompanyInfoVo = new TBaseCompanyInfoVo(); TBaseCompanyInfoVo.IS_DEL = "0"; TBaseCompanyInfoVo.SORT_FIELD = strSortname; TBaseCompanyInfoVo.SORT_TYPE = strSortorder; DataTable dt = new DataTable(); int intTotalCount = 0; //自定义查询使用 TBaseCompanyInfoVo.COMPANY_NAME = !string.IsNullOrEmpty(Request.QueryString["srhCompayName"]) ? Request.QueryString["srhCompayName"].ToString().Trim() : ""; TBaseCompanyInfoVo.AREA = !string.IsNullOrEmpty(Request.QueryString["srh_Area"]) ? Request.QueryString["srh_Area"].ToString().Trim() : ""; TBaseCompanyInfoVo.INDUSTRY = !string.IsNullOrEmpty(Request.QueryString["srh_Industry"]) ? Request.QueryString["srh_Industry"].ToString().Trim() : ""; intTotalCount = new TBaseCompanyInfoLogic().GetSelecDefinedtResultCount(TBaseCompanyInfoVo); dt = new TBaseCompanyInfoLogic().SelectDefinedTadble(TBaseCompanyInfoVo, intPageIndex, intPageSize); string strJson = CreateToJson(dt, intTotalCount); return(strJson); }
/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { TBaseCompanyInfoVo TBaseCompanyInfoVo = new TBaseCompanyInfoVo(); TBaseCompanyInfoVo.ID = Request["id"].ToString(); TBaseCompanyInfoVo.IS_DEL = "0"; TBaseCompanyInfoVo TBaseCompanyInfoVoTemp = new TBaseCompanyInfoLogic().Details(TBaseCompanyInfoVo); return(ToJson(TBaseCompanyInfoVoTemp)); }
/// <summary> /// 修改数据 /// </summary> /// <returns></returns> public string frmUpdate() { TBaseCompanyInfoVo TBaseCompanyInfoVo = autoBindRequest(Request, new TBaseCompanyInfoVo()); TBaseCompanyInfoVo.ID = Request["id"].ToString(); TBaseCompanyInfoVo.IS_DEL = "0"; bool isSuccess = new TBaseCompanyInfoLogic().Edit(TBaseCompanyInfoVo); if (isSuccess) { new PageBase().WriteLog("修改企业信息", "", new PageBase().LogInfo.UserInfo.USER_NAME + "修改企业信息" + TBaseCompanyInfoVo.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 增加数据 /// </summary> /// <returns></returns> public string frmAdd() { TBaseCompanyInfoVo TBaseCompanyInfoVo = autoBindRequest(Request, new TBaseCompanyInfoVo()); TBaseCompanyInfoVo.ID = GetSerialNumber("Company_Id"); TBaseCompanyInfoVo.IS_DEL = "0"; bool isSuccess = new TBaseCompanyInfoLogic().Create(TBaseCompanyInfoVo); if (isSuccess) { new PageBase().WriteLog("新增企业信息", "", new PageBase().LogInfo.UserInfo.USER_NAME + "新增企业信息" + TBaseCompanyInfoVo.ID + "成功"); } return(isSuccess == true ? "1" : "0"); }
public static string deleteCompanyInfo(string strValue) { TBaseCompanyInfoVo TBaseCompanyInfoVo = new TBaseCompanyInfoVo(); TBaseCompanyInfoVo.ID = strValue; TBaseCompanyInfoVo.IS_DEL = "1"; bool isSuccess = new TBaseCompanyInfoLogic().Edit(TBaseCompanyInfoVo); if (isSuccess) { new PageBase().WriteLog("删除企业信息", "", new PageBase().LogInfo.UserInfo.USER_NAME + "删除企业信息" + TBaseCompanyInfoVo.ID + "成功"); } return(isSuccess == true ? "1" : "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 = "导入成功!!!!!!!!!!!!!!!!!!"; }