using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Net; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using MojoCube.Api.File; public partial class Ipqc_CheckEdit : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { MojoCube.Office.lpqc.CheckList list = new MojoCube.Office.lpqc.CheckList(); switch (int.Parse(Session["RoleValue"].ToString())) { case 1: Back.NavigateUrl = "CheckListT1.aspx?active=" + Request.QueryString["active"]; break; case 3: Back.NavigateUrl = "CheckListT2.aspx?active=" + Request.QueryString["active"]; break; case 6: Back.NavigateUrl = "CheckListT2.aspx?active=" + Request.QueryString["active"]; break; case 9: Back.NavigateUrl = "CheckListT3.aspx?active=" + Request.QueryString["active"]; break; } ddlManageClass.DataSource = list.GetManageClass(); ddlManageClass.DataTextField = "ManagementName"; ddlManageClass.DataValueField = "pk_Management"; ddlManageClass.DataBind(); ddlManageClass.Items.Insert(0, "请选择"); ddlFirstCompany.DataSource = list.GetCompany(); ddlFirstCompany.DataTextField = "CompanyName"; ddlFirstCompany.DataValueField = "pk_Company"; ddlFirstCompany.DataBind(); ListItem item = new ListItem(); item.Text = "请选择"; item.Value = "0"; ddlFirstCompany.Items.Insert(0, item); //ddlFirstCompany.AutoPostBack = true; ddlSceondCompany.Items.Insert(0, item); DataTable dtArea = list.GetArea(); ddlArea.DataSource = dtArea; ddlArea.DataTextField = "TypeName"; ddlArea.DataValueField = "pk_TypeId"; ddlArea.DataBind(); ddlArea.Items.Insert(0, "请选择"); ddlArea.AutoPostBack = true; txtReported_Remark.Text = "0"; if (Request.QueryString["id"] != null) { lblIssueState.Text = "修改"; this.Title = "修改巡检问题"; ViewState["pk_Examine"] = MojoCube.Api.Text.Security.DecryptString(Request.QueryString["id"]); MojoCube.Office.lpqc.CheckList listBackFill = new MojoCube.Office.lpqc.CheckList(); listBackFill.PageLoadReportedGetData(int.Parse(ViewState["pk_Examine"].ToString())); ddlManageClass.SelectedValue = listBackFill.fk_Management.ToString(); ddlFirstCompany.SelectedValue = listBackFill.FirstCompanyId.ToString(); ddlSecondBind(); ddlSceondCompany.SelectedValue = listBackFill.SecondCompanyId.ToString(); ddlArea.SelectedValue = listBackFill.fk_Role_Type.ToString(); txtReported_Question.Text = listBackFill.Reported_Question; txtAddress.Text = listBackFill.Reported_Address; txtReported_Remark.Text = listBackFill.Reported_Remark.ToString("f2"); //var test = listBackFill.Reported_Img.ToString().Split(new char[] {','}).Length; //var mm = listBackFill.Reported_Img.ToString().Split(new char[] {','})[0]; if (listBackFill.Reported_Img.Contains(",")) { var images = listBackFill.Reported_Img.Split(new char[] { ',' }); for (int i = 0; i < images.Length; i++) { if (i == 0) { imgPortrait.ImageUrl = images[i]; } else if (i == 1) { imgPortrait1.ImageUrl = images[i]; } else if (i == 2) { imgPortrait2.ImageUrl = images[i]; } else if (i == 3) { imgPortrait3.ImageUrl = images[i]; } else if (i == 4) { imgPortrait4.ImageUrl = images[i]; } else if (i == 5) { imgPortrait5.ImageUrl = images[i]; } } //imgPortrait.ImageUrl = listBackFill.Reported_Img.Substring(0,listBackFill.Reported_Img.IndexOf(",")); //imgPortrait1.ImageUrl = listBackFill.Reported_Img.Substring(listBackFill.Reported_Img.IndexOf(",") + 1); } else { imgPortrait.ImageUrl = listBackFill.Reported_Img; imgPortrait1.ImageUrl = "../Images/nouppic.png"; } //imgPortrait.ImageUrl = listBackFill.Reported_Img; txtAddress1.Text = listBackFill.Reported_Address; hflnglat.Value = listBackFill.Reported_lnglat; } else { lblIssueState.Text = "创建"; this.Title = "创建巡检问题"; if (Request.QueryString["SeletedId"] != null && Request.QueryString["SeletedId"].ToString() != "请选择") { ddlArea.SelectedValue = Request.QueryString["SeletedId"]; DataRow[] drs = dtArea.Select("pk_TypeId=" + Request.QueryString["SeletedId"]); if (drs != null) { hflnglat.Value = drs[0]["lng_Position"].ToString(); } } else { ddlArea.SelectedIndex = 0; } //默认只有一个主管单位 ddlFirstCompany.SelectedIndex = 1; //默认取值Area对应的派单景点 MojoCube.Office.lpqc.CheckList listSecond = new MojoCube.Office.lpqc.CheckList(); ddlSceondCompany.DataSource = listSecond.GetCompany(int.Parse(ddlFirstCompany.SelectedValue)); ddlSceondCompany.DataTextField = "CompanyName"; ddlSceondCompany.DataValueField = "pk_Company"; ddlSceondCompany.DataBind(); //ddlSceondCompany.Items.Insert(0, "请选择"); for (int i = 0; i < ddlSceondCompany.Items.Count; i++) { if (ddlSceondCompany.Items[i].Text == ddlArea.SelectedItem.Text) { ddlSceondCompany.SelectedIndex = i; break; } } ddlSceondCompany.SelectedItem.Text = ddlArea.SelectedItem.Text; } } } catch (Exception ex) { MojoCube.Api.Log.LogHelper.Write(MojoCube.Api.Log.Level.Error, "pc_JJH Ipqc_CheckEdit/Page_Load", ex); } } protected void ddlFirstCompany_SelectedIndexChanged(object sender, EventArgs e) { ddlSecondBind(); } private void ddlSecondBind() { try { MojoCube.Office.lpqc.CheckList list = new MojoCube.Office.lpqc.CheckList(); ddlSceondCompany.DataSource = list.GetCompany(int.Parse(ddlFirstCompany.SelectedValue)); ddlSceondCompany.DataTextField = "CompanyName"; ddlSceondCompany.DataValueField = "pk_Company"; ddlSceondCompany.DataBind(); ddlSceondCompany.Items.Insert(0, "请选择"); ddlSceondCompany.AutoPostBack = true; } catch (Exception ex) { MojoCube.Api.Log.LogHelper.Write(MojoCube.Api.Log.Level.Error, "pc_JJH Ipqc_CheckEdit/ddlSecondBind", ex); } } protected void btnSave_Click(object sender, EventArgs e) { try { MojoCube.Office.lpqc.CheckList listSave = new MojoCube.Office.lpqc.CheckList(); double RemarkValue = 0; double.TryParse(txtReported_Remark.Text, out RemarkValue); if (ViewState["pk_Examine"] != null) { MojoCube.Api.File.Upload upload = new MojoCube.Api.File.Upload(); //listSave.Reported_Img = ConverToImg(upload.FilePath); listSave.Reported_Img = listSave.ReportedGetImg(Convert.ToInt32(ViewState["pk_Examine"])); string filePath = listSave.Reported_Img; if (fuPortrait.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait, true); //Path = listSave.Reported_Img.ToString().Contains(",") ? Upload.ConverToImg(upload.FilePath,"s") + listSave.Reported_Img.ToString().Substring(listSave.Reported_Img.ToString().IndexOf(",")) : Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait1.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait1, true); //Path = Path.Contains(",") ? Path.Substring(0, Path.IndexOf(",") + 1) + Upload.ConverToImg(upload.FilePath, "s") : Path == "" ? Upload.ConverToImg(upload.FilePath, "s") : Path + "," + Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait2.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait2, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait3.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait3, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait4.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait4, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait5.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait5, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } if (ddlManageClass.SelectedIndex <= 0) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请选择评定项目"); } else if (ddlArea.SelectedIndex <= 0) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请选择所属景点"); } else if (ddlFirstCompany.SelectedIndex <= 0) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请选择主管单位"); } else if (ddlSceondCompany.SelectedIndex <= 0) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请选择派单景点"); } else if (listSave.Reported_Img == "") { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请上传问题图片"); } else if (txtReported_Question.Text.Trim() == "") { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请输入上报问题"); } else if (RemarkValue <= 0) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请输入正确的打分"); } else { listSave.ReportedGetData(int.Parse(ViewState["pk_Examine"].ToString())); listSave.Reported_User = int.Parse(Session["UserID"].ToString()); listSave.fk_Management = int.Parse(ddlManageClass.SelectedValue); listSave.FirstCompanyId = int.Parse(ddlFirstCompany.SelectedValue); listSave.SecondCompanyId = int.Parse(ddlSceondCompany.SelectedValue); listSave.fk_Role_Type = int.Parse(ddlArea.SelectedValue); listSave.Reported_Question = txtReported_Question.Text; double Remark = 0; double.TryParse(txtReported_Remark.Text, out Remark); listSave.Reported_Remark = Remark; listSave.Reported_Address = txtAddress1.Text; listSave.Reported_Img = filePath; listSave.Reported_lnglat = hflnglat.Value; //listSave.Reported_User = int.Parse(Session["UserID"].ToString()); listSave.ReportedUpdateData(int.Parse(ViewState["pk_Examine"].ToString())); switch (int.Parse(Session["RoleValue"].ToString())) { case 1: Back.NavigateUrl = "CheckListT1.aspx?active=" + Request.QueryString["active"]; break; case 6: Back.NavigateUrl = "CheckListT2.aspx?active=" + Request.QueryString["active"]; break; case 9: Back.NavigateUrl = "CheckListT3.aspx?active=" + Request.QueryString["active"]; break; } AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("success", "修改成功"); } } else { if (ddlManageClass.SelectedIndex <= 0) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请选择评定项目"); } else if (ddlArea.SelectedIndex <= 0) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请选择所属景点"); } //else if (ddlFirstCompany.SelectedIndex <= 0) //{ // AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请选择主管单位"); //} //else if (ddlSceondCompany.SelectedIndex <= 0) //{ // AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请选择派单景点"); //} else if (listSave.Reported_Img == "") { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请上传问题图片"); } else if (txtReported_Question.Text.Trim() == "") { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请输入上报问题"); } else if (RemarkValue < 0) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请输入正确的打分"); } else if (!fuPortrait.HasFile) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "请上传至少一张图片"); } else { if (fuPortrait.HasFile) { string filePath = ""; MojoCube.Api.File.Upload upload = new MojoCube.Api.File.Upload(); upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait, true); filePath = Upload.ConverToImg(upload.FilePath, "s"); if (fuPortrait1.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait1, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait2.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait2, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait3.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait3, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait4.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait4, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } if (fuPortrait5.HasFile) { upload.FilePath = "lpqc"; upload.FileName = MojoCube.Api.Text.Function.DateTimeString(true); upload.DoFileUpload(fuPortrait5, true); filePath += "," + Upload.ConverToImg(upload.FilePath, "s"); } listSave.Reported_Img = filePath; ; } listSave.Reported_User = int.Parse(Session["UserID"].ToString()); listSave.fk_Management = int.Parse(ddlManageClass.SelectedValue); listSave.FirstCompanyId = int.Parse(ddlFirstCompany.SelectedValue); listSave.SecondCompanyId = int.Parse(ddlSceondCompany.SelectedValue); listSave.fk_Role_Type = int.Parse(ddlArea.SelectedValue); listSave.Reported_Question = txtReported_Question.Text; listSave.Reported_Address = txtAddress1.Text; double Remark = 0; double.TryParse(txtReported_Remark.Text, out Remark); listSave.Reported_Remark = Remark; listSave.Reported_lnglat = hflnglat.Value; listSave.ReportedInsertData(); switch (int.Parse(Session["RoleValue"].ToString())) { case 1: Back.NavigateUrl = "CheckListT1.aspx?active=" + Request.QueryString["active"]; break; case 6: Back.NavigateUrl = "CheckListT2.aspx?active=" + Request.QueryString["active"]; break; case 9: Back.NavigateUrl = "CheckListT3.aspx?active=" + Request.QueryString["active"]; break; } //DataTable dt = new DataTable(); //dt = listSave.GetDisposeSecondInfo(ddlSceondCompany.SelectedValue); //DataTable dtFirst = new DataTable(); //dtFirst = listSave.GetDisposeFirstInfo(ddlFirstCompany.SelectedValue); //foreach (DataRow item in dt.Rows) //{ // string toEmail = item["Email1"] != null ? item["Email1"].ToString() : item["Email2"] != null ? item["Email2"].ToString() : ""; // if (toEmail == "") // { // AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "所属单位" + item["CompanyName"].ToString() + "邮箱为空"); // } // else // { // MojoCube.Api.Mail.SendEmail.SendSecond(toEmail, DateTime.Now.ToString(), item["FullName"].ToString(), item["CompanyName"].ToString()); // foreach (DataRow itemFirst in dtFirst.Rows) // { // string toFirstEmail = itemFirst["Email1"] != null ? itemFirst["Email1"].ToString() : itemFirst["Email2"] != null ? itemFirst["Email2"].ToString() : ""; // if (toFirstEmail == "") // { // AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "所属单位" + itemFirst["CompanyName"].ToString() + "邮箱为空"); // } // else // { // MojoCube.Api.Mail.SendEmail.SendFirst(toFirstEmail, DateTime.Now.ToString(), item["FullName"].ToString(), item["CompanyName"].ToString(), itemFirst["CompanyName"].ToString(), itemFirst["FullName"].ToString()); // } // } // } //} AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("success", "添加成功"); } } } catch (Exception ex) { AlertDiv.InnerHtml = MojoCube.Office.String.ShowAlert("danger", "出现异常！" + ex.ToString()); MojoCube.Api.Log.LogHelper.Write(MojoCube.Api.Log.Level.Error, "pc_JJH Ipqc_CheckEdit/btnSave_Click", ex); } //Response.Redirect("CheckList.aspx?active="+Request.QueryString["active"]); } protected void ddlArea_SelectedIndexChanged(object sender, EventArgs e) { MojoCube.Office.lpqc.CheckList list = new MojoCube.Office.lpqc.CheckList(); DataTable dtArea = list.GetArea(); DataRow[] drs = dtArea.Select("pk_TypeId=" + ddlArea.SelectedValue); if (drs != null) { hflnglat.Value = drs[0]["lng_Position"].ToString(); } ddlFirstCompany.SelectedIndex = 1; for (int i = 0; i < ddlSceondCompany.Items.Count; i++) { if (ddlSceondCompany.Items[i].Text == ddlArea.SelectedItem.Text) { ddlSceondCompany.SelectedIndex = i; break; } } ddlSceondCompany.SelectedItem.Text = ddlArea.SelectedItem.Text; } }