public MDIMassConvert()
{
InitializeComponent();
UsageLogBuilder();
#region TitleBuilder
Version version = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version;
strVersion = version.Major.ToString() +
"." + version.Minor.ToString();
this.Text = this.Text + " v." + strVersion;
#endregion
#region FooterBuilder
Database.SQL clsSQL = new Database.SQL();
string[] splitBConnect1 = clsSQL.Path.Split(';');
string[] splitBConnectIP = splitBConnect1[0].Split('=');
string[] splitBConnectDB = splitBConnect1[1].Split('=');
string[] splitCheckup1 = System.Configuration.ConfigurationManager.AppSettings["MobieConnect"].Split(';');
string[] splitCheckupIP = splitCheckup1[0].Split('=');
string[] splitCheckupDB = splitCheckup1[3].Split('=');
radLabelElement1.Text = string.Format(
"MassConvert v.{0} | LastUpdate : {1} | B-Connect : {2}/{3} | Checkup : {4}/{5}",
strVersion,
LastUpdateBuilder().ToString("dd/MM/yyyy HH:mm"),
splitBConnectIP[1],
splitBConnectDB[1],
splitCheckupIP[1],
splitCheckupDB[1]);
#endregion
}
private DataTable BindProchklistMapPackage(DateTime DOE)
{
db = new SQL();
DateTime ChkDate = new DateTime();
ChkDate = Convert.ToDateTime(DOE);
string SQL = "SELECT UID, PatientScheduleOrderUID,ItemName,BillPackageUID,PatientUID FROM [BDMSPatientScheduleOrderDetail] where StartDttm = '" + ChkDate + "' and StatusFlag = 'A'";
return db.FindDataTable(SQL);
}
private void btFindPackage_Click(object sender, EventArgs e)
{
db = new SQL();
gvPackage.DataSource = db.Select_Package_by_PackageName(txtPackage.Text.Trim());
//gvPackage.Columns["Chk"].Width = 50;
gvPackage.Columns["UID"].Width = 50;
gvPackage.Columns["Code"].Width = 150;
gvPackage.Refresh();
}
private void btFindRepeat_Click(object sender, EventArgs e)
{
string DateFrom = dtpDateFrom.Value.ToString("yyyy-MM-dd") + " " + dtpTimeFrom.Value.ToString("HH:mm");
string DateTo = dtpDateTo.Value.ToString("yyyy-MM-dd") + " " + dtpTimeTo.Value.ToString("HH:mm");
db = new SQL();
string SQL = "SELECT UID, PatientScheduleOrderUID,ItemName,BillPackageUID,PatientUID FROM [BDMSPatientScheduleOrderDetail] where StartDttm BETWEEN '" + DateFrom + "' and '" + DateTo + "' and StatusFlag = 'A'";
gvPatient.DataSource = db.FindDataTable(SQL);
gvPatient.Columns["UID"].Width = 100;
gvPatient.Columns["PatientScheduleOrderUID"].Width = 100;
gvPatient.Columns["ItemName"].Width = 300;
gvPatient.Columns["BillPackageUID"].Width = 100;
gvPatient.Columns["PatientUID"].Width = 100;
gvPatient.Refresh();
lblCountPT.Text = gvPatient.Rows.Count.ToString();
txtFilterPayor.Enabled = false;
btLoad.Enabled = false;
}
private void frmConvertPayor_Load(object sender, EventArgs e)
{
setLabel(lblProgressDetail, "");
db = new SQL();
dtpDateFrom.Value = DateTime.Today;
dtpDateTo.Value = DateTime.Today;
dtpTimeFrom.Value = Convert.ToDateTime("00:00:00");
dtpTimeTo.Value = Convert.ToDateTime("23:59:59");
setPayor();
CheckCareproviderUID(Login_UID);
AddingCheckBoxColumn();
ddlIsConverted.SelectedIndex = 0;
//BindPayor();
}
private void FormIndividual_Load(object sender, System.EventArgs e)
{
db = new SQL();
CheckCareproviderUID(Login_UID);
}
private void txtHN_TextChanged(object sender, EventArgs e)
{
if (txtHN.Text.Length == 12)
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
var clsSQL = new clsSQLNative();
var strSQL = "";
db = new SQL();
DataTable dtPatient = new DataTable();
dtPatient = db.Select_Patient_By_HN(txtHN.Text.Trim());
if (dtPatient.Rows.Count > 0 && dtPatient != null)
{
MassConvertLogHN = dtPatient.Rows[0]["PASID"].ToString();
strSQL = "SELECT TOP 1 rowguid FROM Patient WHERE HN='" + MassConvertLogHN + "' /*AND DOE BETWEEN '" + dtpDateFrom.Value.ToString("yyyy-MM-dd HH:mm") + "' AND '" + dtpDateTo.Value.ToString("yyyy-MM-dd HH:mm") + "'*/ ORDER BY DOE DESC;";
MassConvertLogPatientUID = clsSQL.Return(strSQL, clsSQLNative.DBType.SQLServer, "MobieConnect");
txtPTName.Text = dtPatient.Rows[0]["Forename"] + " " + dtPatient.Rows[0]["Surname"] + "";
}
}
}
private void frmConvertIndividual_Load(object sender, EventArgs e)
{
db = new SQL();
dtpDateFrom.Value = DateTime.Today;
dtpDateTo.Value = DateTime.Today;
dtpTimeFrom.Value = Convert.ToDateTime("06:00:00");
dtpTimeTo.Value = Convert.ToDateTime("06:00:00");
CheckCareproviderUID(Login_UID);
}
//Load Form
private void Form1_Load(object sender, EventArgs e)
{
//MessageBox.Show(DateTime.Today.AddHours(45).ToString("dd MMM yyyy hh:mm:ss"));
db = new SQL();
//CheckCareproviderUID(textBox1.Text);
CheckCareproviderUID(Login_UID);
AddingCheckBoxColumn();
//DataTable pdt = db.Select_InsuranceCompany();
//if (pdt != null && pdt.Rows.Count > 0)
//{
// cboPayor.DataSource = pdt;
// cboPayor.DisplayMember = "CompanyName";
// cboPayor.ValueMember = "UID";
//}
//DataTable cdt = db.Select_CareProvider();
//if (cdt != null && cdt.Rows.Count > 0)
//{
// comboBox2.DataSource = cdt;
// comboBox2.DisplayMember = "FullName";
// comboBox2.ValueMember = "UID";
//}
//DataTable ldt = db.Select_Location_Condition("'Dispensing','Medical Records','Pac_Ward','Pac_Bed'");
//if (ldt != null && ldt.Rows.Count > 0)
//{
// cbLocationOrder.DataSource = ldt;
// cbLocationOrder.DisplayMember = "Name";
// cbLocationOrder.ValueMember = "UID";
//}
//DataTable edt = db.Select_EncouterType();
//if (edt != null && edt.Rows.Count > 0)
//{
// this.comboBox1.DataSource = edt;
// this.comboBox1.DisplayMember = "Description";
// this.comboBox1.ValueMember = "UID";
//}
//DataTable ordto = db.Select_OrderToLocationUID("124", "55653", "null");
//if (ordto != null && ordto.Rows.Count > 0)
// MessageBox.Show(ordto.Rows[0][0].ToString());
}
private void btLoad_Click(object sender, EventArgs e)
{
db = new SQL();
string PatientUID = string.Empty;
string Forename = string.Empty;
string Surname = string.Empty;
string strDOE = string.Empty;
DateTime DOE = new DateTime();
string PackageCode = string.Empty;
int PatientScheduleOrderUID = 0;
int PackageUID = 0;
string PackageName = string.Empty;
string ProChkList = string.Empty;
string SQLIns = string.Empty;
int BDMSPatientScheduleOrderDetailUID = 0;
progressBar1.Maximum = gvPatient.Rows.Count;
progressBar1.Value = 0;
//วนลูปอ่านจาก Gride
for (int i = 1; i <= gvPatient.Rows.Count; i++)
{
if (Convert.ToBoolean(gvPatient.Rows[i - 1].Cells["Check"].Value) == true)
{
//Forename
Forename = gvPatient.Rows[i - 1].Cells["Name"].Value.ToString().Trim();
//Surname
Surname = gvPatient.Rows[i - 1].Cells["LastName"].Value.ToString().Trim();
//DOE
DOE = Convert.ToDateTime(gvPatient.Rows[i - 1].Cells["DOE"].Value);
//ProChkList
ProChkList = gvPatient.Rows[i - 1].Cells["ProChkList"].Value.ToString().Trim();
//หา PatientUID
PatientUID = FindPatientUID(Forename.Trim(), Surname.Trim(), DOE);
//หา PatientScheduleOrderUID
PatientScheduleOrderUID = Convert.ToInt32(FindPatientScheduleOrderUID(PatientUID.Trim(), DOE));
//หาว่า ProCheckList นี้ผูกกับ Package อะไรบ้าง
DataTable dtProMapPackage = new DataTable();
dtProMapPackage = FindProchklistMapPackage(ProChkList.Trim());
for (int j = 0; j <= dtProMapPackage.Rows.Count - 1; j++)
{
//หา Package
DataTable dtPackage = new DataTable();
dtPackage = FindPackage(dtProMapPackage.Rows[j]["PackageCode"].ToString());
//PackageUID
PackageUID = Convert.ToInt32(dtPackage.Rows[0]["UID"].ToString());
//PackageName
PackageName = dtPackage.Rows[0]["PackageName"].ToString();
//เช็คว่าเคย Load ไปแล้วหรือยัง
BDMSPatientScheduleOrderDetailUID = CheckRepeat(PatientUID, PatientScheduleOrderUID, PackageUID, DOE);
if (BDMSPatientScheduleOrderDetailUID == 0)
{
if (db.Insert_BDMSPatientScheduleOrderDetail(PatientScheduleOrderUID, PackageName.Trim(), PackageUID, DOE, PatientUID.Trim()) == false)
{
MessageBox.Show("Save failed");
}
}
else
{
if (db.Update_BDMSPatientScheduleOrderDetail(PatientScheduleOrderUID, PackageName.Trim(), PackageUID, DOE, PatientUID.Trim(), BDMSPatientScheduleOrderDetailUID, PackageName) == false)
{
MessageBox.Show("Update failed");
}
}
}
}
progressBar1.Value += 1;
}
gvPatient.DataSource = BindProchklistMapPackage(DOE);
gvPatient.Columns["UID"].Width = 50;
gvPatient.Columns["PatientScheduleOrderUID"].Width = 50;
gvPatient.Columns["BillPackageUID"].Width = 50;
gvPatient.Columns["PatientUID"].Width = 50;
gvPatient.Refresh();
MessageBox.Show("Seccessful");
}
private string FindPatientUID(string ForeName, string SurName, DateTime DOE)
{
string PatientUID = "";
//string SQL = "select UID from Patient where Forename = N'" + ForeName + "' and Surname = N'" + SurName + "' and StatusFlag = 'A'";
string SQL = "select p.UID from patient p inner join patientscheduleorder ps on p.uid = ps.patientuid where p.forename = N'" + ForeName + "' and p.surname = N'" + SurName + "' and p.statusflag = 'A' and ps.statusflag = 'A' and ScheduledDttm = '" + DOE + "'";
//exc = new ExcData();
db = new SQL();
DataTable dt = new DataTable();
dt = db.FindDataTable(SQL);
if (dt.Rows.Count > 0)
{
PatientUID = dt.Rows[0]["UID"].ToString();
}
return PatientUID;
}
private string FindPatientScheduleOrderUID(string PatientUID, DateTime DOE)
{
DateTime ChkDate = new DateTime();
ChkDate = Convert.ToDateTime(DOE);
string PatientScheduleOrderUID = "0";
string SQL = "select UID,ScheduleOrderNumber from PatientScheduleOrder where PatientUID = '" + PatientUID + "' and ScheduledDttm = '" + ChkDate + "' and StatusFlag = 'A'";
//exc = new ExcData();
db = new SQL();
DataTable dt = new DataTable();
dt = db.FindDataTable(SQL);
if (dt.Rows.Count > 0)
{
PatientScheduleOrderUID = dt.Rows[0]["UID"].ToString();
}
return PatientScheduleOrderUID;
}
private DataTable FindPackage(string PackageCode)
{
DataTable dt = new DataTable();
string SQL = "select UID , PackageName from BillPackage where Code = '" + PackageCode + "' and StatusFlag = 'A'";
//exc = new ExcData();
db = new SQL();
dt = db.FindDataTable(SQL);
return dt;
}
private int CheckRepeat(string PatientUID, int PatientSchedulOrderUID, int PackageUID, DateTime DOE)
{
int UID = 0;
string SQL = string.Empty;
SQL = "select UID from BDMSPatientScheduleOrderDetail "
+ "where PatientUID = " + PatientUID + " and PatientScheduleOrderUID = " + PatientSchedulOrderUID + " and BillPackageUID = " + PackageUID + " and StartDttm = '" + DOE + "' and StatusFlag = 'A'";
DataTable dt = new DataTable();
db = new SQL();
dt = db.FindDataTable(SQL);
if (dt.Rows.Count > 0 && dt != null)
{
UID = Convert.ToInt32(dt.Rows[0]["UID"]);
}
return UID;
}
private void frmGenLabNo_Load(object sender, EventArgs e)
{
db = new SQL();
dtpDateFrom.Value = DateTime.Today;
dtpDateTo.Value = DateTime.Today;
dtpTimeFrom.Value = Convert.ToDateTime("06:00:00");
dtpTimeTo.Value = Convert.ToDateTime("06:00:00");
CheckCareproviderUID(Login_UID);
AddingCheckBoxColumn();
}
