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