protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null && Request.QueryString["command"] != null) { if (Request.QueryString["command"].ToString() == "delete") { if (clsSQL.Execute( "UPDATE [User] SET Active='D' WHERE UID=@UID;", new string[, ] { { "@UID", Request.QueryString["id"].ToString() } }, dbType, cs)) { //ucColorBox1.Redirect("/Management/DoctorAppointment.aspx"); Response.Redirect("User.aspx"); } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะลบข้อมูล"); } } } else { BindDefault(); } } }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin") && !clsSecurity.LoginChecker("hr")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var clsIO = new clsIO(); var strSQL = new StringBuilder(); #endregion #region Procedure #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { ucColorBox1.Redirect(webDefault); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); return; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #endregion }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); clsIO clsIO = new clsIO(); #endregion #region Delete Photo #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Icon "); strSQL.Append("FROM "); strSQL.Append("MedicalCenter "); strSQL.Append("WHERE "); strSQL.Append("MedicalCenterGroupUID=" + id); #endregion dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); strSQL.Length = 0; strSQL.Capacity = 0; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Icon"] != DBNull.Value) { clsIO.FileExist(dt.Rows[i]["Icon"].ToString(), true); } } dt = null; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + parameterChar + "UID"); #endregion if (clsSQL.Execute(strSQL.ToString(), new string[, ] { { parameterChar + "UID", id } }, dbType, cs)) { ucColorBox1.Redirect(webDefault); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var clsIO = new clsIO(); var strSQL = new StringBuilder(); #endregion #region Procedure #region Delete Photo /* #region SQL Query * strSQL.Append("SELECT "); * strSQL.Append("Icon "); * strSQL.Append("FROM "); * strSQL.Append(tableDefault + " "); * strSQL.Append("WHERE "); * strSQL.Append("UID=" + id); #endregion * string photoDelete = clsSQL.Return(strSQL.ToString(), dbType, cs); * if (!string.IsNullOrEmpty(photoDelete)) * { * clsIO.FileExist(photoDelete, true); * } * strSQL.Length = 0; strSQL.Capacity = 0; */ #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { ucColorBox1.Redirect(webDefault); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); return; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #endregion }
protected void btDGSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var strSQL = new StringBuilder(); #endregion #region Procedure #region SQL Builder for (int i = 0; i < gvDefault.Rows.Count; i++) { #region CurrentPageChecker var cbDGCurrentPage = (CheckBox)gvDefault.Rows[i].FindControl("cbDGCurrentPage"); if (!cbDGCurrentPage.Checked) { continue; } #endregion Label lblDGID = (Label)gvDefault.Rows[i].FindControl("lblDGID"); CheckBox cbDGActive = (CheckBox)gvDefault.Rows[i].FindControl("cbDGActive"); TextBox txtDGSort = (TextBox)gvDefault.Rows[i].FindControl("txtDGSort"); if (lblDGID != null && cbDGActive != null) { #region SQL Query strSQL.Append("UPDATE "); strSQL.Append(tableDefault + " "); strSQL.Append("SET "); strSQL.Append("Sort=" + clsSQL.CodeFilter(txtDGSort.Text) + ","); strSQL.Append("StatusFlag='" + (cbDGActive.Checked ? "A" : "I") + "' "); strSQL.Append("WHERE "); strSQL.Append("UID=" + lblDGID.Text); strSQL.Append(";"); #endregion } } #endregion if (clsSQL.Execute(strSQL.ToString())) { ucColorBox1.Redirect("/Management/" + webDefault, "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย"); } else { ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะบันทึกข้อมูลลงฐานข้อมูล<br/>" + strSQL.ToString(), AlertImage: ucColorBox.Alerts.Fail); } #endregion }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null && Request.QueryString["command"] != null) { if (Request.QueryString["command"].ToString() == "delete") { if (clsSQL.Execute( "UPDATE [JobsHistory] SET StatusFlag='D' WHERE UID=@UID;", new string[, ] { { "@UID", Request.QueryString["id"].ToString() } }, dbType, cs)) { //ucColorBox1.Redirect("/Management/DoctorAppointment.aspx"); Response.Redirect("JobsHistory.aspx"); } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะลบข้อมูล"); } } } else if (Request.QueryString["id"] != null) { BindDefault(); ucColorBox1.IFrame( webManage + "?id=" + Request.QueryString["id"].ToString() + "&command=edit", "700px", "95%", false ); } else { BindDefault(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { clsSQL clsSQL = new clsSQL(); clsSQL.Execute( "INSERT INTO Content(UID,LanguageUID,Name,Detail,Content,CWhen,CUser,MWhen,MUser,Sort,Active)" + "VALUES(17,1,'HospitalNetwork','กลุ่มโรงพยาบาลเครือข่าย','กลุ่มโรงพยาบาลเครือข่าย',GETDATE(),0,GETDATE(),0,0,'1');" + "INSERT INTO Content(UID,LanguageUID,Name,Detail,Content,CWhen,CUser,MWhen,MUser,Sort,Active)" + "VALUES(18,2,'HospitalNetwork','กลุ่มโรงพยาบาลเครือข่าย','กลุ่มโรงพยาบาลเครือข่าย',GETDATE(),0,GETDATE(),0,0,'1');", clsSQL.DBType.SQLServer, "cs"); } }
public bool DoctorScheduleSyncer() { #region Variable clsSQL clsSQL = new clsSQL(); FileInfo fi = new FileInfo(System.Web.HttpContext.Current.Server.MapPath("/Upload/Doctor/SQLQuery.txt")); string sqlQuery = ""; bool result = false; #endregion if (fi.Exists) { StreamReader StrWer; try { StrWer = File.OpenText(System.Web.HttpContext.Current.Server.MapPath("/Upload/Doctor/SQLQuery.txt")); while (!(StrWer.EndOfStream)) { sqlQuery = sqlQuery + StrWer.ReadLine(); } StrWer.Close(); } catch (Exception) { } if (sqlQuery != "") { clsMail clsMail = new clsMail(); string outMail = ""; string outSQLError = ""; if (!clsSQL.Execute(sqlQuery, dbType, cs, out outSQLError)) { clsMail.Send("*****@*****.**", "*****@*****.**", "DoctorScheduleSyncer : Error Insert (OnWeb)", outSQLError + "<hr/>" + sqlQuery, out outMail); //lblDoctorScheduleSyncer.Text = "DoctorScheduleSyncer : เกิดข้อผิดพลาดขณะรันคำสั่ง<br/>"+sqlQuery; fi.Delete(); } else { fi.Delete(); result = true; } } } else { result = true; } return(result); }
public bool DoctorScheduleSyncer() { #region Variable clsSQL clsSQL = new clsSQL(); FileInfo fi = new FileInfo(System.Web.HttpContext.Current.Server.MapPath("/Upload/Doctor/SQLQuery.txt")); string sqlQuery = ""; bool result = false; #endregion if (fi.Exists) { StreamReader StrWer; try { StrWer = File.OpenText(System.Web.HttpContext.Current.Server.MapPath("/Upload/Doctor/SQLQuery.txt")); while (!(StrWer.EndOfStream)) { sqlQuery = sqlQuery + StrWer.ReadLine(); } StrWer.Close(); } catch (Exception) { } if (sqlQuery != "") { clsMail clsMail = new clsMail(); string outMail = ""; string outSQLError = ""; if (!clsSQL.Execute(sqlQuery, dbType, cs,out outSQLError)) { clsMail.Send("*****@*****.**", "*****@*****.**", "DoctorScheduleSyncer : Error Insert (OnWeb)", outSQLError + "<hr/>"+sqlQuery, out outMail); //lblDoctorScheduleSyncer.Text = "DoctorScheduleSyncer : เกิดข้อผิดพลาดขณะรันคำสั่ง<br/>"+sqlQuery; fi.Delete(); } else { fi.Delete(); result = true; } } } else { result = true; } return result; }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect(webDefault, "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); clsIO clsIO = new clsIO(); string photoName; #endregion #region Delete Photo photoName = clsSQL.Return( "SELECT Photo FROM " + tableDefault + " WHERE UID=" + parameterChar + "UID", new string[, ] { { parameterChar + "UID", id } }, dbType, cs); if (photoName != "") { clsIO.FileExist(photoName, true); } #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + parameterChar + "UID"); #endregion if (clsSQL.Execute(strSQL.ToString(), new string[, ] { { parameterChar + "UID", id } }, dbType, cs)) { ucColorBox1.Redirect(webDefault); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion }
protected void btDGSubmit_Click(object sender, EventArgs e) { if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } StringBuilder strSQL = new StringBuilder(); for (int i = 0; i < gvDefault.Rows.Count; i++) { #region CurrentPageChecker var cbDGCurrentPage = (CheckBox)gvDefault.Rows[i].FindControl("cbDGCurrentPage"); if (!cbDGCurrentPage.Checked) { continue; } #endregion Label lblDGID = (Label)gvDefault.Rows[i].FindControl("lblDGID"); CheckBox cbDGActive = (CheckBox)gvDefault.Rows[i].FindControl("cbDGActive"); if (lblDGID != null && cbDGActive != null) { #region SQL Query strSQL.Append("UPDATE "); strSQL.Append("Content "); strSQL.Append("SET "); strSQL.Append("Active='" + (cbDGActive.Checked ? "1" : "0") + "' "); strSQL.Append("WHERE "); strSQL.Append("UID=" + lblDGID.Text); strSQL.Append(";"); #endregion } } if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { ucColorBox1.Redirect("/Management/Content.aspx", "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย"); } else { ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะบันทึกข้อมูลลงฐานข้อมูล<br/>" + strSQL.ToString(), AlertImage: ucColorBox.Alerts.Fail); } }
private void CarouselBuilder() { #region Variable var dt = new DataTable(); var dtGlobal = new DataTable(); var strSQL = new StringBuilder(); var fieldName = ""; #endregion #region Procedure dt = clsSQL.Bind("SELECT GlobalUID,GlobalName,''Photo,''Name,''URL FROM Highlight WHERE StatusFlag='A';", dbType, cs); if (dt != null && dt.Rows.Count > 0) { #region GlobalBuilder for (int i = 0; i < dt.Rows.Count; i++) { #region FildNameBuilder switch (dt.Rows[i]["GlobalName"].ToString()) { case "HealthPackage": fieldName = "Name"; break; case "Package": fieldName = "PackageName"; break; case "Event": fieldName = "Subject"; break; case "Promotion": fieldName = "PromotionName"; break; case "News": fieldName = "Subject"; break; default: fieldName = "Subject"; break; } #endregion #region SQLQuery strSQL.Append("SELECT "); strSQL.Append("UID," + fieldName + " Name,PicThumbnail Photo,'Package' GlobalName "); strSQL.Append("FROM "); strSQL.Append(dt.Rows[i]["GlobalName"].ToString() + " "); strSQL.Append("WHERE "); strSQL.Append("StatusFlag='A' "); strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) "); strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) "); strSQL.Append("AND UID=" + dt.Rows[i]["GlobalUID"].ToString() + ";"); #endregion dtGlobal = clsSQL.Bind(strSQL.ToString(), dbType, cs); strSQL.Length = 0; strSQL.Capacity = 0; if (dtGlobal != null && dtGlobal.Rows.Count > 0) { dt.Rows[i]["Photo"] = dtGlobal.Rows[0]["Photo"].ToString(); dt.Rows[i]["Name"] = dtGlobal.Rows[0]["Name"].ToString(); dt.Rows[i]["URL"] = "/" + dt.Rows[i]["GlobalName"].ToString() + "/" + dt.Rows[i]["GlobalUID"].ToString() + "/" + clsDefault.URLRoutingFilter(dtGlobal.Rows[0]["Name"].ToString()) + "/"; dtGlobal = null; } else { clsSQL.Execute("DELETE FROM Highlight WHERE GlobalUID=" + dt.Rows[i]["GlobalUID"].ToString() + " AND GlobalName='" + dt.Rows[i]["GlobalName"].ToString() + "';", dbType, cs); dt.Rows[i].Delete(); } } dt.AcceptChanges(); #endregion #region CarouselBuilder ucOwlCarousel1.Source = dt; ucOwlCarousel1.SourceFieldName = "Name"; ucOwlCarousel1.SourceFieldPhoto = "Photo"; ucOwlCarousel1.SourceFieldURL = "URL"; ucOwlCarousel1.PhotoWidth = "100%"; ucOwlCarousel1.PhotoHeight = "auto"; ucOwlCarousel1.PhotoWidthOverflow = "320px"; ucOwlCarousel1.PhotoHeightOverflow = "140px"; ucOwlCarousel1.PathPhoto = ""; ucOwlCarousel1.AutoPlay = true; ucOwlCarousel1.AutoPlaySecond = 4; ucOwlCarousel1.ItemsMax = 3; ucOwlCarousel1.StopOnHover = true; ucOwlCarousel1.Enable = true; ucOwlCarousel1.Visible = true; #endregion #endregion dt = null; } }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable clsIO clsIO = new clsIO(); StringBuilder strSQL = new StringBuilder(); #endregion #region Delete Photo #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Photo "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion string photoDelete = clsSQL.Return(strSQL.ToString(), dbType, cs); if (!string.IsNullOrEmpty(photoDelete)) { clsIO.FileExist(photoDelete, true); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #region Delete PhotoPreview #region SQL Query strSQL.Append("SELECT "); strSQL.Append("PhotoPreview "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion string photoPreviewDelete = clsSQL.Return(strSQL.ToString(), dbType, cs); if (!string.IsNullOrEmpty(photoPreviewDelete)) { clsIO.FileExist(photoPreviewDelete, true); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { ucColorBox1.Redirect(webDefault + clsDefault.QueryStringRemover(new string[] { "id", "command" })); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); return; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion }
private void btCreateTable_Click(object sender, EventArgs e) { #region Variable var strSQL = new string[] { "CREATE TABLE patient (PatientGUID varchar(50) NOT NULL,HN varchar(12) NOT NULL,Episode varchar(13) default NULL,LabEpisode varchar(100) default NULL,DOB datetime default NULL,No int(11) default NULL,EmployeeID varchar(20) default NULL,DOE datetime default NULL,Company varchar(200) default NULL,ChildCompany varchar(200) default NULL,ProChkList varchar(50) default NULL,ProChkListDetail varchar(200) default NULL,Prename varchar(50) default NULL,Forename varchar(50) default NULL,Surname varchar(50) default NULL,Age varchar(50) default NULL,Sex varchar(50) default NULL,Address varchar(300) default NULL,Tel varchar(200) default NULL,Email varchar(50) default NULL,Physician varchar(50) default NULL,RegType varchar(10) default NULL,Programid int(4) default NULL,DIVI varchar(80) default NULL,DEP varchar(80) default NULL,SEC varchar(80) default NULL,POS varchar(99) default NULL,LAN int(11) default NULL,NAT int(11) default NULL,CNT_TRY int(11) default NULL,LOC varchar(50) default NULL,Payor varchar(100) default NULL,Epi_Rowid decimal(10,0) default NULL,ORD_STS varchar(1) default NULL,STS varchar(1) default NULL,DR_CDE varchar(15) default NULL,NTE varchar(200) default NULL,Job varchar(80) default NULL,BusUnit varchar(80) default NULL,BusDiv varchar(80) default NULL,Line varchar(80) default NULL,Shift varchar(300) default NULL,Location varchar(80) default NULL,GrpBook varchar(100) default NULL,BookCreate varchar(100) default NULL,HISExist char(1) default NULL,SyncStatus char(1) NOT NULL default '0',SyncWhen datetime default NULL,CWhen timestamp NOT NULL default CURRENT_TIMESTAMP,CUser varchar(10) NOT NULL default '',StatusFlag char(1) default NULL,PRIMARY KEY(PatientGUID));", "CREATE TABLE patientchecklist (RowID int(11) NOT NULL,PatientGUID varchar(50) NOT NULL,HN varchar(12) default NULL,Episode varchar(13) default NULL,CheckListID int(11) default NULL,ProChkList varchar(200) default NULL,ProID int(11) default NULL,WorkFlow varchar(200) default NULL,WFID int(11) default NULL,WFSequen int(11) default NULL,ProStatus float default NULL,ProStatusRemark varchar(200) default NULL,RegDate datetime default NULL,ModifyDate datetime default NULL,SyncStatus char(1) NOT NULL default '0',SyncWhen datetime default NULL,CWhen timestamp NOT NULL default CURRENT_TIMESTAMP,CUser varchar(10) default '',MWhen datetime default NULL,MUser varchar(10) default '',PRIMARY KEY(RowID));", "CREATE TABLE ProStatusDetail(Code FLOAT NOT NULL,Detail VARCHAR(100) NOT NULL,PRIMARY KEY(Code));", "INSERT INTO ProStatusDetail(Code,Detail)VALUES('1','ปริ้นเอกสารแล้ว (สถานะเริ่มต้น)');", "INSERT INTO ProStatusDetail(Code,Detail)VALUES('2','ลงทะเบียนรับเอกสารแล้ว');", "INSERT INTO ProStatusDetail(Code,Detail)VALUES('3','ดำเนินการแล้ว');", "INSERT INTO ProStatusDetail(Code,Detail)VALUES('4','ยกเลิกการตรวจ');", "CREATE TABLE PatientLab(LabEpisode VARCHAR(100) NOT NULL,WFID INT(11) NOT NULL,CWhen DATETIME NOT NULL,StatusFlag CHAR(1) NOT NULL DEFAULT 'A',PRIMARY KEY(LabEpisode,WFID));", "CREATE TABLE Checklist(ChecklistID INT NOT NULL,Code VARCHAR(20) NOT NULL,Detail VARCHAR(600),PRIMARY KEY(ChecklistID));", "CREATE TABLE ChecklistDetail(ChecklistID INT NOT NULL,ProID INT,WFID INT,WFSequen INT,WorkFlow VARCHAR(200),PRIMARY KEY(ChecklistID,WFID),FOREIGN KEY(ChecklistID) REFERENCES Checklist(ChecklistID) ON UPDATE CASCADE ON DELETE CASCADE);", "CREATE TABLE staff(user_id int(11) NOT NULL AUTO_INCREMENT,emp_id varchar(10) DEFAULT NULL,username varchar(30) DEFAULT NULL,password varchar(40) DEFAULT NULL,cre_by int(11) DEFAULT NULL,cre_date datetime DEFAULT NULL,upd_by int(11) DEFAULT NULL,upd_date datetime DEFAULT NULL,role_id int(11) DEFAULT NULL,nickname varchar(100) DEFAULT NULL,flag_active enum('D','N','A') DEFAULT 'A',PRIMARY KEY (user_id));", "INSERT INTO staff VALUES ('1', 'nopjorn', 'nopjorn', '15f7030f2cc0ff18b0214bae41a114f70f75770b', null, NOW(), '1', NOW(), '1', 'เจได', 'A');", "INSERT INTO staff VALUES ('2', 'checkup', 'checkup', '24f8ef8cc03898266027761bd58882ed8910378e', '1', NOW(), '2', NOW(), '1', 'checkup', 'A');", "INSERT INTO staff VALUES('3', 'dear', 'dear', '7c4a8d09ca3762af61e59520943dc26494f8941b', '1', NOW(), '1', NOW(), '2', 'เดียร์', 'A');", "CREATE TABLE log_print (PatientGUID varchar(50) DEFAULT NULL,cre_by_ip varchar(15) DEFAULT NULL,cre_date datetime DEFAULT NULL,com_name varchar(100) DEFAULT NULL,cre_by int(11) DEFAULT NULL,print_type enum('C','S') DEFAULT NULL COMMENT 'Checklist, Sticker');" }; var outMessage = ""; var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); #endregion #region Procedure if (clsSQL.IsConnected()) { for(int i = 0; i < strSQL.Length; i++) { if (!clsSQL.Execute(strSQL[i],out outMessage)) { MessageBox.Show(outMessage, "Error on CreateTable", MessageBoxButtons.OK, MessageBoxIcon.Error); } } MessageBox.Show("ดำเนินการเสร็จสมบูรณ์", "Complete", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("ไม่สามารถเชื่อมต่อฐานข้อมูล Mobile ได้", "Database Connection Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion }
protected void btDGSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var strSQL = new StringBuilder(); var outError = ""; var statusFlag = ""; #endregion #region SQL Builder for (int i = 0; i < dlDefault.Items.Count; i++) { Label lblDGID = (Label)dlDefault.Items[i].FindControl("lblDGID"); Label lblDGName = (Label)dlDefault.Items[i].FindControl("lblDGName"); CheckBox cbDGActive = (CheckBox)dlDefault.Items[i].FindControl("cbDGActive"); if (lblDGID != null && lblDGName != null && cbDGActive != null) { statusFlag = clsSQL.Return("SELECT StatusFlag FROM Highlight WHERE GlobalUID=" + lblDGID.Text + " AND GlobalName='" + lblDGName.Text + "';", dbType, cs); if (statusFlag != "" && statusFlag != (cbDGActive.Checked?"A":"D")) { #region UPDATE SQL Query strSQL.Append("UPDATE "); strSQL.Append("Highlight "); strSQL.Append("SET "); strSQL.Append("MWhen=GETDATE(),"); strSQL.Append("MUser="******","); strSQL.Append("StatusFlag='" + (cbDGActive.Checked?"A":"D") + "' "); strSQL.Append("WHERE "); strSQL.Append("GlobalUID=" + lblDGID.Text + " "); strSQL.Append("AND GlobalName='" + lblDGName.Text + "'"); strSQL.Append(";"); #endregion } else if (statusFlag == "") { if (cbDGActive.Checked) { #region INSERT SQL Query strSQL.Append("INSERT INTO "); strSQL.Append("Highlight "); strSQL.Append("(GlobalUID,GlobalName,CWhen,CUser,MWhen,MUser,Sort,StatusFlag)"); strSQL.Append("VALUES("); strSQL.Append(lblDGID.Text + ","); strSQL.Append("'" + lblDGName.Text + "',"); strSQL.Append("GETDATE(),"); strSQL.Append(clsSecurity.LoginUID + ","); strSQL.Append("GETDATE(),"); strSQL.Append(clsSecurity.LoginUID + ","); strSQL.Append("0,"); strSQL.Append("'A'"); strSQL.Append(")"); strSQL.Append(";"); #endregion } } if (strSQL.Length > 0) { if (!clsSQL.Execute(strSQL.ToString(), dbType, cs, out outError)) { ucColorBox1.Alert("SQL Error", outError, AlertImage: ucColorBox.Alerts.Fail); return; } strSQL.Length = 0; strSQL.Capacity = 0; } } } #endregion ucColorBox1.Redirect("/Management/Highlight.aspx" + clsDefault.QueryStringMerge(), "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย"); }
protected void btSendMail_Click(object sender, EventArgs e) { #region Variable var strSQL = new StringBuilder(); var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); var clsDefault = new clsDefault(); #endregion #region Procedure if (hidFileName.Value != "") { #region SQLQuery strSQL.Append("INSERT INTO "); strSQL.Append("P5_Job"); strSQL.Append("(FileName,Name,Detail,ContactName,ContactPhone,ContactEmail,Location,CWhen,MWhen)"); strSQL.Append("VALUES("); strSQL.Append("'" + hidFileName.Value.Trim() + "',"); strSQL.Append("'" + txtName.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtDetail.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtContactName.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtContactPhone.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtContactEmail.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtLocation.Text.SQLQueryFilter() + "',"); strSQL.Append("GETDATE(),"); strSQL.Append("GETDATE()"); strSQL.Append(");"); #endregion if (clsSQL.Execute(strSQL.ToString())) { #region MailSender var clsMail = new clsMail(); var outMessage = ""; //Send to Admin try { if (!clsMail.SendByGmail( "*****@*****.**", "G00des1gn", System.Configuration.ConfigurationManager.AppSettings["mailTo"], "P5GraphicDesign : มีใบงานใหม่ '" + txtName.Text.SQLQueryFilter() + "'", string.Format("<h1>มีใบงานใหม่ : {0}</h1><div><b>จาก</b> : {1}</div><div><b>เบอร์โทร</b> : {2}</div><div><b>รายละเอียด</b> : {3}</div><hr/><a href='http://www.p5graphicdesign.com/Management/Job.aspx'>คลิกที่นี่เพื่อดูข้อมูล</a>", txtName.Text.SQLQueryFilter(), txtContactName.Text.SQLQueryFilter(), txtContactPhone.Text.SQLQueryFilter(), txtDetail.Text.SQLQueryFilter()), out outMessage, "P5GraphicDesign : มีใบงานใหม่ '" + txtName.Text.SQLQueryFilter() + "'", "*****@*****.**", "", "", System.Net.Mail.MailPriority.High)) { Response.Write("Send to Admin : " + outMessage); //ucColorBox1.Alert("พบข้อผิดพลาดขณะส่งเมล์", outMessage, AlertImage: ucColorBox.Alerts.Fail); return; } } catch (Exception exMailToAdmin) { Response.Write(exMailToAdmin.Message); } if (txtContactEmail.Text.Trim() != "" && txtContactEmail.Text.Contains("@") && txtContactEmail.Text.Contains(".")) { //Send to Customer try { if (!clsMail.SendByGmail( "*****@*****.**", "G00des1gn", txtContactEmail.Text.Trim(), "P5GraphicDesign : ได้รับใบงาน '" + txtName.Text.SQLQueryFilter() + "' ของคุณแล้ว", string.Format("<h1>ได้รับใบงานใหม่เรียบร้อยแล้ว : {0}</h1><div><b>จาก</b> : {1}</div><div><b>เบอร์โทร</b> : {2}</div><div><b>รายละเอียด</b> : {3}</div>", txtName.Text.SQLQueryFilter(), txtContactName.Text.SQLQueryFilter(), txtContactPhone.Text.SQLQueryFilter(), txtDetail.Text.SQLQueryFilter()), out outMessage, "P5GraphicDesign : ได้รับใบงาน '" + txtName.Text.SQLQueryFilter() + "' ของคุณแล้ว", "", "", "", System.Net.Mail.MailPriority.High)) { Response.Write(outMessage); //ucColorBox1.Alert("พบข้อผิดพลาดขณะส่งเมล์", outMessage, AlertImage: ucColorBox.Alerts.Fail); return; } } catch (Exception exMailToCustomer) { Response.Write("Send to Customer : " + exMailToCustomer.Message); } } #endregion txtName.Text = ""; txtDetail.Text = ""; txtContactName.Text = ""; txtContactPhone.Text = ""; txtLocation.Text = ""; hidFileName.Value = ""; lblSendMailAlert.Text = clsDefault.AlertMessageFlat("บันทึกข้อมูลเสร็จสมบูรณ์", clsDefault.AlertType.Success); lblSendMailAlert.Focus(); } else { lblSendMailAlert.Text = clsDefault.AlertMessageFlat("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>" + strSQL.ToString(), clsDefault.AlertType.Fail); lblSendMailAlert.Focus(); } } else { lblSendMailAlert.Text = clsDefault.AlertMessageFlat("โปรดเลือกอัพโหลดไฟล์ก่อนทำการส่งข้อมูล", clsDefault.AlertType.Fail); lblSendMailAlert.Focus(); } #endregion }
private bool setSessionLog(List<clsRDPModel> clsRDPModels) { #region Variable var result = false; var strSQL = ""; var dt = new DataTable(); var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); #endregion #region Procedure try { dt = clsSQL.Bind("SELECT UID,Domain,Username,SessionID,ConnectWhen,DisconnectWhen,Status FROM sessionlog WHERE ServerName='" + clsGlobal.IPAddress() + "' AND DisconnectWhen IS NULL AND StatusFlag='A';"); if (dt != null && dt.Rows.Count > 0) { #region Logout for (int i = 0; i < dt.Rows.Count; i++) { var exist = false; try { for (int j = 0; j < clsRDPModels.Count; j++) { try { if (dt.Rows[i]["Domain"].ToString() == clsRDPModels[j].Domain && dt.Rows[i]["Username"].ToString() == clsRDPModels[j].Username && dt.Rows[i]["SessionID"].ToString() == clsRDPModels[j].SessionID.ToString()) { exist = true; break; } } catch (Exception exSelect) { MessageBox.Show("Fail on condition." + Environment.NewLine + exSelect.Message, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); tmDefault.Stop(); tmDefault.Enabled = false; return false; } } if (!exist) { var sql = "UPDATE sessionlog SET DisconnectWhen=NOW(),Status='Logoff' WHERE UID=" + dt.Rows[i]["UID"].ToString(); if (!clsSQL.Execute(sql)) { MessageBox.Show("Can't update sessionlog." + Environment.NewLine, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } catch (Exception exSelect) { MessageBox.Show("Fail on update(139)." + Environment.NewLine + exSelect.Message, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); tmDefault.Stop(); tmDefault.Enabled = false; return false; } } #endregion } #region Connected for (int i = 0; i < clsRDPModels.Count; i++) { try { strSQL = "SELECT UID,IFNULL(DisconnectWhen,'')DisconnectWhen,Status " + "FROM sessionlog " + "WHERE ServerName='" + clsGlobal.IPAddress() + "' " + "AND Domain='" + clsRDPModels[i].Domain + "' " + "AND Username='******' " + "AND SessionID='" + clsRDPModels[i].SessionID + "' " + "AND ConnectWhen='" + clsRDPModels[i].ConnectTime.Value.ToString("yyyy-MM-dd HH:mm:ss") + "' " + "AND StatusFlag='A';"; } catch(Exception exSelect) { MessageBox.Show("Fail on select." + Environment.NewLine + exSelect.Message, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); tmDefault.Stop(); tmDefault.Enabled = false; return false; } var dtUpdate = new DataTable(); var sql = ""; var addSeparate = false; dtUpdate = clsSQL.Bind(strSQL); if (dtUpdate != null && dtUpdate.Rows.Count > 0) { try { sql = "UPDATE sessionlog SET "; if (dtUpdate.Rows[0]["Status"].ToString() != clsRDPModels[i].Status) { sql += "Status='" + clsRDPModels[i].Status + "' "; addSeparate = true; } if (dtUpdate.Rows[0]["DisconnectWhen"].ToString() != (clsRDPModels[i].DisconnectTime != null ? clsRDPModels[i].DisconnectTime.Value.ToString("yyyy-MM-dd HH:mm:ss") : "")) { if (addSeparate) sql += ","; sql += "DisconnectWhen=" + (clsRDPModels[i].DisconnectTime != null ? "'"+clsRDPModels[i].DisconnectTime.Value.ToString("yyyy-MM-dd HH:mm:ss")+"'" : "NULL") + " "; addSeparate = true; } sql += "WHERE UID=" + dtUpdate.Rows[0]["UID"].ToString(); if (!addSeparate) sql = ""; } catch (Exception exSelect) { MessageBox.Show("Fail on update(188)." + Environment.NewLine + exSelect.Message, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); tmDefault.Stop(); tmDefault.Enabled = false; return false; } } else { try { sql = "INSERT INTO sessionlog(ServerName,Domain,Username,IPAddress,SessionID,Status,ConnectWhen,DisconnectWhen,StatusFlag) " + "VALUES('" + clsGlobal.IPAddress() + "'," + "'" + clsRDPModels[i].Domain + "'," + "'" + clsRDPModels[i].Username + "'," + "'" + clsRDPModels[i].IPAddress + "'," + "" + clsRDPModels[i].SessionID.ToString() + "," + "'" + clsRDPModels[i].Status + "'," + "'" + clsRDPModels[i].ConnectTime.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'," + "" + (clsRDPModels[i].DisconnectTime != null ? "'" + clsRDPModels[i].DisconnectTime.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'" : "NULL") + "," + "'A');"; } catch (Exception exSelect) { MessageBox.Show("Fail on insert." + Environment.NewLine + exSelect.Message, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); tmDefault.Stop(); tmDefault.Enabled = false; return false; } } if (sql != "") { if (!clsSQL.Execute(sql)) { MessageBox.Show("Can't update sessionlog." + Environment.NewLine + sql, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); tmDefault.Stop(); tmDefault.Enabled = false; return false; } } //if (clsRDPModels[i].DisconnectTime== null) //{ // var getExistCheckerResult = ""; // getExistCheckerResult = getExistChecker(dt, clsRDPModels[i]); // if (getExistCheckerResult != "") // { // if (!clsSQL.Execute(getExistCheckerResult)) // { // MessageBox.Show("Can't update sessionlog." + Environment.NewLine + getExistCheckerResult, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); // } // } //} } #endregion } catch(Exception ex) { MessageBox.Show("Fail something on setSessionlog." + Environment.NewLine + ex.Message, "setSessionLog", MessageBoxButtons.OK, MessageBoxIcon.Error); tmDefault.Stop(); tmDefault.Enabled = false; return false; } #endregion return result; }
private static void Sync(string fileFullName) { #region Variable var fi = new FileInfo(fileFullName); var dt = new DataTable(); var dtMain = new DataTable(); var tblPatientStatusOnMobile = ""; var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); var countSuccess = 0; var countFail = 0; var countSuccessMobileStatus = 0; var mailMessage = new StringBuilder(); var outSQL = ""; var outMessage = ""; #endregion #region Procedure if (fi.Exists) { if (!IsFileLocked(fi)) { #region FileExist Console.WriteLine(string.Format("Find file : {0} ({1})", "Found", fi.FullName)); Console.WriteLine(string.Format("Read file : {0}", "Processing...")); dt = XMLSelecter(fi.FullName); Console.WriteLine(string.Format("Read file : {0}", "Completed")); if (dt != null && dt.Rows.Count > 0) { Console.WriteLine(string.Format("Read DataTable : {0} ({1} Rows)", "Found", dt.Rows.Count.ToString())); #region UpdateToDatabase for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["PatientGUID"].ToString().Trim().ToLower().Contains("new-regis")) { continue; } #region Update tblPatientListSTS & tblPatientStatusOnMobile if (dt.Rows[i]["WFID"].ToString().Trim() == "1" && float.Parse(dt.Rows[i]["ProStatus"].ToString().Trim()) >= 2) { tblPatientStatusOnMobile = clsSQL.Return("SELECT StatusOnMobile FROM Patient WHERE rowguid='" + dt.Rows[i]["PatientGUID"].ToString().Trim() + "';"); if (tblPatientStatusOnMobile != "R") { if (clsSQL.Execute( "UPDATE tblPatientList SET STS='R',SyncWhen=GETDATE() WHERE PatientUID='" + dt.Rows[i]["PatientGUID"].ToString().Trim() + "';" + "UPDATE Patient SET SyncStatus='1',SyncWhen=GETDATE(),StatusOnMobile='R' WHERE rowguid='" + dt.Rows[i]["PatientGUID"].ToString().Trim() + "';", out outMessage)) { countSuccessMobileStatus += 1; Console.WriteLine(string.Format("{0} : Update MobileStatus : {1} ({2})", dt.Rows[i]["HN"].ToString(), "Success", dt.Rows[i]["HN"].ToString().Trim())); mailMessage.Append(string.Format("{0} : Update MobileStatus : {1} ({2})<br/>", dt.Rows[i]["HN"].ToString(), "<span style='color:green;'>Success</span>", dt.Rows[i]["HN"].ToString().Trim())); } else { countFail += 1; Console.WriteLine(string.Format("{0} : Update MobileStatus : {1} ({2}) : {3}", dt.Rows[i]["HN"].ToString(), "Fail", dt.Rows[i]["HN"].ToString().Trim(), outMessage)); mailMessage.Append(string.Format("{0} : Update MobileStatus : {1} ({2} : {3})<br/>", dt.Rows[i]["HN"].ToString(), "<span style='color:red;'>Fail</span>", dt.Rows[i]["HN"].ToString().Trim(), outMessage)); } } } #endregion #region ChecklistUpdate dtMain = getPatientChecklistMain(dt.Rows[i]["RowID"].ToString()); if (dtMain != null && dtMain.Rows.Count > 0) { if (dt.Rows[i]["ProStatus"].ToString().Trim() != dtMain.Rows[0]["ProStatus"].ToString().Trim() || dt.Rows[i]["ProStatusRemark"].ToString().Trim() != dtMain.Rows[0]["ProStatusRemark"].ToString().Trim()/*|| dtMobile.Rows[i]["RegDate"].ToString().Trim() != dtMain.Rows[0]["RegDate"].ToString().Trim() || dtMobile.Rows[i]["ModifyDate"].ToString().Trim() != dtMain.Rows[0]["ModifyDate"].ToString().Trim()*/) { #region UpdateChecklist if (!clsSQL.Update( "tblCheckList", new string[,] { {"ProStatus",dt.Rows[i]["ProStatus"].ToString().Trim() }, {"ProStatusRemark","'"+dt.Rows[i]["ProStatusRemark"].ToString().SQLQueryFilter()+"'" }, {"RegDate",(dt.Rows[i]["RegDate"].ToString()!=""?"'"+DateTime.Parse(dt.Rows[i]["RegDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss")+"'":"NULL") }, {"SyncWhen","GETDATE()"} }, new string[,] { { } }, "RowID=" + dt.Rows[i]["RowID"].ToString(), out outSQL, out outMessage, true)) { countFail += 1; Console.WriteLine(string.Format("{0} : Update tblChecklist : {1} ({2})", dt.Rows[i]["HN"].ToString(), "Fail", outMessage)); mailMessage.Append(string.Format("{0} : Update tblChecklist : {1} ({2})<br/>", dt.Rows[i]["HN"].ToString(), "<span style='color:red;'>Fail</span>", outMessage)); } else { #region LogUpdate countSuccess += 1; Console.WriteLine(string.Format("{0} : Update tblChecklist : {1} ({2})", dt.Rows[i]["HN"].ToString(), "Success", dtMain.Rows[0]["ProStatus"].ToString().Trim() + "->" + dt.Rows[i]["ProStatus"].ToString().Trim())); mailMessage.Append(string.Format("{0} : Update tblChecklist : {1} ({2})<br/>", dt.Rows[i]["HN"].ToString(), "<span style='color:green;'>Success</span>", dtMain.Rows[0]["ProStatus"].ToString().Trim() + "->" + dt.Rows[i]["ProStatus"].ToString().Trim())); #endregion } #endregion } } else { mailMessage.Append("ไม่พบข้อมูลในไฟล์"); } #endregion } #endregion Console.WriteLine(string.Format("Summary : Success {0} Fail {1}", countSuccess.ToString(), countFail.ToString())); Console.WriteLine(string.Format("MailSend : {0}", "Processing...")); try { if (countSuccessMobileStatus > 0 || countSuccess > 0 || countFail > 0) { wsDefault.ServiceSoapClient wsDefault = new wsDefault.ServiceSoapClient(); if (wsDefault.MailSend( System.Configuration.ConfigurationManager.AppSettings["mailTo"], System.Configuration.ConfigurationManager.AppSettings["site"] + " : " + clsGlobal.ApplicationName + " Console Sync", "<h1>" + System.Configuration.ConfigurationManager.AppSettings["site"] + " : " + clsGlobal.ApplicationName + " Console Sync" + "</h1><h3><span style='color:#238DBB;'>StatusUpdateSuccess : " + countSuccessMobileStatus.ToString() + "</span> , <span style='color:green;'>Success : " + countSuccess.ToString() + "</span> , <span style='color:red;'>Fail : " + countFail.ToString() + "</span></h3><h4>FileName : " + fileFullName + "</h4><hr/>" + mailMessage.ToString(), "*****@*****.**", System.Configuration.ConfigurationManager.AppSettings["site"] + " : " + clsGlobal.ApplicationName, "", "", "<b>ServerIP</b> : " + clsGlobal.IPAddress() + "<br/><b>ExecutePath</b> : " + clsGlobal.ExecutePathBuilder() + "<br/><b>Application Version</b> : " + clsGlobal.ApplicationVersion(), false)) { Console.WriteLine(string.Format("MailSend : {0}", "Success")); } else { Console.WriteLine(string.Format("MailSend : {0}", "Fail")); } } } catch (Exception exMail) { Console.WriteLine(string.Format("MailSend : {0}", "Fail : " + exMail.Message)); } } else { Console.WriteLine(string.Format("Read DataTable : {0}", "No Data")); } try { fi.Delete(); } catch (Exception exDelete) { Console.WriteLine(string.Format("Delete file : {0} ({1})", "Fail", exDelete.Message)); } #endregion } else { Console.WriteLine(string.Format("Read File : {0} ({1})", "Fail", "FileIsLocked")); } } else { //ไม่เจอไฟล์ก็จบไป } #endregion }
private void btClearData_Click(object sender, EventArgs e) { DialogResult dr = MessageBox.Show("ข้อมูลทั้งหมดในระบบ Mobile จะถูกลบทิ้ง ยืนยันการลบข้อมูล ?", "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.No) { return; } #region Variable var strSQL = new string[] { "DELETE FROM patient;", "DELETE FROM patientchecklist;", "DELETE FROM patientlab;", "DELETE FROM checklistdetail;", "DELETE FROM checklist" }; var outMessage = ""; var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); #endregion #region Procedure if (clsSQL.IsConnected()) { for (int i = 0; i < strSQL.Length; i++) { if (!clsSQL.Execute(strSQL[i], out outMessage)) { MessageBox.Show(outMessage, "Error on ClearData", MessageBoxButtons.OK, MessageBoxIcon.Error); } } MessageBox.Show("ดำเนินการเสร็จสมบูรณ์", "Complete", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("ไม่สามารถเชื่อมต่อฐานข้อมูล Mobile ได้", "Database Connection Fail", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion }
public bool setChecklistToMobile(DataTable dt) { System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); #region Variable var result = true; var clsSQL = new clsSQL(clsGlobal.dbTypeMain, clsGlobal.csMain); var clsSQLMobile = new clsSQL(clsGlobal.dbType, clsGlobal.cs); var dv = dt.DefaultView; var dtProChkList = new DataTable(); var strSQL = ""; #endregion #region Procedure dtProChkList = dv.ToTable(true, "ProChkList"); if(dtProChkList!=null && dtProChkList.Rows.Count > 0) { for(int i = 0; i < dtProChkList.Rows.Count; i++) { var checklistID = ""; strSQL = "DELETE FROM Checklist WHERE Code='"+ dtProChkList.Rows[i][0].ToString().Trim() + "';"; clsSQLMobile.Execute(strSQL); #region Checklist strSQL = "SELECT TOP 1 id ChecklistID,Checklist Code,CheckListDesc Detail FROM Checklist WHERE Checklist='" + dtProChkList.Rows[i][0].ToString().Trim() + "';"; var dtChecklist = new DataTable(); dtChecklist = clsSQL.Bind(strSQL); if (dtChecklist != null && dtChecklist.Rows.Count > 0) { checklistID = dtChecklist.Rows[0]["ChecklistID"].ToString(); #region Insert if (!clsSQLMobile.Insert( "checklist", new string[,] { {"ChecklistID", dtChecklist.Rows[0]["ChecklistID"].ToString() }, {"Code", "'"+dtChecklist.Rows[0]["Code"].ToString().Trim().SQLQueryFilter()+"'" }, {"Detail", "'"+dtChecklist.Rows[0]["Detail"].ToString().SQLQueryFilter()+"'" } }, new string[,] { { } }, out strSQL)) { //If error, what you want to do? result = false; MessageBox.Show("Checklist Insert : " + strSQL, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion } #endregion #region ChecklistDetail if (checklistID != "") { strSQL = "SELECT TOP 100 rowid ProID,WFID,WFSequen,WorkFlow FROM Process WHERE CheckListid="+ checklistID + ";"; var dtChecklistDetail = new DataTable(); dtChecklistDetail = clsSQL.Bind(strSQL); if (dtChecklistDetail != null && dtChecklistDetail.Rows.Count > 0) { for(int j = 0; j < dtChecklistDetail.Rows.Count; j++) { #region Insert if (!clsSQLMobile.Insert( "checklistdetail", new string[,] { {"ChecklistID", checklistID }, {"ProID", dtChecklistDetail.Rows[j]["ProID"].ToString().Trim() }, {"WFID", dtChecklistDetail.Rows[j]["WFID"].ToString() }, {"WFSequen", dtChecklistDetail.Rows[j]["WFSequen"].ToString() }, {"WorkFlow", "'"+dtChecklistDetail.Rows[j]["WorkFlow"].ToString().SQLQueryFilter()+"'" } }, new string[,] { { } }, out strSQL)) { result = false; //If error, what you want to do? MessageBox.Show("ChecklistDetail Insert : " + strSQL, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } #endregion } } } #endregion } } #endregion return result; }