protected void Page_Load(object sender, EventArgs e)
{
string ssUserType = Session["UserType"] + "";
string ssUserID = Session["ID"] + "";
string ssUserPW = Session["PW"] + "";
string ssUserName = Session["NAME"] + "";
string ssJobTitle = Session["JobTitle"] + "";
GBClass001 SBApp = new GBClass001();
if (CheckPrivacy(ssUserType, ssUserID, ssUserPW))
{
Response.Redirect("../SWCDOC/SWC001.aspx");
}
//全區供用
//SBApp.ViewRecord("臺北市山坡地水土保持設施維護檢查及輔導紀錄表", "update", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
//全區供用
}
protected void Page_Load(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string rDTLId = Request.QueryString["DTLNO"] + "";
string ssUserName = Session["NAME"] + "";
GBClass001 SBApp = new GBClass001();
if (rCaseId == "")
{
Response.Redirect("SWC000.aspx");
}
if (!IsPostBack)
{
GenerateDropDownList();
Data2Page(rCaseId, rDTLId);
}
//以下全區公用
SBApp.ViewRecord("水土保持施工抽查紀錄", "view", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + "，您好";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string rACTion = Request.QueryString["ACT"] + "";
GBClass001 SBApp = new GBClass001();
if (!Page.IsPostBack)
{
GenDropDownList();
NewUser.NavigateUrl = "SWCBase001.aspx?ETID=NEW";
if (rACTion == "LogOut")
{
//登出
Session["UserType"] = "";
Session["ID"] = "";
Session["PW"] = "";
Session["NAME"] = "";
Session["Unit"] = "";
Session["Edit4"] = ""; //完工公會
}
Session["runrunruncount"] = 0;
MarqueeTimer_Tick(MarqueeTimer, EventArgs.Empty);
}
//全區供用
SBApp.ViewRecord("首頁登入", "view", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
//全區供用
}
protected void Page_Load(object sender, EventArgs e)
{
string ssUserType = Session["UserType"] + "";
string ssUserID = Session["ID"] + "";
string ssUserName = Session["NAME"] + "";
string ssJobTitle = Session["JobTitle"] + "";
string rqSearch = Request["SR"] + "";
GBClass001 SBApp = new GBClass001();
if (ssUserType == "03")
{
if (!IsPostBack)
{
GenerateDropDownList();
}
}
else
{
Response.Redirect("../SWCDOC/SWC001.aspx");
}
switch (ssUserType)
{
case "01":
break;
case "02":
TitleLink00.Visible = true;
break;
case "03": //大地人員
GoTslm.Visible = true;
GOVMG.Visible = true;
break;
case "04":
break;
default:
Response.Redirect("../SWCDOC/SWC000.aspx");
break;
}
//全區供用
SBApp.ViewRecord("書件目錄查詢", "view", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string rETID = Request.QueryString["ETID"] + "";
string SessETID = Session["ID"] + "";
string ssUserName = Session["NAME"] + "";
string ssJobTitle = Session["JobTitle"] + "";
GBClass001 SBApp = new GBClass001();
if (!IsPostBack)
{
if (rETID == "" && SessETID == "")
{
Response.Redirect("SWC001.aspx");
}
if (rETID == "NEW")
{
JSID.Text = rETID;
Image1.ImageUrl = "../images/title/title-apply.png";
GetUserData("NEW");
TitleLink01.Visible = false;
}
else
{
if (SessETID == "")
{
Response.Redirect("SWC001.aspx");
}
else
{
Image1.ImageUrl = "../images/title/title-account.png";
JSID.Text = SessETID;
TXTACTION.Text = SessETID;
GetUserData(SessETID);
TitleLink01.Visible = true;
CHGPW.Visible = true;
}
}
}
GoTslm.Visible = false;
//以下全區公用
SBApp.ViewRecord("帳號管理", "view", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string rDTLId = Request.QueryString["DTLNO"] + "";
string ssUserName = Session["NAME"] + "";
string ssJobTitle = Session["JobTitle"] + "";
string ssUserType = Session["UserType"] + "";
GBClass001 SBApp = new GBClass001();
if (rCaseId == "")
{
Response.Redirect("SWC001.aspx");
}
switch (ssUserType)
{
case "02":
TitleLink00.Visible = true;
break;
case "03":
GoTslm.Visible = true;
break;
}
if (!IsPostBack)
{
GenerateDropDownList();
Data2Page(rCaseId, rDTLId);
}
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + "，您好";
}
//全區供用
SBApp.ViewRecord("臺北市水土保持計畫監造紀錄", "update", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
//全區供用
}
protected void Page_Load(object sender, EventArgs e)
{
string ssUserName = Session["NAME"] + "";
string ssJobTitle = Session["JobTitle"] + "";
GBClass001 SBApp = new GBClass001();
string rCaseId = Request.QueryString["SWCNO"] + "";
string rONA000 = Request.QueryString["OACode"] + "";
string rBTNCTL = Request.QueryString["PRS"] + "";
string rUA = Request.QueryString["UA"] + "";
//測試用變數設定
//rONA000 = "TEST10704001";
LBSWC000.Text = rCaseId;
if (!IsPostBack)
{
if (rONA000 == "")
{
Response.Redirect("OnlineApply001L.aspx");
}
else
{
Data2Page(rCaseId, rONA000);
}
}
if (rUA == "over")
{
DataLock.Visible = false; SaveCase.Visible = false; GoHomePage.Visible = false;
}
else if (rUA.Trim() != "over")
{
GoHomePage.Visible = true;
}
//全區供用
SBApp.ViewRecord("臺北市山坡地水土保持設施安全自主檢查表", "view", rONA000);
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
//全區供用
}
protected void Page_Load(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string rRRPage = Request.QueryString["RRPG"] + "";
string rDTLId = Request.QueryString["DTLNO"] + "";
string ssUserName = Session["NAME"] + "";
string ssJobTitle = Session["JobTitle"] + "";
GBClass001 SBApp = new GBClass001();
if (rCaseId == "")
{
Response.Redirect("SWC000.aspx");
}
if (!IsPostBack)
{
GenerateDropDownList();
Data2Page(rCaseId, rDTLId);
}
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + "，您好";
}
if (rRRPage == "55")
{
GoHomePage.Visible = false;
}
//全區供用
SBApp.ViewRecord("颱風豪雨設施自主檢查表", "view", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
//全區供用
}
private void SendMailNotice(string gSWC000, string gReview)
{
GBClass001 SBApp = new GBClass001();
//送出提醒名單：義務人
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select SWC.SWC002,SWC.SWC005, SWC.SWC012, SWC.SWC013,SWC.SWC013TEL, SWC.SWC022, SWC.SWC021ID,U.ETName,U.ETEmail,SWC.SWC108 from SWCCASE SWC ";
strSQLRV = strSQLRV + " LEFT JOIN ETUsers U on SWC.SWC021ID = U.ETID ";
strSQLRV = strSQLRV + " where SWC.SWC000 = '" + gSWC000 + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
string tSWC012 = readeSwc["SWC012"] + "";
string tSWC013 = readeSwc["SWC013"] + "";
string tSWC013TEL = readeSwc["SWC013TEL"] + "";
string tSWC022 = readeSwc["SWC022"] + "";
string tSWC021ID = readeSwc["SWC021ID"] + "";
string tETName = readeSwc["ETName"] + "";
string tETEmail = readeSwc["ETEmail"] + "";
string tSWC108 = readeSwc["SWC108"] + "";
string[] arraySentMail02 = new string[] { tSWC108 };
string ssMailSub02 = "您好，" + "水土保持計畫【" + tSWC002 + "】申請暫停審查已" + gReview;
string ssMailBody02 = "您好，【" + tSWC005 + "】申請開工/復工展延已" + gReview + "，詳情請至臺北市水土保持申請書件管理平台上瀏覽。" + "<br><br>";
ssMailBody02 = ssMailBody02 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
ssMailBody02 = ssMailBody02 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
bool MailTo02 = SBApp.Mail_Send(arraySentMail02, ssMailSub02, ssMailBody02);
}
readeSwc.Close();
objCmdSwc.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string rDTLId = Request.QueryString["DTLNO"] + "";
string ssUserName = Session["NAME"] + "";
string ssJobTitle = Session["JobTitle"] + "";
//PostBack後停留在原畫面
Page.MaintainScrollPositionOnPostBack = true;
GBClass001 SBApp = new GBClass001();
if (rCaseId == "")
{
Response.Redirect("SWC001.aspx");
}
if (!IsPostBack)
{
GenerateDropDownList();
Data2Page(rCaseId, rDTLId);
}
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + "，您好";
}
//全區供用
SBApp.ViewRecord("審查表單", "update", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
//全區供用
}
protected void Page_Load(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string rDTLId = Request.QueryString["DTLNO"] + "";
string ssUserName = Session["NAME"] + "";
//PostBack後停留在原畫面
Page.MaintainScrollPositionOnPostBack = true;
string ssJobTitle = Session["JobTitle"] + "";
GBClass001 SBApp = new GBClass001();
if (rCaseId == "" || ssUserName == "")
{
//Response.Redirect("SWC001.aspx");
}
if (!IsPostBack)
{
if (rCaseId == "" && rDTLId != "AddNew")
{
rCaseId = Get03SWC000(rDTLId);
}
LBSWC000.Text = rCaseId.Trim() == "" ? rDTLId : rCaseId;
GenerateDropDownList();
Data2Page(rCaseId, rDTLId);
}
//全區供用
//SBApp.ViewRecord("水土保持施工監督檢查紀錄", "update", "");
//ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
//Visitor.Text = SBApp.GetVisitorsCount();
//TextUserName.Text = "";
if (ssUserName != "")
{
//TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
//全區供用
}
protected void Page_Load(object sender, EventArgs e)
{
string ssUserName = Session["NAME"] + "";
string ssUserType = Session["UserType"] + "";
string ssJobTitle = Session["JobTitle"] + "";
string rSWCNO = Request.QueryString["SWCNO"] + "";
string rOLANO = Request.QueryString["OLANO"] + "";
GBClass001 SBApp = new GBClass001();
if (!IsPostBack)
{
if (rOLANO == "")
{
Response.Redirect("SWC001.aspx");
}
else
{
GetOLA02Data(rSWCNO, rOLANO);
}
}
//全區供用
SBApp.ViewRecord("水土保持計畫暫停審查", "update", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
if (ssUserType == "02")
{
TitleLink00.Visible = true;
}
//全區供用
}
protected void Page_Load(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string rDTLId = Request.QueryString["DTLNO"] + "";
string ssUserName = Session["NAME"] + "";
//PostBack後停留在原畫面
Page.MaintainScrollPositionOnPostBack = true;
string ssJobTitle = Session["JobTitle"] + "";
GBClass001 SBApp = new GBClass001();
if (rCaseId == "" || ssUserName == "")
{
//Response.Redirect("SWC001.aspx");
}
if (!IsPostBack)
{
if (rCaseId == "" && rDTLId != "AddNew")
{
rCaseId = Get03SWC000(rDTLId);
}
LBSWC000.Text = rCaseId.Trim() == "" ? rDTLId : rCaseId;
GenerateDropDownList();
Data2Page(rCaseId, rDTLId);
}
//全區供用
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
//全區供用
}
protected void Page_Load(object sender, EventArgs e)
{
string rDETID = Request.QueryString["DisEventId"] + "";
string SessETID = Session["ID"] + "";
string ssUserName = Session["NAME"] + "";
string ssJobTitle = Session["JobTitle"] + "";
string ssUserType = Session["UserType"] + "";
GBClass001 SBApp = new GBClass001();
if (ssUserType == "03")
{
if (!IsPostBack)
{
GenerateDropDownList(); GetDisasterEventData(rDETID);
}
}
else
{
Response.Redirect("../SWCDOC/SWC001.aspx");
}
//以下全區公用
SBApp.ViewRecord("帳號管理", "view", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ssUserName = Session["NAME"] + "";
string ssUserType = Session["UserType"] + "";
string ssJobTitle = Session["JobTitle"] + "";
string rSWCNO = Request.QueryString["SWCNO"] + "";
GBClass001 SBApp = new GBClass001();
if (rSWCNO == "" || ssUserType == "")
{
Response.Redirect("SWC001.aspx");
}
if (!IsPostBack)
{
SetSwcCase(rSWCNO);
}
LockArea(ssUserType);
//全區供用
SBApp.ViewRecord("完工後水土保持設施檢查", "view", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
//全區供用
}
private void SendMailNotice(string gSWC000, string gReview)
{
GBClass001 SBApp = new GBClass001();
string[] arrayChkUserMsg = SBApp.GetUserMailData();
string ChkUserId = arrayChkUserMsg[0] + "";
string ChkUserName = arrayChkUserMsg[1] + "";
string ChkJobTitle = arrayChkUserMsg[2] + "";
string ChkMail = arrayChkUserMsg[3] + "";
string ChkMBGROUP = arrayChkUserMsg[4] + "";
//TextBox1.Text = strUserName;
string[] arrayUserId = ChkUserId.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayUserName = ChkUserName.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayJobTitle = ChkJobTitle.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayUserMail = ChkMail.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayMBGROUP = ChkMBGROUP.Split(new string[] { ";;" }, StringSplitOptions.None);
//送出提醒名單：義務人、承辦技師、審查公會
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select SWC.SWC002,SWC.SWC005, SWC.SWC012, SWC.SWC013,SWC.SWC013TEL, SWC.SWC022, SWC.SWC021ID,U.ETName,U.ETEmail,SWC.SWC108 from SWCCASE SWC ";
strSQLRV = strSQLRV + " LEFT JOIN ETUsers U on SWC.SWC021ID = U.ETID ";
strSQLRV = strSQLRV + " where SWC.SWC000 = '" + gSWC000 + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
string tSWC012 = readeSwc["SWC012"] + "";
string tSWC013 = readeSwc["SWC013"] + "";
string tSWC013TEL = readeSwc["SWC013TEL"] + "";
string tSWC022 = readeSwc["SWC022"] + "";
string tSWC021ID = readeSwc["SWC021ID"] + "";
string tETName = readeSwc["ETName"] + "";
string tETEmail = readeSwc["ETEmail"] + "";
string tSWC108 = readeSwc["SWC108"] + "";
//寄件名單
string SentMailGroup = "";
for (int i = 1; i < arrayUserId.Length; i++)
{
string aUserId = arrayUserId[i];
string aUserName = arrayUserName[i];
string aJobTitle = arrayJobTitle[i];
string aUserMail = arrayUserMail[i];
string aMBGROUP = arrayMBGROUP[i];
if (aUserName.Trim() == tSWC022.Trim())
{
SentMailGroup = SentMailGroup + ";;" + aUserMail;
}
}
//一人一封不打結…
//審查公會
string[] arraySentMail01 = SentMailGroup.Split(new string[] { ";;" }, StringSplitOptions.None);
string ssMailSub01 = tSWC022 + "您好，" + "水土保持計畫【" + tSWC002 + "】申請暫停審查已" + gReview;
string ssMailBody01 = "您好，【" + tSWC005 + "】申請暫停審查已" + gReview + "，詳情請至臺北市水土保持申請書件管理平台上瀏覽。" + "<br><br>";
ssMailBody01 = ssMailBody01 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
ssMailBody01 = ssMailBody01 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
bool MailTo01 = SBApp.Mail_Send(arraySentMail01, ssMailSub01, ssMailBody01);
//承辦技師
string[] arraySentMail02 = new string[] { tETEmail };
string ssMailSub02 = tETName + "技師您好，" + "水土保持計畫【" + tSWC002 + "】申請暫停審查已" + gReview;
string ssMailBody02 = "您好，【" + tSWC005 + "】申請暫停審查已" + gReview + "，詳情請至臺北市水土保持申請書件管理平台上瀏覽。" + "<br><br>";
ssMailBody02 = ssMailBody02 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
ssMailBody02 = ssMailBody02 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
bool MailTo02 = SBApp.Mail_Send(arraySentMail02, ssMailSub02, ssMailBody02);
//義務人
string[] arraySentMail03 = new string[] { tSWC108 };
string ssMailSub03 = tSWC013 + "您好，" + "水土保持計畫【" + tSWC002 + "】申請暫停審查已" + gReview;
string ssMailBody03 = "您好，【" + tSWC005 + "】申請暫停審查已" + gReview + "，詳情請至臺北市水土保持申請書件管理平台上瀏覽。" + "<br><br>";
ssMailBody03 = ssMailBody03 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
ssMailBody03 = ssMailBody03 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
bool MailTo03 = SBApp.Mail_Send(arraySentMail03, ssMailSub03, ssMailBody03);
}
readeSwc.Close();
objCmdSwc.Dispose();
}
}
private void SendMailNotice(string gSWC000)
{
GBClass001 SBApp = new GBClass001();
string[] arrayChkUserMsg = SBApp.GetUserMailData();
string ChkUserId = arrayChkUserMsg[0] + "";
string ChkUserName = arrayChkUserMsg[1] + "";
string ChkJobTitle = arrayChkUserMsg[2] + "";
string ChkMail = arrayChkUserMsg[3] + "";
string ChkMBGROUP = arrayChkUserMsg[4] + "";
//TextBox1.Text = strUserName;
string[] arrayUserId = ChkUserId.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayUserName = ChkUserName.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayJobTitle = ChkJobTitle.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayUserMail = ChkMail.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayMBGROUP = ChkMBGROUP.Split(new string[] { ";;" }, StringSplitOptions.None);
//送出提醒名單：承辦人、主管（科長，正工，股長，系統管理員）、審查公會
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select SWC.SWC002,SWC.SWC005, SWC.SWC012, SWC.SWC013,SWC.SWC013TEL, SWC.SWC022, SWC.SWC025, SWC.SWC045ID,U.ETName,U.ETEmail,SWC.SWC108 from SWCCASE SWC ";
strSQLRV = strSQLRV + " LEFT JOIN ETUsers U on SWC.SWC045ID = U.ETID ";
strSQLRV = strSQLRV + " where SWC.SWC000 = '" + gSWC000 + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
string tSWC012 = readeSwc["SWC012"] + "";
string tSWC013 = readeSwc["SWC013"] + "";
string tSWC013TEL = readeSwc["SWC013TEL"] + "";
string tSWC022 = readeSwc["SWC022"] + "";
string tSWC025 = readeSwc["SWC025"] + "";
string tSWC045ID = readeSwc["SWC045ID"] + "";
string tETName = readeSwc["ETName"] + "";
string tETEmail = readeSwc["ETEmail"] + "";
string tSWC108 = readeSwc["SWC108"] + "";
//寄件名單
string SentMailGroup = "";
for (int i = 1; i < arrayUserId.Length; i++)
{
string aUserId = arrayUserId[i];
string aUserName = arrayUserName[i];
string aJobTitle = arrayJobTitle[i];
string aUserMail = arrayUserMail[i];
string aMBGROUP = arrayMBGROUP[i];
if (aJobTitle.Trim() == "科長" || aJobTitle.Trim() == "正工" || aJobTitle.Trim() == "股長" || aMBGROUP.Trim() == "系統管理員" || aUserName.Trim() == tSWC025.Trim() || aUserName.Trim() == tSWC022.Trim())
{
//SentMailGroup = SentMailGroup + ";;" + aUserMail;
//一人一封不打結
string[] arraySentMail01 = new string[] { aUserMail };
string ssMailSub01 = aUserName + aJobTitle + "您好，" + tSWC012 + "水土保持計畫【" + tSWC002 + "】已新增暫停審查申請";
string ssMailBody01 = tSWC012 + "轄區【" + tSWC005 + "】已新增暫停審查申請，請上管理平台查看" + "<br><br>";
ssMailBody01 = ssMailBody01 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
ssMailBody01 = ssMailBody01 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
bool MailTo01 = SBApp.Mail_Send(arraySentMail01, ssMailSub01, ssMailBody01);
}
}
//string[] arraySentMail01 = SentMailGroup.Split(new string[] { ";;" }, StringSplitOptions.None);
//string ssMailSub01 = tSWC012 + "水土保持計畫【" + tSWC002 + "】已新增暫停審查申請";
//string ssMailBody01 = tSWC012 + "轄區【" + tSWC005 + "】已新增暫停審查申請，請上管理平台查看" + "<br><br>";
//ssMailBody01 = ssMailBody01 + "「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
//ssMailBody01 = ssMailBody01 + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
//bool MailTo01 = SBApp.Mail_Send(arraySentMail01, ssMailSub01, ssMailBody01);
}
readeSwc.Close();
objCmdSwc.Dispose();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string ssUserName = Session["NAME"] + "";
string ssUserType = Session["UserType"] + "";
string ssJobTitle = Session["JobTitle"] + "";
GBClass001 SBApp = new GBClass001();
LoadSwcClass01 LoadApp = new LoadSwcClass01();
string rRRPG = Request.QueryString["RRPG"] + "";
string rReceiveID = SBApp.Decrypt(Request.QueryString["ID"] + "");
string rReceivePW = SBApp.Decrypt(Request.QueryString["PD"] + "");
string rSWCNO = Request.QueryString["SWCNO"] + "";
string rOLANO = Request.QueryString["OLANO"] + "";
if (!IsPostBack)
{
if (rRRPG == "55")
{
Boolean LoginR = false;
LoginR = SBApp.GetLoginStatus(rReceiveID, rReceivePW, "03");
if (LoginR)
{
string ssUserName2 = Session["NAME"] + "";
LoadApp.LoadSwcCase("03", ssUserName);
}
string LINK = "OnlineApply002v.aspx?SWCNO=" + rSWCNO + "&OLANO=" + rOLANO;
Response.Redirect(LINK);
}
else
{
switch (ssUserType)
{
case "01":
case "02":
case "03":
case "04":
if (rOLANO == "")
{
Response.Redirect("SWC001.aspx");
}
else
{
GetOLA02Data(rSWCNO, rOLANO);
}
break;
default:
Response.Redirect("SWC000.aspx");
break;
}
}
}
//全區供用
SBApp.ViewRecord("水土保持計畫暫停審查", "update", "");
ToDay.Text = DateTime.Now.ToString("yyyy.M.d");
Visitor.Text = SBApp.GetVisitorsCount();
TextUserName.Text = "";
if (ssUserName != "")
{
TextUserName.Text = ssUserName + ssJobTitle + "，您好";
}
if (ssUserType == "02")
{
TitleLink00.Visible = true;
}
//全區供用
}
private void GetOLA02Data(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
string tDATALOCK = "";
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC000 = readeSwc["SWC000"] + "";
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
LBSWC000.Text = tSWC000;
LBSWC002.Text = tSWC002;
LBSWC005.Text = tSWC005;
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string rONA000 = GetONAID();
TXTONA001.Text = rONA000;
}
else
{
string strSQLRV2 = " select * from OnlineApply02 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " and ONA02001 = '" + v2 + "' ";
SqlDataReader readeONA;
SqlCommand objCmdONA = new SqlCommand(strSQLRV2, SwcConn);
readeONA = objCmdONA.ExecuteReader();
while (readeONA.Read())
{
string tONA002 = readeONA["ONA02002"] + "";
string tONA003 = readeONA["ONA02003"] + "";
string tONA004 = readeONA["ONA02004"] + "";
string tONA005 = readeONA["ONA02005"] + "";
string tONA006 = readeONA["ONA02006"] + "";
string tONA007 = readeONA["ONA02007"] + "";
string tONA008 = readeONA["ONA02008"] + "";
tDATALOCK = readeONA["DATALOCK"] + "";
TXTONA001.Text = v2;
TXTONA002.Text = SBApp.DateView(tONA002, "00");
TXTONA003.Text = SBApp.DateView(tONA003, "00");
TXTONA004.Text = tONA004;
if (tONA005 == "1")
{
CHKONA005.Checked = true;
}
if (tONA006 == "1")
{
CHKONA006.Checked = true;
}
if (tONA007 == "1")
{
CHKONA007.Checked = true;
}
if (tONA008 == "1")
{
CHKONA008.Checked = true;
}
}
}
}
if (tDATALOCK == "Y")
{
Response.Write("<script>alert('資料已送出，目前僅供瀏覽。'); location.href='OnlineApply002v.aspx?SWCNO=" + v + "&OLANO=" + v2 + "'; </script>");
}
}
private void Data2Page(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC005 = readeSwc["SWC005"] + "";
string tSWC007 = readeSwc["SWC007"] + "";
string tSWC013ID = readeSwc["SWC013ID"] + "";
string tSWC013 = readeSwc["SWC013"] + "";
string tSWC014 = readeSwc["SWC014"] + "";
string tSWC045ID = readeSwc["SWC045ID"] + "";
string tSWC021 = readeSwc["SWC021"] + "";
string tSWC038 = readeSwc["SWC038"] + "";
string tSWC039 = readeSwc["SWC039"] + "";
string tSWC043 = readeSwc["SWC043"] + "";
string tSWC044 = readeSwc["SWC044"] + "";
string tSWC045 = readeSwc["SWC045"] + "";
string tSWC051 = readeSwc["SWC051"] + "";
string tSWC052 = readeSwc["SWC052"] + "";
string tSWC058 = readeSwc["SWC058"] + "";
LBSWC000.Text = v;
LBSWC005.Text = tSWC005;
LBSWC005a.Text = tSWC005;
LBSWC007.Text = tSWC007;
LBSWC013ID.Text = tSWC013ID;
LBSWC013.Text = tSWC013;
LBSWC014.Text = tSWC014;
LBSWC021.Text = tSWC045;
LBSWC021Name.Text = SBApp.GetETUser(tSWC045ID, "OrgName");
LBSWC021OrgIssNo.Text = SBApp.GetETUser(tSWC045ID, "OrgIssNo");
LBSWC021OrgGUINo.Text = SBApp.GetETUser(tSWC045ID, "OrgGUINo");
LBSWC021OrgTel.Text = SBApp.GetETUser(tSWC045ID, "OrgTel");
LBSWC038.Text = SBApp.DateView(tSWC038, "04");
LBSWC039.Text = tSWC039;
LBSWC043.Text = SBApp.DateView(tSWC043, "04");
LBSWC044.Text = tSWC044;
LBSWC051.Text = SBApp.DateView(tSWC051, "04");
LBSWC052.Text = SBApp.DateView(tSWC052, "04");
LBSWC058.Text = SBApp.DateView(tSWC058, "04");
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string nIDF = GetDTLFID(v);
LBDTL001.Text = nIDF;
}
else
{
string strSQLRV2 = " select * from SWCDTL06 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " and DTLF000 = '" + v2 + "' ";
SqlDataReader readeDTL;
SqlCommand objCmdDTL = new SqlCommand(strSQLRV2, SwcConn);
readeDTL = objCmdDTL.ExecuteReader();
while (readeDTL.Read())
{
string tDTLF001 = readeDTL["DTLF001"] + "";
string tDTLF002 = readeDTL["DTLF002"] + "";
string tDTLF003 = readeDTL["DTLF003"] + "";
string tDTLF004 = readeDTL["DTLF004"] + "";
string tDTLF023 = readeDTL["DTLF023"] + "";
string tDTLF024 = readeDTL["DTLF024"] + "";
string tDTLF025 = readeDTL["DTLF025"] + "";
string tDTLF026 = readeDTL["DTLF026"] + "";
string tDTLF027 = readeDTL["DTLF027"] + "";
string tDTLF028 = readeDTL["DTLF028"] + "";
string tDTLF029 = readeDTL["DTLF029"] + "";
string tDTLF030 = readeDTL["DTLF030"] + "";
string tDTLF031 = readeDTL["DTLF031"] + "";
string tDTLF032 = readeDTL["DTLF032"] + "";
string tDTLF033 = readeDTL["DTLF033"] + "";
string tDTLF034 = readeDTL["DTLF034"] + "";
string tDTLF035 = readeDTL["DTLF035"] + "";
string tDTLF036 = readeDTL["DTLF036"] + "";
string tDTLF037 = readeDTL["DTLF037"] + "";
string tDTLF038 = readeDTL["DTLF038"] + "";
string tDTLF039 = readeDTL["DTLF039"] + "";
string tDTLF040 = readeDTL["DTLF040"] + "";
string tDTLF041 = readeDTL["DTLF041"] + "";
string tDTLF042 = readeDTL["DTLF042"] + "";
string tLOCKDATE = readeDTL["savedate"] + "";
LBDTL001.Text = tDTLF001;
TXTDTL002.Text = SBApp.DateView(tDTLF002, "04");;
TXTSENDDATE.Text = SBApp.DateView(tLOCKDATE, "04");
DDLDTL003.Text = tDTLF003;
TXTDTL004.Text = tDTLF004;
TXTDTL023.Text = tDTLF023;
TXTDTL024.Text = tDTLF024;
TXTDTL025.Text = tDTLF025.Replace("\r\n", "<br/>").Replace("\n\r", "<br/>");
TXTDTL026.Text = tDTLF026.Replace("\r\n", "<br/>").Replace("\n\r", "<br/>");
DDLDTL027.Text = tDTLF027;
TXTDTL028.Text = tDTLF028.Replace("\r\n", "<br/>").Replace("\n\r", "<br/>");
TXTDTL029.Text = tDTLF029;
TXTDTL030.Text = tDTLF030;
TXTDTL031.Text = tDTLF031;
TXTDTL032.Text = tDTLF032;
TXTDTL033.Text = tDTLF033;
TXTDTL034.Text = tDTLF034;
TXTDTL035.Text = tDTLF035;
TXTDTL036.Text = tDTLF036;
TXTDTL037.Text = tDTLF037;
TXTDTL038.Text = tDTLF038;
TXTDTL039.Text = tDTLF039;
TXTDTL040.Text = tDTLF040;
TXTDTL041.Text = tDTLF041;
TXTDTL042.Text = tDTLF042;
//檔案類處理
string[] arrayFileNameLink = new string[] { tDTLF024, tDTLF042 };
System.Web.UI.WebControls.HyperLink[] arrayLinkAppobj = new System.Web.UI.WebControls.HyperLink[] { Link024, Link042 };
for (int i = 0; i < arrayFileNameLink.Length; i++)
{
string strFileName = arrayFileNameLink[i];
System.Web.UI.WebControls.HyperLink FileLinkObj = arrayLinkAppobj[i];
FileLinkObj.Visible = false;
if (strFileName == "")
{
}
else
{
string tempLinkPateh = SwcUpLoadFilePath + v + "/" + strFileName;
FileLinkObj.Text = strFileName;
FileLinkObj.NavigateUrl = tempLinkPateh;
FileLinkObj.Visible = true;
}
}
//點擊放大圖片類處理
string[] arrayFileName = new string[] { tDTLF029, tDTLF030, tDTLF032, tDTLF034, tDTLF036, tDTLF038, tDTLF040 };
System.Web.UI.WebControls.HyperLink[] arrayImgAppobj = new System.Web.UI.WebControls.HyperLink[] { HyperLink029, HyperLink030, HyperLink032, HyperLink034, HyperLink036, HyperLink038, HyperLink040 };
for (int i = 0; i < arrayFileName.Length; i++)
{
string strFileName = arrayFileName[i];
System.Web.UI.WebControls.HyperLink ImgFileObj = arrayImgAppobj[i];
if (strFileName == "")
{
}
else
{
string tempImgPateh = SwcUpLoadFilePath + v + "/" + strFileName;
ImgFileObj.ImageUrl = tempImgPateh + "?ts=" + DateTime.Now.Millisecond;
ImgFileObj.NavigateUrl = tempImgPateh + "?ts=" + DateTime.Now.Millisecond;
}
}
}
}
}
}
private void FileUpLoadApp(string ChkType, FileUpload UpLoadBar, TextBox UpLoadText, string UpLoadStr, string UpLoadType, System.Web.UI.WebControls.Image UpLoadView, HyperLink UpLoadLink)
{
GBClass001 MyBassAppPj = new GBClass001();
string SwcFileName = "";
string CaseId = TXTETIDNo.Text + "";
if (UpLoadBar.HasFile)
{
string filename = UpLoadBar.FileName; // UpLoadBar.FileName 只有 "檔案名稱.附檔名"，並沒有 Client 端的完整理路徑
string extension = Path.GetExtension(filename).ToLowerInvariant();
// 判斷是否為允許上傳的檔案附檔名
switch (ChkType)
{
case "PIC":
List <string> allowedExtextsion01 = new List <string> {
".jpg", ".png"
};
if (allowedExtextsion01.IndexOf(extension) == -1)
{
error_msg.Text = MyBassAppPj.AlertMsg("請選擇 JPG PNG 檔案格式上傳，謝謝!!");
return;
}
break;
case "DOC":
List <string> allowedExtextsion02 = new List <string> {
".jpg", ".png", "doc", "pdf", "dwg", "dxf"
};
if (allowedExtextsion02.IndexOf(extension) == -1)
{
error_msg.Text = MyBassAppPj.AlertMsg("請選擇 JPG PNG DOC PDF DWG DXF 檔案格式上傳，謝謝!!");
return;
}
break;
}
// 限制檔案大小，限制為 10MB
int filesize = UpLoadBar.PostedFile.ContentLength;
if (filesize > 10000000)
{
error_msg.Text = MyBassAppPj.AlertMsg("請選擇 10Mb 以下檔案上傳，謝謝!!");
return;
}
// 檢查 Server 上該資料夾是否存在，不存在就自動建立
string serverDir = ConfigurationManager.AppSettings["SwcFileTemp"] + CaseId;
if (Directory.Exists(serverDir) == false)
{
Directory.CreateDirectory(serverDir);
}
Session[UpLoadStr] = "有檔案";
//SwcFileName = CaseId + UpLoadType + System.IO.Path.GetExtension(UpLoadBar.FileName);
SwcFileName = Path.GetFileNameWithoutExtension(filename) + UpLoadType + System.IO.Path.GetExtension(UpLoadBar.FileName);
UpLoadText.Text = SwcFileName;
// 判斷 Server 上檔案名稱是否有重覆情況，有的話必須進行更名
// 使用 Path.Combine 來集合路徑的優點
// 以前發生過儲存 Table 內的是 \\ServerName\Dir（最後面沒有 \ 符號），
// 直接跟 FileName 來進行結合，會變成 \\ServerName\DirFileName 的情況，
// 資料夾路徑的最後面有沒有 \ 符號變成還需要判斷，但用 Path.Combine 來結合的話，
// 資料夾路徑沒有 \ 符號，會自動補上，有的話，就直接結合
string serverFilePath = Path.Combine(serverDir, SwcFileName);
string fileNameOnly = Path.GetFileNameWithoutExtension(SwcFileName);
int fileCount = 1;
//while (File.Exists(serverFilePath))
//{
// // 重覆檔案的命名規則為 檔名_1、檔名_2 以此類推
// filename = string.Concat(fileNameOnly, "_", fileCount, extension);
// serverFilePath = Path.Combine(serverDir, filename);
// fileCount++;
//}
// 把檔案傳入指定的 Server 內路徑
try
{
UpLoadBar.SaveAs(serverFilePath);
//error_msg.Text = "檔案上傳成功";
switch (ChkType)
{
case "PIC":
UpLoadView.Attributes.Add("src", "..\\UpLoadFiles\\temp\\" + CaseId + "\\" + SwcFileName + "?ts=" + System.DateTime.Now.Millisecond);
//UpLoadView.ImageUrl = "..\\UpLoadFiles\\temp\\" + CaseId +"\\"+ geohfilename;
imagestitch(UpLoadView, serverDir + "\\" + SwcFileName, 320, 180);
break;
case "DOC":
UpLoadLink.Text = SwcFileName;
UpLoadLink.NavigateUrl = "..\\UpLoadFiles\\temp\\" + CaseId + "\\" + SwcFileName + "?ts=" + System.DateTime.Now.Millisecond;
UpLoadLink.Visible = true;
break;
}
}
catch (Exception ex)
{
//error_msg.Text = "檔案上傳失敗";
}
}
else
{
Session[UpLoadStr] = "";
}
}
private void GetOLA02Data(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
string tDATALOCK = "";
string DataLock2 = "";
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC000 = readeSwc["SWC000"] + "";
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
LBSWC000.Text = tSWC000;
LBSWC002.Text = tSWC002;
LBSWC005.Text = tSWC005;
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string rONA000 = GetONAID();
TXTONA001.Text = rONA000;
}
else
{
string strSQLRV2 = " select * from OnlineApply02 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " and ONA02001 = '" + v2 + "' ";
SqlDataReader readeONA;
SqlCommand objCmdONA = new SqlCommand(strSQLRV2, SwcConn);
readeONA = objCmdONA.ExecuteReader();
while (readeONA.Read())
{
string tONA002 = readeONA["ONA02002"] + "";
string tONA003 = readeONA["ONA02003"] + "";
string tONA004 = readeONA["ONA02004"] + "";
string tONA005 = readeONA["ONA02005"] + "";
string tONA006 = readeONA["ONA02006"] + "";
string tONA007 = readeONA["ONA02007"] + "";
string tONA008 = readeONA["ONA02008"] + "";
string tReviewResults = readeONA["ReviewResults"] + "";
string tResultsExplain = readeONA["ResultsExplain"] + "";
string tReviewDoc = readeONA["ReviewDoc"] + "";
string tLOCKUSER2 = readeONA["LOCKUSER2"] + "";
tDATALOCK = readeONA["DATALOCK"] + "";
DataLock2 = readeONA["DATALOCK2"] + "";
TXTONA001.Text = v2;
TXTONA002.Text = SBApp.DateView(tONA002, "02");
TXTONA003.Text = SBApp.DateView(tONA003, "02");
TXTONA004.Text = tONA004;
if (tONA005 == "1")
{
LBONA005.Visible = true;
}
if (tONA006 == "1")
{
LBONA006.Visible = true;
}
if (tONA007 == "1")
{
LBONA007.Visible = true;
}
if (tONA008 == "1")
{
LBONA008.Visible = true;
}
if (tReviewResults == "1")
{
CHKRRa.Checked = true; LBRR.Text = "審查結果：准予通過";
}
if (tReviewResults == "0")
{
CHKRRb.Checked = true; LBRR.Text = "審查結果：駁回";
}
if (tResultsExplain.Trim() != "")
{
LBResultsExplain.Text = "：" + tResultsExplain;
}
ResultsExplain.Text = tResultsExplain;
TXTReviewDoc.Text = tReviewDoc;
ReviewID.Text = SBApp.GetGeoUser(tLOCKUSER2, "Name");
//檔案類處理
string[] arrayFileNameLink = new string[] { tReviewDoc };
System.Web.UI.WebControls.HyperLink[] arrayLinkAppobj = new System.Web.UI.WebControls.HyperLink[] { LinkReviewDoc };
for (int i = 0; i < arrayFileNameLink.Length; i++)
{
string strFileName = arrayFileNameLink[i];
System.Web.UI.WebControls.HyperLink FileLinkObj = arrayLinkAppobj[i];
FileLinkObj.Visible = false;
if (strFileName == "")
{
}
else
{
string tempLinkPateh = SwcUpLoadFilePath + v + "/" + strFileName;
FileLinkObj.Text = strFileName;
FileLinkObj.NavigateUrl = tempLinkPateh;
FileLinkObj.Visible = true;
}
}
}
}
}
string ssUserType = Session["UserType"] + "";
if (ssUserType == "03" && DataLock2 != "Y")
{
LBResultsExplain.Visible = false;
ReviewResults.Visible = true;
DataLock.Visible = true;
SaveCase.Visible = true;
}
if (DataLock2 == "Y")
{
ReViewUL.Visible = false;
ResultsExplain.Visible = false;
ReviewResults.Visible = true;
LBRR.Visible = true;
CHKRRa.Visible = false;
CHKRRb.Visible = false;
DataLock.Visible = false;
SaveCase.Visible = false;
}
}
private void Data2Page(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC005 = readeSwc["SWC005"] + "";
LBSWC000.Text = v;
LBSWC005.Text = tSWC005;
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string nIDA = GetDTLAID(v);
LBDTL001.Text = nIDA;
}
else
{
string strSQLRV2 = " select * from SWCDTL02 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " and DTLB000 = '" + v2 + "' ";
SqlDataReader readeDTL;
SqlCommand objCmdDTL = new SqlCommand(strSQLRV2, SwcConn);
readeDTL = objCmdDTL.ExecuteReader();
while (readeDTL.Read())
{
string tDTLB001 = readeDTL["DTLB001"] + "";
string tDTLB002 = readeDTL["DTLB002"] + "";
string tDTLB003 = readeDTL["DTLB003"] + "";
string tDTLB004 = readeDTL["DTLB004"] + "";
string tDTLB006 = readeDTL["DTLB006"] + "";
string tDTLB007 = readeDTL["DTLB007"] + "";
string tDTLB008 = readeDTL["DTLB008"] + "";
string tDTLB009 = readeDTL["DTLB009"] + "";
string tDTLB010 = readeDTL["DTLB010"] + "";
string tDTLB011 = readeDTL["DTLB011"] + "";
string tDTLB012 = readeDTL["DTLB012"] + "";
string tDTLB013 = readeDTL["DTLB013"] + "";
string tDTLB014 = readeDTL["DTLB014"] + "";
string tDTLB015 = readeDTL["DTLB015"] + "";
string tDTLB016 = readeDTL["DTLB016"] + "";
string tDTLB017 = readeDTL["DTLB017"] + "";
string tDTLB018 = readeDTL["DTLB018"] + "";
string tDTLB019 = readeDTL["DTLB019"] + "";
string tDTLB020 = readeDTL["DTLB020"] + "";
string tDTLB021 = readeDTL["DTLB021"] + "";
string tDTLB022 = readeDTL["DTLB022"] + "";
string tDTLB023 = readeDTL["DTLB023"] + "";
LBDTL001.Text = tDTLB001;
TXTDTL002.Text = tDTLB002;
TXTDTL003.Text = tDTLB003;
TXTDTL004.Text = tDTLB004;
//TXTDTL006.Text = SBApp.DateView(tDTLB006, "00");
if (tDTLB007 == "1")
{
CHKDTL007.Text = "已設立無誤";
}
if (tDTLB008 == "1")
{
CHKDTL008.Text = "未設立";
}
if (tDTLB009 == "1")
{
CHKDTL009.Text = "資訊缺漏：";
TXTDTL010.Text = tDTLB010;
}
DropList011.Text = tDTLB011;
DropList012.Text = tDTLB012;
DropList013.Text = tDTLB013;
TXTDTL014.Text = tDTLB014;
if (tDTLB015 == "1")
{
CHKBOX015.Text = "正常運作";
}
if (tDTLB016 == "1")
{
CHKBOX016.Text = "電話無人接聽";
}
if (tDTLB017 == "1")
{
CHKBOX017.Text = "電話號碼錯誤";
}
if (tDTLB018 == "1")
{
CHKBOX018.Text = "其他：";
TXTDTL019.Text = tDTLB019;
}
TXTDTL020.Text = tDTLB001;
TXTDTL021.Text = tDTLB021.Replace("\r\n", "<br/>").Replace("\n\r", "<br/>");
TXTDTL022.Text = tDTLB022;
//檔案類處理
string[] arrayFileNameLink = new string[] { tDTLB023 };
System.Web.UI.WebControls.HyperLink[] arrayLinkAppobj = new System.Web.UI.WebControls.HyperLink[] { Link023 };
for (int i = 0; i < arrayFileNameLink.Length; i++)
{
string strFileName = arrayFileNameLink[i];
System.Web.UI.WebControls.HyperLink FileLinkObj = arrayLinkAppobj[i];
FileLinkObj.Visible = false;
if (strFileName == "")
{
}
else
{
string tempLinkPateh = SwcUpLoadFilePath + v + "/" + strFileName;
FileLinkObj.Text = strFileName;
FileLinkObj.NavigateUrl = tempLinkPateh;
FileLinkObj.Visible = true;
}
}
//圖片類處理
string[] arrayFileName = new string[] { tDTLB022 };
System.Web.UI.WebControls.Image[] arrayImgAppobj = new System.Web.UI.WebControls.Image[] { TXTDTL022_img };
for (int i = 0; i < arrayFileName.Length; i++)
{
string strFileName = arrayFileName[i];
System.Web.UI.WebControls.Image ImgFileObj = arrayImgAppobj[i];
if (strFileName == "")
{
}
else
{
string tempImgPateh = SwcUpLoadFilePath + v + "/" + strFileName;
ImgFileObj.Attributes.Add("src", tempImgPateh + "?ts=" + DateTime.Now.Millisecond);
}
}
}
}
}
}
private void Data2Page(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC005 = readeSwc["SWC005"] + "";
LBSWC000.Text = v;
LBSWC005.Text = tSWC005;
LBSWC005a.Text = tSWC005;
LBSWC005_2.Text = tSWC005;
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string nIDA = GetDTLAID(v);
LBDTL001.Text = nIDA;
}
else
{
string strSQLRV2 = " select * from SWCDTL01 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " AND DTLA000 = '" + v2 + "' ";
SqlDataReader readeDTL;
SqlCommand objCmdDTL = new SqlCommand(strSQLRV2, SwcConn);
readeDTL = objCmdDTL.ExecuteReader();
while (readeDTL.Read())
{
string tDTLA001 = readeDTL["DTLA001"] + "";
string tDTLA002 = readeDTL["DTLA002"] + "";
string tDTLA003 = readeDTL["DTLA003"] + "";
string tDTLA004 = readeDTL["DTLA004"] + "";
string tDTLA005 = readeDTL["DTLA005"] + "";
string tDTLA006 = readeDTL["DTLA006"] + "";
string tDTLA007 = readeDTL["DTLA007"] + "";
string tDTLA008 = readeDTL["DTLA008"] + "";
string tDTLA009 = readeDTL["DTLA009"] + "";
string tDTLA010 = readeDTL["DTLA010"] + "";
string tDTLA011 = readeDTL["DTLA011"] + "";
string tDTLA012 = readeDTL["DTLA012"] + "";
string tDTLA013 = readeDTL["DTLA013"] + "";
string tDTLA014 = readeDTL["DTLA014"] + "";
string tDTLA015 = readeDTL["DTLA015"] + "";
string tDTLA016 = readeDTL["DTLA016"] + "";
string tDTLA017 = readeDTL["DTLA017"] + "";
string tDTLA018 = readeDTL["DTLA018"] + "";
string tDTLA019 = readeDTL["DTLA019"] + "";
string tDTLA020 = readeDTL["DTLA020"] + "";
string tDTLA021 = readeDTL["DTLA021"] + "";
string tDTLA022 = readeDTL["DTLA022"] + "";
string tDTLA023 = readeDTL["DTLA023"] + "";
string tDTLA024 = readeDTL["DTLA024"] + "";
string tDTLA025 = readeDTL["DTLA025"] + "";
string tDTLA026 = readeDTL["DTLA026"] + "";
string tDTLA027 = readeDTL["DTLA027"] + "";
string tDTLA028 = readeDTL["DTLA028"] + "";
string tDTLA029 = readeDTL["DTLA029"] + "";
string tDTLA030 = readeDTL["DTLA030"] + "";
string tDTLA031 = readeDTL["DTLA031"] + "";
string tDTLA032 = readeDTL["DTLA032"] + "";
string tDATALOCK = readeDTL["DATALOCK"] + "";
LBDTL001.Text = tDTLA001;
TXTDTL003.Text = SBApp.DateView(tDTLA003, "00");
TXTDTL004.Text = tDTLA004;
DDLDTL006.SelectedValue = tDTLA006;
TXTDTL007.Text = SBApp.DateView(tDTLA007, "00");
TXTDTL008.Text = tDTLA008;
TXTDTL009.Text = tDTLA009;
TXTDTL010.Text = tDTLA010;
TXTDTL011.Text = tDTLA011;
TXTDTL012.Text = tDTLA012;
TXTDTL013.Text = tDTLA013;
TXTDTL014.Text = tDTLA014;
TXTDTL015.Text = tDTLA015;
TXTDTL016.Text = tDTLA016;
TXTDTL017.Text = tDTLA017;
TXTDTL018.Text = tDTLA018;
TXTDTL019.Text = tDTLA019;
TXTDTL020.Text = tDTLA020;
TXTDTL021.Text = tDTLA021;
TXTDTL022.Text = tDTLA022;
TXTDTL023.Text = tDTLA023;
TXTDTL024.Text = tDTLA024;
TXTDTL025.Text = tDTLA025;
TXTDTL026.Text = tDTLA026;
TXTDTL027.Text = tDTLA027;
TXTDTL028.Text = tDTLA028;
TXTDTL029.Text = tDTLA029;
TXTDTL030.Text = tDTLA030;
TXTDTL031.Text = tDTLA031;
TXTDTL032.Text = tDTLA032;
//點擊放大圖片類處理
string[] arrayFileName2 = new string[] { tDTLA018, tDTLA021, tDTLA023, tDTLA025, tDTLA027, tDTLA029, tDTLA031 };
System.Web.UI.WebControls.HyperLink[] arrayImgAppobj2 = new System.Web.UI.WebControls.HyperLink[] { HyperLink018, HyperLink021, HyperLink023, HyperLink025, HyperLink027, HyperLink029, HyperLink031 };
for (int i = 0; i < arrayFileName2.Length; i++)
{
string strFileName = arrayFileName2[i];
System.Web.UI.WebControls.HyperLink ImgFileObj = arrayImgAppobj2[i];
if (strFileName == "")
{
}
else
{
string tempImgPateh = SwcUpLoadFilePath + v + "/" + strFileName;
ImgFileObj.ImageUrl = tempImgPateh + "?ts=" + DateTime.Now.Millisecond;
ImgFileObj.NavigateUrl = tempImgPateh + "?ts=" + DateTime.Now.Millisecond;
}
}
//檔案類處理
string[] arrayFileNameLink = new string[] { tDTLA020 };
System.Web.UI.WebControls.HyperLink[] arrayLinkAppobj = new System.Web.UI.WebControls.HyperLink[] { Link020 };
for (int i = 0; i < arrayFileNameLink.Length; i++)
{
string strFileName = arrayFileNameLink[i];
System.Web.UI.WebControls.HyperLink FileLinkObj = arrayLinkAppobj[i];
FileLinkObj.Visible = false;
if (strFileName == "")
{
}
else
{
string tempLinkPateh = SwcUpLoadFilePath + v + "/" + strFileName;
FileLinkObj.Text = strFileName;
FileLinkObj.NavigateUrl = tempLinkPateh;
FileLinkObj.Visible = true;
}
}
//按鈕處理
if (tDATALOCK == "Y")
{
DataLock.Visible = false;
SaveCase.Visible = false;
Response.Write("<script>alert('資料已送出，目前僅供瀏覽。'); location.href='SWCDT001v.aspx?SWCNO=" + v + "&DTLNO=" + v2 + "'; </script>");
}
}
}
}
}
protected void SaveAccount_Click(object sender, EventArgs e)
{
error_msg.Text = "";
string SSPW = Session["PW"] + "";
string SaveDate = "Y";
string NewAccount = TXTETIDNo.Text + "";
string gETID1 = TXTETPW.Text + "";
string gETID2 = TXTETPWChk.Text + "";
string gETName = TXTETName.Text + "";
string gETTel = TXTETTel.Text + "";
string gETEmail = TXTETEmail.Text + "";
string gETOrgName = TXTETOrgName.Text + "";
string gETOrgGUINo = TXTETOrgGUINo.Text + "";
string gETOrgAddr = TXTETOrgAddr.Text + "";
string gETOrgTel = TXTETOrgTel.Text + "";
string gETCOPC = TXTETCOPC.Text + "";
string gETTCNo01 = TXTETTCNo01.Text + "";
string gETTCNo02 = TXTETTCNo02.Text + "";
string gETTCNo03 = TXTETTCNo03.Text + "";
string gETTCNo04 = TXTETTCNo04.Text + "";
string gETOrgIssNo = TXTETOrgIssNo.Text + "";
string gSYSID = TXTSYSID.Text + "";
string gOldPw = TXTETPWOLD.Text + "";
string gTCNo01ED = TXTTCNo01ED.Text + "";
string gTCNo02ED = TXTTCNo02ED.Text + "";
string gTCNo03ED = TXTTCNo03ED.Text + "";
string gTCNo04ED = TXTTCNo04ED.Text + "";
string gETCOPCExp = TXTETCOPCExp.Text + "";
GBClass001 SBApp = new GBClass001();
if (gOldPw == "" && (gETID1 != "" || gETID2 != ""))
{
SaveDate = "N";
error_msg.Text = SBApp.AlertMsg("請輸入舊密碼，謝謝!!");
TXTETIDNo.Focus();
return;
}
if (gOldPw != "" && (SSPW != gOldPw))
{
SaveDate = "N";
error_msg.Text = SBApp.AlertMsg("密碼不正確請重新輸入，謝謝!!");
TXTETIDNo.Focus();
return;
}
if (gETID1 != gETID2)
{
SaveDate = "N";
error_msg.Text = SBApp.AlertMsg("密碼與確認密碼不符");
TXTETPW.Focus();
return;
}
if (SaveDate == "Y")
{
string UserSqlStr = "";
UserSqlStr = UserSqlStr + " Update ETUsers Set ";
if (gETID1 != "")
{
UserSqlStr = UserSqlStr + " ETPW ='" + gETID1 + "', ";
Session["PW"] = gETID1;
}
UserSqlStr = UserSqlStr + " ETName =N'" + gETName + "', ";
UserSqlStr = UserSqlStr + " ETTel =N'" + gETTel + "', ";
UserSqlStr = UserSqlStr + " ETEmail =N'" + gETEmail + "', ";
UserSqlStr = UserSqlStr + " ETOrgName =N'" + gETOrgName + "', ";
UserSqlStr = UserSqlStr + " ETOrgGUINo =N'" + gETOrgGUINo + "', ";
UserSqlStr = UserSqlStr + " ETOrgAddr =N'" + gETOrgAddr + "', ";
UserSqlStr = UserSqlStr + " ETOrgTel =N'" + gETOrgTel + "', ";
UserSqlStr = UserSqlStr + " ETCOPC =N'" + gETCOPC + "', ";
UserSqlStr = UserSqlStr + " ETTCNo01 =N'" + gETTCNo01 + "', ";
UserSqlStr = UserSqlStr + " ETTCNo02 =N'" + gETTCNo02 + "', ";
UserSqlStr = UserSqlStr + " ETTCNo03 =N'" + gETTCNo03 + "', ";
UserSqlStr = UserSqlStr + " ETTCNo04 =N'" + gETTCNo04 + "', ";
UserSqlStr = UserSqlStr + " ETOrgIssNo =N'" + gETOrgIssNo + "', ";
UserSqlStr = UserSqlStr + " TCNo01ED =N'" + gTCNo01ED + "', ";
UserSqlStr = UserSqlStr + " TCNo02ED =N'" + gTCNo02ED + "', ";
UserSqlStr = UserSqlStr + " TCNo03ED =N'" + gTCNo03ED + "', ";
UserSqlStr = UserSqlStr + " TCNo04ED =N'" + gTCNo04ED + "', ";
UserSqlStr = UserSqlStr + " ETCOPCExp =N'" + gETCOPCExp + "', ";
UserSqlStr = UserSqlStr + " SYSID =N'" + gSYSID + "', ";
UserSqlStr = UserSqlStr + " saveuser = N'" + NewAccount + "', ";
UserSqlStr = UserSqlStr + " savedate = getdate() ";
UserSqlStr = UserSqlStr + " Where ETIDNo = '" + NewAccount + "'";
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SWCConn = new SqlConnection(connectionString.ConnectionString))
{
SWCConn.Open();
SqlCommand objCmdUser = new SqlCommand(UserSqlStr, SWCConn);
objCmdUser.ExecuteNonQuery();
objCmdUser.Dispose();
}
//上傳檔案…
UpLoadTempFileMoveChk(NewAccount);
GetUserData(NewAccount);
Response.Write("<script>alert('資料已存檔'); location.href='SWC001.aspx'; </script>");
}
}
protected void SwcLogin_Click(object sender, ImageClickEventArgs e)
{
Boolean LoginR = false;
string sUserType = loginChange.SelectedValue + "";
string sInputID = TXTID.Text + "";
string sInputPW = TXTPW.Text + "";
GBClass001 SwcApp = new GBClass001();
LoadSwcClass01 LoadApp = new LoadSwcClass01();
error_msg.Text = "";
sInputID = SwcApp.SDQQSTR(sInputID);
//sInputPW = SwcApp.SDQQSTR(sInputPW);
if (sInputID == "" || sInputPW == "")
{
error_msg.Text = SwcApp.AlertMsg("請輸入帳號或密碼!!!");
}
else
{
switch (sUserType)
{
case "水土保持義務人":
LoginR = SwcApp.GetLoginStatus(sInputID, sInputPW, "01");
break;
case "承辦/監造技師":
LoginR = SwcApp.GetLoginStatus(sInputID, sInputPW, "02");
break;
case "工務局大地工程處":
LoginR = SwcApp.GetLoginStatus(sInputID, sInputPW, "03");
if (LoginR)
{
string ssUserName = Session["NAME"] + "";
//LoadApp.LoadSwcCase("03", ssUserName);
}
break;
case "審查/檢查單位":
LoginR = SwcApp.GetLoginStatus(sInputID, sInputPW, "04");
if (LoginR)
{
string ssUserName = Session["NAME"] + "";
//LoadApp.LoadSwcCase("04", ssUserName);
}
break;
}
if (LoginR)
{
Response.Redirect("~/PriPage/SwcPrivacy_01.aspx");
}
else
{
error_msg.Text = SwcApp.AlertMsg("密碼輸入錯誤 如忘記密碼請聯繫大地工程處02-27591109");
}
}
}
protected void AddNewAcc_Click(object sender, EventArgs e)
{
string SaveDate = "Y";
string NewAccount = TXTETIDNo.Text + "";
string gETID1 = TXTETPW.Text + "";
string gETID2 = TXTETPWChk.Text + "";
string gETName = TXTETName.Text + "";
string gETTel = TXTETTel.Text + "";
string gETEmail = TXTETEmail.Text + "";
string gETOrgName = TXTETOrgName.Text + "";
string gETOrgGUINo = TXTETOrgGUINo.Text = "";
string gETOrgAddr = TXTETOrgAddr.Text + "";
string gETOrgTel = TXTETOrgTel.Text + "";
string gETCOPC = TXTETCOPC.Text + "";
string gETTCNo01 = TXTETTCNo01.Text + "";
string gETTCNo02 = TXTETTCNo02.Text + "";
string gETTCNo03 = TXTETTCNo03.Text + "";
string gETTCNo04 = TXTETTCNo04.Text + "";
string gETOrgIssNo = TXTETOrgIssNo.Text + "";
string gSYSID = TXTSYSID.Text + "";
string gTCNo01ED = TXTTCNo01ED.Text + "";
string gTCNo02ED = TXTTCNo02ED.Text + "";
string gTCNo03ED = TXTTCNo03ED.Text + "";
string gTCNo04ED = TXTTCNo04ED.Text + "";
string gETCOPCExp = TXTETCOPCExp.Text + "";
GBClass001 SBApp = new GBClass001();
NewAccount = NewAccount.ToUpper();
if (NewAccount == "")
{
error_msg.Text = SBApp.AlertMsg("身分證字號務必填登，謝謝!!");
TXTETIDNo.Focus();
return;
}
if (gETID1 != gETID2)
{
error_msg.Text = SBApp.AlertMsg("密碼與確認密碼不符");
TXTETPW.Focus();
return;
}
//帳號重覆檢查
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SWCConn = new SqlConnection(connectionString.ConnectionString))
{
SWCConn.Open();
string strSQLUS = " select ETIDNo from ETUsers ";
strSQLUS = strSQLUS + " where ETIDNo ='" + NewAccount + "' ";
SqlDataReader readerUser;
SqlCommand objCmdUser = new SqlCommand(strSQLUS, SWCConn);
readerUser = objCmdUser.ExecuteReader();
if (readerUser.HasRows)
{
Response.Write("<script>alert('您好，此帳號已重複申請，請再次確認密碼，或與大地工程處聯繫，謝謝。'); location.href='SWC000.aspx'; </script>");
TXTETIDNo.Focus();
SaveDate = "N";
return;
}
}
string UserSqlStr = "";
if (SaveDate == "Y")
{
UserSqlStr = UserSqlStr + " INSERT INTO ETUsers (ETID,ETIDNo,ETStatus,status) VALUES ('" + NewAccount + "','" + NewAccount + "','0','申請中') ;";
UserSqlStr = UserSqlStr + " Update ETUsers Set ";
UserSqlStr = UserSqlStr + " ETPW =N'" + gETID1 + "', ";
UserSqlStr = UserSqlStr + " ETName =N'" + gETName + "', ";
UserSqlStr = UserSqlStr + " ETTel =N'" + gETTel + "', ";
UserSqlStr = UserSqlStr + " ETEmail =N'" + gETEmail + "', ";
UserSqlStr = UserSqlStr + " ETOrgName =N'" + gETOrgName + "', ";
UserSqlStr = UserSqlStr + " ETOrgGUINo =N'" + gETOrgGUINo + "', ";
UserSqlStr = UserSqlStr + " ETOrgAddr =N'" + gETOrgAddr + "', ";
UserSqlStr = UserSqlStr + " ETOrgTel =N'" + gETOrgTel + "', ";
UserSqlStr = UserSqlStr + " ETCOPC =N'" + gETCOPC + "', ";
UserSqlStr = UserSqlStr + " ETTCNo01 =N'" + gETTCNo01 + "', ";
UserSqlStr = UserSqlStr + " ETTCNo02 =N'" + gETTCNo02 + "', ";
UserSqlStr = UserSqlStr + " ETTCNo03 =N'" + gETTCNo03 + "', ";
UserSqlStr = UserSqlStr + " ETTCNo04 =N'" + gETTCNo04 + "', ";
UserSqlStr = UserSqlStr + " ETOrgIssNo =N'" + gETOrgIssNo + "', ";
UserSqlStr = UserSqlStr + " TCNo01ED =N'" + gTCNo01ED + "', ";
UserSqlStr = UserSqlStr + " TCNo02ED =N'" + gTCNo02ED + "', ";
UserSqlStr = UserSqlStr + " TCNo03ED =N'" + gTCNo03ED + "', ";
UserSqlStr = UserSqlStr + " TCNo04ED =N'" + gTCNo04ED + "', ";
UserSqlStr = UserSqlStr + " ETCOPCExp =N'" + gETCOPCExp + "', ";
UserSqlStr = UserSqlStr + " SYSID ='" + gSYSID + "', ";
UserSqlStr = UserSqlStr + " saveuser = '******', ";
UserSqlStr = UserSqlStr + " savedate = getdate() ";
UserSqlStr = UserSqlStr + " Where ETIDNo = '" + NewAccount + "'";
using (SqlConnection SWCConn = new SqlConnection(connectionString.ConnectionString))
{
SWCConn.Open();
SqlCommand objCmdUser = new SqlCommand(UserSqlStr, SWCConn);
objCmdUser.ExecuteNonQuery();
objCmdUser.Dispose();
GBClass001 CL01 = new GBClass001();
CL01.Mail_Send(GetMailTo(), MailSub(), MailBody());
}
//上傳檔案…
UpLoadTempFileMoveChk(NewAccount);
}
GetUserData(NewAccount);
Response.Write("<script>alert('已送出帳號申請，請等待審核通知，申請結果將以E-mail通知。'); location.href='SWC000.aspx'; </script>");
}
private void GetOLA02Data(string v, string v2)
{
GBClass001 SBApp = new GBClass001();
string tDATALOCK = "";
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC000 = readeSwc["SWC000"] + "";
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
string tSWC013 = readeSwc["SWC013"] + "";
string tSWC013ID = readeSwc["SWC013ID"] + "";
string tSWC014 = readeSwc["SWC014"] + "";
string tSWC038 = readeSwc["SWC038"] + "";
string tSWC039 = readeSwc["SWC039"] + "";
string tSWC045ID = readeSwc["SWC045ID"] + "";
LBSWC000.Text = tSWC000;
LBSWC002.Text = tSWC002;
LBSWC005.Text = tSWC005;
LBSWC013.Text = tSWC013;
//LBSWC013a.Text = tSWC013;
LBSWC013ID.Text = tSWC013ID;
LBSWC014.Text = tSWC014;
LBSWC038.Text = SBApp.DateView(tSWC038, "00");
LBSWC039.Text = tSWC039;
LBSWC045Name.Text = SBApp.GetETUser(tSWC045ID, "Name");
//LBSWC045a.Text = SBApp.GetETUser(tSWC045ID, "Name");
LBSWC045OrgIssNo.Text = SBApp.GetETUser(tSWC045ID, "OrgIssNo");
LBSWC045OrgName.Text = SBApp.GetETUser(tSWC045ID, "OrgName");
LBSWC045OrgGUINo.Text = SBApp.GetETUser(tSWC045ID, "OrgGUINo");
LBSWC045OrgAddr.Text = SBApp.GetETUser(tSWC045ID, "OrgAddr");
}
readeSwc.Close();
objCmdSwc.Dispose();
ShowGvAll(v);
if (v2 == "AddNew")
{
string rONA000 = GetONAID();
TXTONA001.Text = rONA000;
TXTONA002.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
else
{
string strSQLRV2 = " select * from OnlineApply04 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " and ONA04001 = '" + v2 + "' ";
SqlDataReader readeONA;
SqlCommand objCmdONA = new SqlCommand(strSQLRV2, SwcConn);
readeONA = objCmdONA.ExecuteReader();
while (readeONA.Read())
{
string tONA002 = readeONA["ONA04002"] + "";
string tONA003 = readeONA["ONA04003"] + "";
string tONA004 = readeONA["ONA04004"] + "";
string tONA005 = readeONA["ONA04005"] + "";
string tONA006 = readeONA["ONA04006"] + "";
string tONA007 = readeONA["ONA04007"] + "";
string tONA008 = readeONA["ONA04008"] + "";
string tONA009 = readeONA["ONA04009"] + "";
string tONA010 = readeONA["ONA04010"] + "";
string tONA011 = readeONA["ONA04011"] + "";
string tONA012 = readeONA["ONA04012"] + "";
string tONA013 = readeONA["ONA04013"] + "";
tDATALOCK = readeONA["DATALOCK"] + "";
TXTONA001.Text = v2;
TXTONA002.Text = SBApp.DateView(tONA002, "00");
TXTONA003.Text = SBApp.DateView(tONA003, "00");
TXTONA004.Text = SBApp.DateView(tONA004, "00");
TXTONA005.Text = tONA005;
TXTONA006.Text = tONA006;
TXTONA007.Text = tONA007;
TXTONA008.Text = tONA008;
TXTONA009.Text = tONA009;
TXTONA010.Text = tONA010;
//TXTONA011.Text = SBApp.DateView(tONA011, "00");
TXTONA012.Text = SBApp.DateView(tONA012, "00");
TXTONA013.Text = tONA013;
//檔案類處理
string[] arrayFileNameLink = new string[] { tONA005, tONA006, tONA007, tONA008, tONA009, tONA010, tONA013 };
System.Web.UI.WebControls.HyperLink[] arrayLinkAppobj = new System.Web.UI.WebControls.HyperLink[] { Link005, Link006, Link007, Link008, Link009, Link010, Link013 };
for (int i = 0; i < arrayFileNameLink.Length; i++)
{
string strFileName = arrayFileNameLink[i];
System.Web.UI.WebControls.HyperLink FileLinkObj = arrayLinkAppobj[i];
FileLinkObj.Visible = false;
if (strFileName == "")
{
}
else
{
string tempLinkPateh = SwcUpLoadFilePath + v + "/" + strFileName;
FileLinkObj.Text = strFileName;
FileLinkObj.NavigateUrl = tempLinkPateh;
FileLinkObj.Visible = true;
}
}
}
}
}
}
private void GetUserData(string v)
{
GBClass001 SBApp = new GBClass001();
AddNewAcc.Visible = false;
SaveAccount.Visible = false;
TextUserName.Visible = false;;
OLDPWAREA.Visible = false;
switch (v)
{
case "NEW":
TXTSYSID.Text = GetSYSID();
AddNewAcc.Visible = true;
LBPWNew1.Text = "密碼";
LBPWNew2.Text = "密碼確認";
break;
default:
TextUserName.Visible = true;
OLDPWAREA.Visible = true;
SaveAccount.Visible = true;
break;
}
if (v == "NEW")
{
}
else
{
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection UserConn = new SqlConnection(connectionString.ConnectionString))
{
UserConn.Open();
string strSQLRV = " select * from ETUsers ";
strSQLRV = strSQLRV + " where ETID = '" + v + "' ";
SqlDataReader readeUser;
SqlCommand objCmdUser = new SqlCommand(strSQLRV, UserConn);
readeUser = objCmdUser.ExecuteReader();
while (readeUser.Read())
{
string tSYSID = readeUser["SYSID"] + "";
string tETID = readeUser["ETID"] + "";
string tETPW = readeUser["ETPW"] + "";
string tETName = readeUser["ETName"] + "";
string tETTCNo01 = readeUser["ETTCNo01"] + "";
string tETTCNo02 = readeUser["ETTCNo02"] + "";
string tETTCNo03 = readeUser["ETTCNo03"] + "";
string tETTCNo04 = readeUser["ETTCNo04"] + "";
string tETTel = readeUser["ETTel"] + "";
string tETEmail = readeUser["ETEmail"] + "";
string tETOrgName = readeUser["ETOrgName"] + "";
string tETOrgGUINo = readeUser["ETOrgGUINo"] + "";
string tETOrgIssNo = readeUser["ETOrgIssNo"] + "";
string tETOrgAddr = readeUser["ETOrgAddr"] + "";
string tETOrgTel = readeUser["ETOrgTel"] + "";
string tETCOPC = readeUser["ETCOPC"] + "";
string tTCNo01ED = readeUser["TCNo01ED"] + "";
string tTCNo02ED = readeUser["TCNo02ED"] + "";
string tTCNo03ED = readeUser["TCNo03ED"] + "";
string tTCNo04ED = readeUser["TCNo04ED"] + "";
string tETCOPCExp = readeUser["ETCOPCExp"] + "";
TXTSYSID.Text = tSYSID;
TXTETIDNo.Text = tETID;
LBETIDNo.Text = tETID;
TXTETName.Text = tETName;
TXTETTCNo01.Text = tETTCNo01;
TXTETTCNo02.Text = tETTCNo02;
TXTETTCNo03.Text = tETTCNo03;
TXTETTCNo04.Text = tETTCNo04;
TXTETTel.Text = tETTel;
TXTETEmail.Text = tETEmail;
TXTETOrgName.Text = tETOrgName;
TXTETOrgGUINo.Text = tETOrgGUINo;
TXTETOrgIssNo.Text = tETOrgIssNo;
TXTETOrgAddr.Text = tETOrgAddr;
TXTETOrgTel.Text = tETOrgTel;
TXTETCOPC.Text = tETCOPC;
TXTTCNo01ED.Text = SBApp.DateView(tTCNo01ED, "00");
TXTTCNo02ED.Text = SBApp.DateView(tTCNo02ED, "00");
TXTTCNo03ED.Text = SBApp.DateView(tTCNo03ED, "00");
TXTTCNo04ED.Text = SBApp.DateView(tTCNo04ED, "00");
TXTETCOPCExp.Text = SBApp.DateView(tETCOPCExp, "00");
TXTETIDNo.Visible = false;
LBETIDNo.Visible = true;
//string tETIDNo = readeUser["ETIDNo"] + ";
//string tETStatus = readeUser["ETStatus"] + ";
//string tApproved = readeUser["Approved"] + ";
//string tApprovedDate = readeUser["ApprovedDate"] + ";
//string tSaveuser = readeUser["Saveuser"] + ";
//string tsavedate = readeUser["savedate"] + ";
//string tstatus = readeUser["status"] + ";
//圖片類處理
string[] arrayFileName = new string[] { tETTCNo01, tETTCNo02, tETTCNo03, tETTCNo04 };
System.Web.UI.WebControls.Image[] arrayImgAppobj = new System.Web.UI.WebControls.Image[] { TXTETTCNo01_img, TXTETTCNo02_img, TXTETTCNo03_img, TXTETTCNo04_img };
for (int i = 0; i < arrayFileName.Length; i++)
{
string strFileName = arrayFileName[i];
System.Web.UI.WebControls.Image ImgFileObj = arrayImgAppobj[i];
if (strFileName == "")
{
}
else
{
string tempImgPateh = UserUpLoadFilePath + v + "/" + strFileName;
ImgFileObj.Attributes.Add("src", tempImgPateh + "?ts=" + DateTime.Now.Millisecond);
}
}
}
readeUser.Close();
objCmdUser.Dispose();
}
}
}
private void GetOLA02Data(string v, string v2)
{
string ssUserType = Session["UserType"] + "";
string ssUserID = Session["ID"] + "";
string ssUserPW = Session["PW"] + "";
GBClass001 SBApp = new GBClass001();
string tDATALOCK = "";
GenDropDownList();
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCCASE ";
strSQLRV = strSQLRV + " where SWC000 = '" + v + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC000 = readeSwc["SWC000"] + "";
string tSWC002 = readeSwc["SWC002"] + "";
string tSWC005 = readeSwc["SWC005"] + "";
LBSWC000.Text = tSWC000;
LBSWC002.Text = tSWC002;
LBSWC005.Text = tSWC005;
}
readeSwc.Close();
objCmdSwc.Dispose();
if (v2 == "AddNew")
{
string rONA000 = GetONAID();
TXTONA001.Text = rONA000;
switch (ssUserType)
{
case "01":
TXTONA004.Text = ssUserID;
TXTONA005.Text = ssUserPW;
break;
case "02":
DDLDTL008.SelectedValue = ssUserID;
TXTONA009.Text = SBApp.GetETUser(ssUserID, "OrgIssNo");
DDLDTL012.SelectedValue = ssUserID;
TXTONA013.Text = SBApp.GetETUser(ssUserID, "OrgIssNo");
break;
}
}
else
{
string strSQLRV2 = " select * from OnlineApply06 ";
strSQLRV2 = strSQLRV2 + " where SWC000 = '" + v + "' ";
strSQLRV2 = strSQLRV2 + " and ONA06001 = '" + v2 + "' ";
SqlDataReader readeONA;
SqlCommand objCmdONA = new SqlCommand(strSQLRV2, SwcConn);
readeONA = objCmdONA.ExecuteReader();
while (readeONA.Read())
{
string tONA002 = readeONA["ONA06002"] + "";
string tONA003 = readeONA["ONA06003"] + "";
string tONA004 = readeONA["ONA06004"] + "";
string tONA005 = readeONA["ONA06005"] + "";
string tONA006 = readeONA["ONA06006"] + "";
string tONA007 = readeONA["ONA06007"] + "";
string tONA008 = readeONA["ONA06008"] + "";
string tONA009 = readeONA["ONA06009"] + "";
string tONA010 = readeONA["ONA06010"] + "";
string tONA011 = readeONA["ONA06011"] + "";
string tONA012 = readeONA["ONA06012"] + "";
string tONA013 = readeONA["ONA06013"] + "";
string tONA014 = readeONA["ONA06014"] + "";
tDATALOCK = readeONA["DATALOCK"] + "";
TXTONA001.Text = v2;
if (tONA002 == "1")
{
CHKONA002.Checked = true;
}
if (tONA007 == "1")
{
CHKONA007.Checked = true;
}
if (tONA011 == "1")
{
CHKONA011.Checked = true;
}
DDLDTL008.SelectedValue = tONA008;
DDLDTL012.SelectedValue = tONA012;
TXTONA003.Text = tONA003;
TXTONA004.Text = tONA004;
TXTONA005.Text = tONA005;
TXTONA006.Text = tONA006;
TXTONA009.Text = tONA009;
TXTONA010.Text = tONA010;
TXTONA013.Text = tONA013;
TXTONA014.Text = tONA014;
//檔案類處理
string[] arrayFileNameLink = new string[] { tONA006, tONA010, tONA014 };
System.Web.UI.WebControls.HyperLink[] arrayLinkAppobj = new System.Web.UI.WebControls.HyperLink[] { Link006, Link010, Link014 };
for (int i = 0; i < arrayFileNameLink.Length; i++)
{
string strFileName = arrayFileNameLink[i];
System.Web.UI.WebControls.HyperLink FileLinkObj = arrayLinkAppobj[i];
FileLinkObj.Visible = false;
if (strFileName == "")
{
}
else
{
string tempLinkPateh = SwcUpLoadFilePath + v + "/" + strFileName;
FileLinkObj.Text = strFileName;
FileLinkObj.NavigateUrl = tempLinkPateh;
FileLinkObj.Visible = true;
}
}
}
}
}
}
