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;
|
}
|
}
|
