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 = "导入成功!!!!!!!!!!!!!!!!!!";
}
