static void Main(string[] args)
{
GenericClass generic = new GenericClass();
generic.Show <string>("泛型練習"); //可寫成generic.Show("泛型練習");
generic.Show <double>(29.0); // 可寫成generic.Show(29.0);
Console.WriteLine($"Hello {generic.Show2("Corn")}!! Your Age is {generic.Show2(29)}");
generic.Show3("泛型練習", 29.0);
NewClass <string> newClass = new NewClass <string>(); //若執行泛型類別個體的話，要先提供類型給泛型知道
newClass.Display("Corn"); //執行個體裡面的方法，因為上面有先提供類型給個體知道，所以必須按照給的規定去執行方法，不能隨意改類型
Console.WriteLine($"{newClass.GetValue("Helloword!!")}");
Console.WriteLine($"{newClass.GetValueByFunc("Helloword Func!!")}");
Console.WriteLine("-------------------------------------------------------------------------------------");
GenericByCondition genericByCondition = new GenericByCondition();
Console.WriteLine($"{genericByCondition.Show<DateTimeOffset>(DateTimeOffset.Now).ToString()}");
Console.WriteLine($"{genericByCondition.Show2<string>("where generic condition is class")}");
Class01 c = new Class01();
genericByCondition.Show3 <Class01>(c);
Class01 class01 = new Class01();
//Console.WriteLine($"{class01.AA()}");
Console.ReadKey();
}
protected void Page_Load(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string rDTLId = Request.QueryString["DTLNO"] + "";
string ssUserName = Session["NAME"] + "";
Class01 SBApp = new Class01();
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 + "，您好";
}
}
public void test()
{
MDependency01.AllInstances.generate = _ => 123;
Class01 clazz = new Class01();
Assert.AreEqual(2 * 123, clazz.generate());
}
public void Main()
{
Class01 one = new Class01();
one.MyInteger = 16;
Class02 two = new Class02();
Console.WriteLine("Class two: {0}", two.MyInteger);
}
private void myFunc()
{
Data data = new Data();
data.Integer = 16;
Class01 one = new Class01 {
Integer = data
};
Class02 two = new Class02 {
Integer = data
};
Console.WriteLine("Class one: {0} -- Class two: {1}", one.Integer.Integer, two.Integer.Integer);
// Prints: Class one: 16 -- Class two: 16
data.Integer++;
Console.WriteLine("Class one: {0} -- Class two: {1}", one.Integer.Integer, two.Integer.Integer);
// Prints: Class one: 17 -- Class two: 16
// I want it to print: Class one: 17 -- Class two: 17
}
public void _callList()
{
var class01 = new Class01();
class01._addsList(); //<--- Had to add this line
for (int i = 0; i < class01.myList.Count; i++)
{
Console.WriteLine(class01.myList[i] + ",");
}
string wits2;
List <string> buffer = new List <string>();
for (int i = 0; i < class01.myList.Count; i++)
{
wits2 = class01.myList[i].Substring(0, 4);
Console.WriteLine(wits2);
}
Console.ReadKey();
}
private void Data2Page(string v, string v2)
{
Class01 SBApp = new Class01();
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"] + "";
string tDATALOCK = readeDTL["DATALOCK"] + "";
LBDTL001.Text = tDTLB001;
TXTDTL002.Text = tDTLB002;
TXTDTL003.Text = tDTLB003;
TXTDTL004.Text = tDTLB004;
//TXTDTL006.Text = SBApp.DateView(tDTLB006, "00");
if (tDTLB007 == "1")
{
CHKDTL007.Checked = true;
}
if (tDTLB008 == "1")
{
CHKDTL008.Checked = true;
}
if (tDTLB009 == "1")
{
CHKDTL009.Checked = true;
}
TXTDTL010.Text = tDTLB010;
DropList011.SelectedValue = tDTLB011;
DropList012.SelectedValue = tDTLB012;
DropList013.SelectedValue = tDTLB013;
TXTDTL014.Text = tDTLB014;
if (tDTLB015 == "1")
{
CHKBOX015.Checked = true;
}
if (tDTLB016 == "1")
{
CHKBOX016.Checked = true;
}
if (tDTLB017 == "1")
{
CHKBOX017.Checked = true;
}
if (tDTLB018 == "1")
{
CHKBOX018.Checked = true;
}
TXTDTL019.Text = tDTLB019;
TXTDTL020.Text = tDTLB001;
TXTDTL021.Text = tDTLB021;
TXTDTL022.Text = tDTLB022;
TXTDTL023.Text = tDTLB023;
//檔案類處理
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);
}
}
//按鈕處理
if (tDATALOCK == "Y")
{
DataLock.Visible = false;
SaveCase.Visible = false;
error_msg.Text = SBApp.AlertMsg("資料已送出，目前僅供瀏覽。");
}
}
}
}
}
private void FileUpLoadApp(string ChkType, FileUpload UpLoadBar, TextBox UpLoadText, string UpLoadStr, string UpLoadType, System.Web.UI.WebControls.Image UpLoadView, HyperLink UpLoadLink)
{
Class01 MyBassAppPj = new Class01();
string SwcFileName = "";
string CaseId = LBSWC000.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> {
".pdf"
};
if (allowedExtextsion02.IndexOf(extension) == -1)
{
error_msg.Text = MyBassAppPj.AlertMsg("請選擇 PDF 檔案格式上傳，謝謝!!");
return;
}
break;
}
// 限制檔案大小，限制為 5MB
int filesize = UpLoadBar.PostedFile.ContentLength;
if (filesize > 10000000)
{
error_msg.Text = "請選擇 10 Mb 以下檔案上傳，謝謝!!";
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] = "";
}
}
protected void SaveCase_Click(object sender, EventArgs e)
{
string rCaseId = Request.QueryString["SWCNO"] + "";
string ssUserID = Session["ID"] + "";
string sSWC000 = rCaseId;
string sDTL000 = LBDTL001.Text + "";
string sDTL002 = TXTDTL002.Text + "";
string sDTL003 = TXTDTL003.Text + "";
string sDTL004 = TXTDTL004.Text + "";
string sDTL005 = LBSWC005.Text + "";
string sDTL007 = "";
string sDTL008 = "";
string sDTL009 = "";
string sDTL010 = TXTDTL010.Text + "";
string sDTL011 = DropList011.SelectedValue + "";
string sDTL012 = DropList012.SelectedValue + "";
string sDTL013 = DropList013.SelectedValue + "";
string sDTL014 = TXTDTL014.Text + "";
string sDTL015 = "";
string sDTL016 = "";
string sDTL017 = "";
string sDTL018 = "";
string sDTL019 = TXTDTL019.Text + "";
string sDTL020 = TXTDTL020.Text + "";
string sDTL021 = TXTDTL021.Text + "";
string sDTL022 = TXTDTL022.Text + "";
string sDTL023 = TXTDTL023.Text + "";
if (CHKDTL007.Checked)
{
sDTL007 = "1";
}
if (CHKDTL008.Checked)
{
sDTL008 = "1";
}
if (CHKDTL009.Checked)
{
sDTL009 = "1";
}
if (CHKBOX015.Checked)
{
sDTL015 = "1";
}
if (CHKBOX016.Checked)
{
sDTL016 = "1";
}
if (CHKBOX017.Checked)
{
sDTL017 = "1";
}
if (CHKBOX018.Checked)
{
sDTL018 = "1";
}
Class01 SBApp = new Class01();
string sEXESQLSTR = "";
string sEXESQLUPD = "";
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCDTL02 ";
strSQLRV = strSQLRV + " where SWC000 = '" + sSWC000 + "' ";
strSQLRV = strSQLRV + " AND DTLB000 = '" + sDTL000 + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
if (!readeSwc.HasRows)
{
sEXESQLSTR = sEXESQLSTR + " INSERT INTO SWCDTL02 (SWC000,DTLB000) VALUES ('" + sSWC000 + "','" + sDTL000 + "');";
}
readeSwc.Close();
objCmdSwc.Dispose();
sEXESQLSTR = sEXESQLSTR + " Update SWCDTL02 Set ";
sEXESQLSTR = sEXESQLSTR + " DTLB001 = DTLB000, ";
sEXESQLSTR = sEXESQLSTR + " DTLB002 ='" + sDTL002 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB003 ='" + sDTL003 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB004 ='" + sDTL004 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB005 ='" + sDTL005 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLB006 ='" + sDTL006 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB007 ='" + sDTL007 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB008 ='" + sDTL008 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB009 ='" + sDTL009 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB010 ='" + sDTL010 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB011 ='" + sDTL011 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB012 ='" + sDTL012 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB013 ='" + sDTL013 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB014 ='" + sDTL014 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB015 ='" + sDTL015 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB016 ='" + sDTL016 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB017 ='" + sDTL017 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB018 ='" + sDTL018 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB019 ='" + sDTL019 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB020 ='" + sDTL020 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB021 ='" + sDTL021 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB022 ='" + sDTL022 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLB023 ='" + sDTL023 + "', ";
sEXESQLSTR = sEXESQLSTR + " saveuser = '******', ";
sEXESQLSTR = sEXESQLSTR + " savedate = getdate() ";
sEXESQLSTR = sEXESQLSTR + " Where SWC000 = '" + sSWC000 + "'";
sEXESQLSTR = sEXESQLSTR + " and DTLB000 = '" + sDTL000 + "'";
sEXESQLUPD = sEXESQLUPD + " Update RelationSwc set ";
sEXESQLUPD = sEXESQLUPD + " Upd02 = 'Y', ";
sEXESQLUPD = sEXESQLUPD + " Savdate02 = getdate() ";
sEXESQLUPD = sEXESQLUPD + " Where Key01 = '" + sSWC000 + "'";
SqlCommand objCmdUpd = new SqlCommand(sEXESQLSTR + sEXESQLUPD, SwcConn);
objCmdUpd.ExecuteNonQuery();
objCmdUpd.Dispose();
//上傳檔案…
UpLoadTempFileMoveChk(sSWC000);
string vCaseID = Request.QueryString["SWCNO"] + "";
Response.Write("<script>alert('資料已存檔'); location.href='SWCDT002.aspx?SWCNO=" + vCaseID + "&DTLNO=" + sDTL000 + "'; </script>");
}
}
protected void btnenter_Click(object sender, EventArgs e)
{
string pGoaspx = Request.QueryString["goaspx"] + "";
string pPageType = Request.QueryString["PageType"] + "";
string pAct = Request.QueryString["Act"] + "";
if (pAct == "Out")
{
//登出
Session["UserType"] = "";
Session["ID"] = "";
Session["PW"] = "";
Session["NAME"] = "";
Session["Unit"] = "";
Session["Edit4"] = ""; //完工公會
}
int i = 5;
if (pGoaspx == "")
{
pGoaspx = "DouCode/SwcDtl07.aspx";
}
if (pGoaspx == "" || pGoaspx.Substring(pGoaspx.Length - i, i).ToLower() != ".aspx")
{
//pGoaspx = "UserList.aspx";
laberror.Text = pGoaspx.Substring(pGoaspx.Length - i, i).ToLower();
}
string InuptID = txtuid.Text + "";
string InuptPW = txtpassword.Text + "";
Class01 BASEAPP = new Class01();
InuptID = BASEAPP.SQLstrValue(InuptID);
InuptPW = BASEAPP.SQLstrValue(InuptPW);
if (InuptID.Trim() != "" && InuptPW.Trim() != "")
{
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["GEOINFOCONN"];
using (SqlConnection UserConn = new SqlConnection(connectionString.ConnectionString))
{
UserConn.Open();
string strSQLRV = " select * from geouser ";
strSQLRV = strSQLRV + " Where userid = '" + InuptID + "' ";
strSQLRV = strSQLRV + " and status = '正常' ";
SqlDataReader readerUser;
SqlCommand objCmdUser = new SqlCommand(strSQLRV, UserConn);
readerUser = objCmdUser.ExecuteReader();
if (readerUser.Read())
{
string tUserid = readerUser["userid"] + "";
string tUserPw = readerUser["passwd"] + "";
string tName = readerUser["name"] + "";
string tMbGroup = readerUser["mbgroup02"] + "";
string tJobTitle = readerUser["jobtitle"] + "";
if (InuptPW == tUserPw)
{
laberror.Text = "";
Session["ID"] = tUserid;
Session["PW"] = tUserPw;
Session["jobtitle"] = tJobTitle;
Session["uid"] = tUserid;
Session["name"] = tName;
Session["right"] = tMbGroup;
Session["grade"] = tJobTitle;
userlog(tUserid, tName);
if (pPageType != "1")
{
pGoaspx = "../" + pGoaspx;
}
pGoaspx = pGoaspx.Replace(".aspxandand", ".aspx?");;
pGoaspx = pGoaspx.Replace("andand", "&");
Response.Redirect(pGoaspx);
}
else
{
laberror.Text = "帳號或密碼錯誤!!";
}
}
else
{
laberror.Text = "帳號或密碼錯誤!!";
}
readerUser.Close();
objCmdUser.Dispose();
}
}
else
{
laberror.Text = "帳號或密碼錯誤!!";
}
}
//索引用：strSQLRV15 - strSQLRV16
protected void Page_Load(object sender, EventArgs e)
{
GetUserMailData();
string[] arrayChkUserId = ChkUserId.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayChkUserName = ChkUserName.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayJobTitle = ChkJobTitle.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayMbGroup = ChkMbGroup.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayChkMail = ChkMail.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayChkUserMailTxt = ChkMailText.Split(new string[] { ";;" }, StringSplitOptions.None);
GetGuildMailData();
string[] arrayChkGuildId = ChkGuildId.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayChkGuildName = ChkGuildName.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayChkGuildMail = ChkGuildMail.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayChkGuildMailText = ChkGuildMailText.Split(new string[] { ";;" }, StringSplitOptions.None);
GetETUserMailData();
string[] arrayETUserId = ChkETUserId.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayETUserName = ChkETUserName.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayETUserMail = ChkETUserMail.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayETUserMailText = ChkETUserMailText.Split(new string[] { ";;" }, StringSplitOptions.None);
string strObligors = "";
string strObligorsMail = "";
string strObligorsText = "";
string strPhoneNO = "";
string strPhoneMsg = "";
Class01 SBApp = new Class01();
GBClass001 GBSBApp = new GBClass001();
ConnectionStringSettings connectionStringTslm = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionStringTslm.ConnectionString))
{
SwcConn.Open();
//水保案件：狀態為「施工中」，「施工檢查表」-03
//1.「是否辦理檢查」：每月1號檢核，5 - 11月每月皆應檢查、12 - 4月1公頃以下案件2個月至少應檢查1次，1公頃以上案件每月至少應檢查1次。
//2.「檢查書件繳送是否預期」：檢查日期與送出日期不得超過固定天數(6工作天)(行政院人事行政總處是否有api可介接)
int tThisMonth = DateTime.Now.Month;
int tThisDay = DateTime.Now.Day;
if (tThisDay == 1)
{
string strSQLRV15a = " select C.SWC002,C.SWC005,C.SWC012,C.SWC024ID,C.SWC025,ISNULL(C.SWC023,0) AS SWC023,ISNULL(D3.DTLC002,GETDATE()-1000) AS DTLC002,D3.DATALOCK from SWCCASE C ";
strSQLRV15a = strSQLRV15a + " LEFT JOIN SWCDTL03 D3 ON C.SWC000 = D3.SWC000 AND D3.DTLC000 = (SELECT MAX(DTLC000) FROM SWCDTL03 D3m WHERE C.SWC000 = D3m.SWC000 ) ";
strSQLRV15a = strSQLRV15a + " WHERE C.SWC004 = '施工中' ORDER BY C.SWC000 ";
SqlDataReader readeSwcA;
SqlCommand objCmdSwcA = new SqlCommand(strSQLRV15a, SwcConn);
readeSwcA = objCmdSwcA.ExecuteReader();
while (readeSwcA.Read())
{
bool CheckHadDate = false;
double dSwc023 = Convert.ToDouble(readeSwcA["SWC023"] + "");
DateTime dDTLC002 = Convert.ToDateTime(readeSwcA["DTLC002"] + "");
string tSWC002 = readeSwcA["SWC002"] + ""; //水保局編號
string tSWC005 = readeSwcA["SWC005"] + ""; //書件名稱
string tSWC012 = readeSwcA["SWC012"] + ""; //轄區：北一區
string tSWC024ID = readeSwcA["SWC024ID"] + ""; //檢查公會
string tSWC025 = readeSwcA["SWC025"] + ""; //承辦人
string tDTLC002 = readeSwcA["DTLC002"] + ""; //檢查日期
string tDATALOCK = readeSwcA["DATALOCK"] + ""; //資料送出
//tThisMonth：本月份，未填檢查日期,每月1日檢查
if (tThisDay == 1)
{
if (dSwc023 < 2)
{
//1公頃以下，5.6.7.8.9.10.11，每月檢查1次，12.1.2.3.4，每2月檢查1次。(檢查月：2.4.5.6.7.8.9.10.11.12)
if (tThisMonth != 1 && tThisMonth != 3)
{
CheckHadDate = true;
}
}
else
{
//1公頃以上，每月檢查1次。
CheckHadDate = true;
}
}
if (CheckHadDate)
{
DateTime tChkDate = DateTime.Now;
if (dDTLC002 < tChkDate)
{
//尚未填寫檢查日期請盡速填寫。
string tMailText01 = tSWC012 + "【" + tSWC005 + "】本月預計檢查日期尚未送出，請確認公會是否依合約辦理。";
for (int i = 1; i < arrayChkUserId.Length; i++)
{
string tG1UserName = arrayChkUserName[i];
string tG1JObTitle = arrayJobTitle[i];
string tG1MbGroup = arrayMbGroup[i];
if (tG1JObTitle == "科長" || tG1JObTitle == "正工" || tG1JObTitle == "股長" || tG1MbGroup == "系統管理員" || tG1UserName.Trim() == tSWC025.Trim())
{
arrayChkUserMailTxt[i] = arrayChkUserMailTxt[i] + tMailText01 + "<br>";
}
}
string tMailText02 = "提醒您，【" + tSWC005 + "】本月預計檢查日期尚未送出，請確認並盡速辦理。";
for (int i = 0; i < arrayChkGuildId.Length - 1; i++)
{
string tGuildID = arrayChkGuildId[i];
if (tGuildID == tSWC024ID)
{
arrayChkGuildMailText[i] = arrayChkGuildMailText[i] + tMailText02 + "<br>";
}
}
}
}
}
readeSwcA.Close();
objCmdSwcA.Dispose();
}
string strSQLRV15b = " select SWC.SWC000,SWC.SWC005,SWC.SWC012,SWC.SWC013,SWC.SWC013TEL,SWC.SWC024ID,SWC.SWC025,SWC.SWC045ID,SWC.SWC108 from SWCCASE SWC ";
strSQLRV15b = strSQLRV15b + " LEFT JOIN SWCDTL03 D3 ON SWC.SWC000 = D3.SWC000 ";
strSQLRV15b = strSQLRV15b + " WHERE SWC.SWC004 = '施工中' ";
strSQLRV15b = strSQLRV15b + " AND D3.DTLC002 < GETDATE()-6 AND D3.DATALOCK <>'Y' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV15b, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC005 = readeSwc["SWC005"] + "";
string tSWC012 = readeSwc["SWC012"] + "";
string tSWC013 = readeSwc["SWC013"] + "";
string tSWC013TEL = readeSwc["SWC013TEL"] + "";
string tSWC024ID = readeSwc["SWC024ID"] + "";
string tSWC025 = readeSwc["SWC025"] + "";
string tSWC045ID = readeSwc["SWC045ID"] + "";
string tSWC108 = readeSwc["SWC108"] + "";
string tMailText01 = tSWC012 + "【" + tSWC005 + "】本月檢查紀錄尚未送出，請確認公會是否依合約辦理。";
for (int i = 0; i < arrayChkUserId.Length - 1; i++)
{
string tG1UserName = arrayChkUserName[i];
string tG1JObTitle = arrayJobTitle[i];
string tG1MbGroup = arrayMbGroup[i];
if (tG1JObTitle == "科長" || tG1JObTitle == "正工" || tG1JObTitle == "股長" || tG1MbGroup == "系統管理員" || tG1UserName.Trim() == tSWC025.Trim())
{
arrayChkUserMailTxt[i] = arrayChkUserMailTxt[i] + tMailText01 + "<br>";
}
}
string tMailText02 = "提醒您，【" + tSWC005 + "】本月檢查紀錄尚未送出，請確認並盡速辦理。";
for (int i = 0; i < arrayChkGuildId.Length - 1; i++)
{
string tGuildID = arrayChkGuildId[i];
if (tGuildID == tSWC024ID)
{
arrayChkGuildMailText[i] = arrayChkGuildMailText[i] + tMailText02 + "<br>";
}
}
}
readeSwc.Close();
objCmdSwc.Dispose();
//水保案件：狀態為「施工中」，「監造紀錄表」-05
//1.檢查過去7天內有無檔案，若無則須通知。 (無檔案：子表單，送出日期)
//2.開工日期<過去7天
string strSQLRV16 = " select SWC.SWC000,SWC.SWC005,SWC.SWC012,SWC.SWC013,SWC.SWC013TEL,SWC.SWC024ID,SWC.SWC025,SWC.SWC045ID,SWC.SWC108 from SWCCASE SWC ";
strSQLRV16 = strSQLRV16 + " LEFT JOIN SWCDTL05 D5 ON SWC.SWC000 = D5.SWC000 ";
strSQLRV16 = strSQLRV16 + " WHERE SWC.SWC004 = '施工中' ";
strSQLRV16 = strSQLRV16 + " AND SWC.SWC051 < GETDATE() - 7 ";
strSQLRV16 = strSQLRV16 + " AND SWC.SWC000 NOT IN(SELECT SWC000 FROM SWCDTL05 WHERE savedate > GETDATE() - 7) ";
strSQLRV16 = strSQLRV16 + " GROUP BY SWC.SWC000,SWC.SWC005,SWC.SWC012,SWC.SWC013,SWC.SWC013TEL,SWC.SWC024ID,SWC.SWC025,SWC.SWC045ID,SWC.SWC108 ";
strSQLRV16 = strSQLRV16 + " ORDER BY SWC.SWC000 ";
objCmdSwc = new SqlCommand(strSQLRV16, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
while (readeSwc.Read())
{
string tSWC005 = readeSwc["SWC005"] + "";
string tSWC012 = readeSwc["SWC012"] + "";
string tSWC013 = readeSwc["SWC013"] + "";
string tSWC013TEL = readeSwc["SWC013TEL"] + "";
string tSWC024ID = readeSwc["SWC024ID"] + "";
string tSWC025 = readeSwc["SWC025"] + "";
string tSWC045ID = readeSwc["SWC045ID"] + "";
string tSWC108 = readeSwc["SWC108"] + "";
string tMailText01 = tSWC012 + "【" + tSWC005 + "】尚未上傳監造紀錄表，請確認。";
for (int i = 1; i < arrayChkUserId.Length; i++)
{
string tG1UserName = arrayChkUserName[i];
string tG1JObTitle = arrayJobTitle[i];
string tG1MbGroup = arrayMbGroup[i];
if (tG1JObTitle == "科長" || tG1JObTitle == "正工" || tG1JObTitle == "股長" || tG1MbGroup == "系統管理員" || tG1UserName.Trim() == tSWC025.Trim())
{
arrayChkUserMailTxt[i] = arrayChkUserMailTxt[i] + tMailText01 + "<br>";
}
}
string tMailText02 = "提醒您，【" + tSWC005 + "】尚未上傳本週監造紀錄表，請盡速補正。";
for (int i = 1; i < arrayChkGuildId.Length; i++)
{
string tGuildID = arrayChkGuildId[i];
if (tGuildID == tSWC024ID)
{
arrayChkGuildMailText[i] = arrayChkGuildMailText[i] + tMailText02 + "<br>";
}
}
for (int i = 1; i < arrayETUserId.Length; i++)
{
string tETUserID = arrayETUserId[i];
if (tETUserID == tSWC045ID)
{
arrayETUserMailText[i] = arrayETUserMailText[i] + tMailText02 + "<br>";
}
}
if (tSWC108.Trim() != "")
{
strObligors = strObligors + ";;" + tSWC013;
strObligorsMail = strObligorsMail + ";;" + tSWC108;
strObligorsText = strObligorsText + ";;" + tMailText02;
}
strPhoneNO = strPhoneNO + ";;" + tSWC013TEL;
strPhoneMsg = strPhoneMsg + ";;" + tMailText02;
}
readeSwc.Close();
objCmdSwc.Dispose();
}
string ChkMailSub = SBApp.DateView(DateTime.Now.ToString(), "00") + " 水土保持書件管理平台子表檢核通知信";
string ssMailFFF = "<br>「臺北市水土保持書件管理平台」系統管理員 敬上<br><br><br>";
ssMailFFF = ssMailFFF + "＜此封信為系統自動發送，請勿直接回信，若有任何問題請洽臺北市政府工務局大地工程處＞";
//寄信
for (int i = 1; i < arrayChkUserId.Length; i++)
{
string[] sMail = new string[] { arrayChkMail[i] };
string sUserName = arrayChkUserName[i];
string sUserJob = arrayJobTitle[i];
string sMailText = arrayChkUserMailTxt[i];
if (sMailText != "")
{
bool MailTo01 = SBApp.Mail_Send(sMail, ChkMailSub, sUserName + sUserJob + "，您好" + sMailText + ssMailFFF);
}
}
for (int i = 0; i < arrayChkGuildId.Length - 1; i++)
{
string[] sMail = new string[] { arrayChkGuildMail[i] };
string sUserName = arrayChkUserName[i];
string sMailText = arrayChkGuildMailText[i];
if (sMailText != "")
{
bool MailTo02 = SBApp.Mail_Send(sMail, ChkMailSub, sUserName + "，您好" + sMailText + ssMailFFF);
}
}
for (int i = 0; i < arrayETUserId.Length - 1; i++)
{
string[] sMail = new string[] { arrayETUserMail[i] };
string sETuserName = arrayETUserName[i];
string sMailText = arrayETUserMailText[i];
if (sMailText != "")
{
bool MailTo03 = SBApp.Mail_Send(sMail, ChkMailSub, sETuserName + "，您好" + sMailText + ssMailFFF);
}
}
//傳簡訊
string[] arrayPhoneNo = strPhoneNO.Split(new string[] { ";;" }, StringSplitOptions.None);
string[] arrayPhoneMsg = strPhoneMsg.Split(new string[] { ";;" }, StringSplitOptions.None);
for (int i = 0; i < arrayPhoneNo.Length - 1; i++)
{
string sPhoneNo = arrayPhoneNo[i];
string sPhoneMsg = arrayPhoneMsg[i];
GBSBApp.SendSMS(sPhoneNo, sPhoneMsg.Replace("<br>", ""));
}
}
protected void SaveCase_Click(object sender, EventArgs e)
{
Class01 BASEAPP = new Class01();
string rCaseId = Request.QueryString["SWCNO"] + "";
string ssUserID = Session["ID"] + "";
string sSWC000 = rCaseId;
string sDTLE000 = LBDTL001.Text + "";
string sDTLE002 = TXTDTL002.Text + "";
string sDTLE003 = BASEAPP.SQLstrValue(TXTDTL003.Text + "");
string sDTLE004 = BASEAPP.SQLstrValue(TXTDTL004.Text + "");
string sDTLE005 = BASEAPP.SQLstrValue(TXTDTL005.Text + "");
string sDTLE006 = BASEAPP.SQLstrValue(TXTDTL006.Text + "");
string sDTLE007 = BASEAPP.SQLstrValue(TXTDTL007.Text + "");
string sDTLE016 = DDLDTL016.SelectedValue + "";
string sDTLE017 = BASEAPP.SQLstrValue(TXTDTL017.Text + "");
string sDTLE018 = BASEAPP.SQLstrValue(TXTDTL018.Text + "");
string sDTLE019 = DDLDTL019.SelectedValue + "";
string sDTLE020 = BASEAPP.SQLstrValue(TXTDTL020.Text + "");
string sDTLE021 = BASEAPP.SQLstrValue(TXTDTL021.Text + "");
string sDTLE022 = DDLDTL022.SelectedValue + "";
string sDTLE023 = BASEAPP.SQLstrValue(TXTDTL023.Text + "");
string sDTLE024 = BASEAPP.SQLstrValue(TXTDTL024.Text + "");
string sDTLE025 = DDLDTL025.SelectedValue + "";
string sDTLE026 = BASEAPP.SQLstrValue(TXTDTL026.Text + "");
string sDTLE027 = BASEAPP.SQLstrValue(TXTDTL027.Text + "");
string sDTLE028 = DDLDTL028.SelectedValue + "";
string sDTLE029 = BASEAPP.SQLstrValue(TXTDTL029.Text + "");
string sDTLE030 = BASEAPP.SQLstrValue(TXTDTL030.Text + "");
string sDTLE031 = DDLDTL031.SelectedValue + "";
string sDTLE032 = BASEAPP.SQLstrValue(TXTDTL032.Text + "");
string sDTLE033 = BASEAPP.SQLstrValue(TXTDTL033.Text + "");
string sDTLE034 = DDLDTL034.SelectedValue + "";
string sDTLE035 = BASEAPP.SQLstrValue(TXTDTL035.Text + "");
string sDTLE036 = BASEAPP.SQLstrValue(TXTDTL036.Text + "");
string sDTLE037 = DDLDTL037.SelectedValue + "";
string sDTLE038 = BASEAPP.SQLstrValue(TXTDTL038.Text + "");
string sDTLE039 = BASEAPP.SQLstrValue(TXTDTL039.Text + "");
string sDTLE040 = DDLDTL040.SelectedValue + "";
string sDTLE041 = BASEAPP.SQLstrValue(TXTDTL041.Text + "");
string sDTLE042 = BASEAPP.SQLstrValue(TXTDTL042.Text + "");
string sDTLE043 = DDLDTL043.SelectedValue + "";
string sDTLE044 = BASEAPP.SQLstrValue(TXTDTL044.Text + "");
string sDTLE045 = BASEAPP.SQLstrValue(TXTDTL045.Text + "");
string sDTLE046 = DDLDTL046.SelectedValue + "";
string sDTLE047 = BASEAPP.SQLstrValue(TXTDTL047.Text + "");
string sDTLE048 = BASEAPP.SQLstrValue(TXTDTL048.Text + "");
string sDTLE049 = DDLDTL049.SelectedValue + "";
string sDTLE050 = BASEAPP.SQLstrValue(TXTDTL050.Text + "");
string sDTLE051 = BASEAPP.SQLstrValue(TXTDTL051.Text + "");
string sDTLE052 = DDLDTL052.SelectedValue + "";
string sDTLE053 = BASEAPP.SQLstrValue(TXTDTL053.Text + "");
string sDTLE054 = BASEAPP.SQLstrValue(TXTDTL054.Text + "");
string sDTLE055 = DDLDTL055.SelectedValue + "";
string sDTLE056 = BASEAPP.SQLstrValue(TXTDTL056.Text + "");
string sDTLE057 = BASEAPP.SQLstrValue(TXTDTL057.Text + "");
string sDTLE058 = DDLDTL058.SelectedValue + "";
string sDTLE059 = BASEAPP.SQLstrValue(TXTDTL059.Text + "");
string sDTLE060 = BASEAPP.SQLstrValue(TXTDTL060.Text + "");
string sDTLE061 = DDLDTL061.SelectedValue + "";
string sDTLE062 = BASEAPP.SQLstrValue(TXTDTL062.Text + "");
string sDTLE063 = BASEAPP.SQLstrValue(TXTDTL063.Text + "");
string sDTLE064 = DDLDTL064.SelectedValue + "";
string sDTLE065 = BASEAPP.SQLstrValue(TXTDTL065.Text + "");
string sDTLE066 = BASEAPP.SQLstrValue(TXTDTL066.Text + "");
string sDTLE067 = DDLDTL067.SelectedValue + "";
string sDTLE068 = BASEAPP.SQLstrValue(TXTDTL068.Text + "");
string sDTLE069 = BASEAPP.SQLstrValue(TXTDTL069.Text + "");
string sDTLE070 = DDLDTL070.SelectedValue + "";
string sDTLE071 = BASEAPP.SQLstrValue(TXTDTL071.Text + "");
string sDTLE072 = BASEAPP.SQLstrValue(TXTDTL072.Text + "");
string sDTLE073 = DDLDTL073.SelectedValue + "";
string sDTLE074 = BASEAPP.SQLstrValue(TXTDTL074.Text + "");
string sDTLE075 = BASEAPP.SQLstrValue(TXTDTL075.Text + "");
string sDTLE076 = DDLDTL076.SelectedValue + "";
string sDTLE077 = BASEAPP.SQLstrValue(TXTDTL077.Text + "");
string sDTLE078 = BASEAPP.SQLstrValue(TXTDTL078.Text + "");
string sDTLE079 = BASEAPP.SQLstrValue(TXTDTL079.Text + "");
string sDTLE080 = BASEAPP.SQLstrValue(TXTDTL080.Text + "");
string sDTLE081 = BASEAPP.SQLstrValue(TXTDTL081.Text + "");
string sDTLE082 = BASEAPP.SQLstrValue(TXTDTL082.Text + "");
string sDTLE083 = BASEAPP.SQLstrValue(TXTDTL083.Text + "");
string sDTLE084 = BASEAPP.SQLstrValue(TXTDTL084.Text + "");
string sDTLE085 = BASEAPP.SQLstrValue(TXTDTL085.Text + "");
string sDTLE086 = BASEAPP.SQLstrValue(TXTDTL086.Text + "");
string sDTLE087 = BASEAPP.SQLstrValue(TXTDTL087.Text + "");
GBClass001 SBApp = new GBClass001();
string sEXESQLSTR = "";
string sEXESQLUPD = "";
ConnectionStringSettings connectionString = ConfigurationManager.ConnectionStrings["SWCConnStr"];
using (SqlConnection SwcConn = new SqlConnection(connectionString.ConnectionString))
{
SwcConn.Open();
string strSQLRV = " select * from SWCDTL05 ";
strSQLRV = strSQLRV + " where SWC000 = '" + sSWC000 + "' ";
strSQLRV = strSQLRV + " and DTLE000 = '" + sDTLE000 + "' ";
SqlDataReader readeSwc;
SqlCommand objCmdSwc = new SqlCommand(strSQLRV, SwcConn);
readeSwc = objCmdSwc.ExecuteReader();
if (!readeSwc.HasRows)
{
sEXESQLSTR = sEXESQLSTR + " INSERT INTO SWCDTL05 (SWC000,DTLE000) VALUES ('" + sSWC000 + "','" + sDTLE000 + "');";
}
readeSwc.Close();
objCmdSwc.Dispose();
sEXESQLSTR = sEXESQLSTR + " Update SWCDTL05 Set ";
sEXESQLSTR = sEXESQLSTR + " DTLE001 = DTLE000, ";
sEXESQLSTR = sEXESQLSTR + " DTLE002 ='" + sDTLE002 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE003 ='" + sDTLE003 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE004 ='" + sDTLE004 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE005 ='" + sDTLE005 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE006 ='" + sDTLE006 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE007 ='" + sDTLE007 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE016 ='" + sDTLE016 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE017 ='" + sDTLE017 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE018 ='" + sDTLE018 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE019 ='" + sDTLE019 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE020 ='" + sDTLE020 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE021 ='" + sDTLE021 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE022 ='" + sDTLE022 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE023 ='" + sDTLE023 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE024 ='" + sDTLE024 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE025 ='" + sDTLE025 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE026 ='" + sDTLE026 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE027 ='" + sDTLE027 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE028 ='" + sDTLE028 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE029 ='" + sDTLE029 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE030 ='" + sDTLE030 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE031 ='" + sDTLE031 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE032 ='" + sDTLE032 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE033 ='" + sDTLE033 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE034 ='" + sDTLE034 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE035 ='" + sDTLE035 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE036 ='" + sDTLE036 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE037 ='" + sDTLE037 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE038 ='" + sDTLE038 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE039 ='" + sDTLE039 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE040 ='" + sDTLE040 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE041 ='" + sDTLE041 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE042 ='" + sDTLE042 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE043 ='" + sDTLE043 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE044 ='" + sDTLE044 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE045 ='" + sDTLE045 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE046 ='" + sDTLE046 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE047 ='" + sDTLE047 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE048 ='" + sDTLE048 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE049 ='" + sDTLE049 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE050 ='" + sDTLE050 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE051 ='" + sDTLE051 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE052 ='" + sDTLE052 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE053 ='" + sDTLE053 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE054 ='" + sDTLE054 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE055 ='" + sDTLE055 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE056 ='" + sDTLE056 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE057 ='" + sDTLE057 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE058 ='" + sDTLE058 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE059 ='" + sDTLE059 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE060 ='" + sDTLE060 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE061 ='" + sDTLE061 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE062 ='" + sDTLE062 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE063 ='" + sDTLE063 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE064 ='" + sDTLE064 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE065 ='" + sDTLE065 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE066 ='" + sDTLE066 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE067 ='" + sDTLE067 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE068 ='" + sDTLE068 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE069 ='" + sDTLE069 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE070 ='" + sDTLE070 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE071 ='" + sDTLE071 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE072 ='" + sDTLE072 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE073 ='" + sDTLE073 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE074 ='" + sDTLE074 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE075 ='" + sDTLE075 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE076 ='" + sDTLE076 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE077 ='" + sDTLE077 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE078 ='" + sDTLE078 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE079 ='" + sDTLE079 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE080 ='" + sDTLE080 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE081 ='" + sDTLE081 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE082 ='" + sDTLE082 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE083 ='" + sDTLE083 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE084 ='" + sDTLE084 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE085 ='" + sDTLE085 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE086 ='" + sDTLE086 + "', ";
sEXESQLSTR = sEXESQLSTR + " DTLE087 ='" + sDTLE087 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE005 ='" + sDTLE005 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE008 ='" + sDTLE008 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE009 ='" + sDTLE009 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE010 ='" + sDTLE010 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE011 ='" + sDTLE011 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE012 ='" + sDTLE012 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE013 ='" + sDTLE013 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE014 ='" + sDTLE014 + "', ";
//sEXESQLSTR = sEXESQLSTR + " DTLE015 ='" + sDTLE015 + "', ";
sEXESQLSTR = sEXESQLSTR + " saveuser = '******', ";
sEXESQLSTR = sEXESQLSTR + " savedate = getdate() ";
sEXESQLSTR = sEXESQLSTR + " Where SWC000 = '" + sSWC000 + "'";
sEXESQLSTR = sEXESQLSTR + " and DTLE000 = '" + sDTLE000 + "'";
sEXESQLUPD = sEXESQLUPD + " Update RelationSwc set ";
sEXESQLUPD = sEXESQLUPD + " Upd02 = 'Y', ";
sEXESQLUPD = sEXESQLUPD + " Savdate02 = getdate() ";
sEXESQLUPD = sEXESQLUPD + " Where Key01 = '" + sSWC000 + "'";
SqlCommand objCmdUpd = new SqlCommand(sEXESQLSTR + sEXESQLUPD, SwcConn);
objCmdUpd.ExecuteNonQuery();
objCmdUpd.Dispose();
//上傳檔案…
UpLoadTempFileMoveChk(sSWC000);
string vCaseID = Request.QueryString["SWCNO"] + "";
Response.Redirect("SWC002.aspx?CaseId=" + vCaseID);
}
}
