private void BindProchklistMapPackage(string Prochklist)
{
exc = new ExcData();
string SQL = "SELECT [ProChkList] ,[PackageCode] FROM [tblProchklistMapPackage] where [ProChkList] = '" + Prochklist + "' AND StatusFlag = 'A'";
gvProchklistMapPackage.DataSource = exc.data_Table(SQL);
gvProchklistMapPackage.Refresh();
}
private void BindProChkList()
{
exc = new Database.ExcData();
string SQL = "SELECT [CheckList] ,[CheckListDesc] FROM [Checklist] ORDER BY CheckList DESC";
ddlProChkList.DataSource = exc.data_Table(SQL);
ddlProChkList.DisplayMember = "CheckList";
ddlProChkList.ValueMember = "CheckList";
ddlProChkList.Refresh();
}
private void btFind_Click(object sender, EventArgs e)
{
ExcData exc = new ExcData();
DataTable dtPatient = new DataTable();
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");
string SQL = "SELECT Forename as Name , Surname as LastName , DOE , ProChkList, NO FROM [tblPatientList] WHERE DOE BETWEEN '" + DateFrom + "' AND '" + DateTo + "'";
dtPatient = exc.data_Table(SQL);
gvPatient.DataSource = dtPatient;
gvPatient.Columns["Check"].Width = 50;
gvPatient.Refresh();
lblCountPT.Text = dtPatient.Rows.Count.ToString();
CheckAll();
}
//public string FindPatientScheduleOrderUID(string PatientUID, string DOE)
//{
// string PatientScheduleOrderUID = "";
// string SQL = "select UID,ScheduleOrderNumber from PatientScheduleOrder where PatientUID = '" + PatientUID + "' and ScheduledDttm = '" + DOE + "'";
// exc = new ExcData();
// DataTable dt = new DataTable();
// dt = exc.data_Table(SQL);
// PatientScheduleOrderUID = dt.Rows[0]["UID"].ToString();
// return PatientScheduleOrderUID;
// SqlCommand cmd = new SqlCommand();
// DataTable dt = new DataTable();
// string SQL = @"select UID,ScheduleOrderNumber from PatientScheduleOrder where PatientUID = '" + PatientUID + "' and ScheduledDttm = '" + DOE + "'";
// string PatientUID = string.Empty;
// try
// {
// this.Connect();
// cmd.Connection = con;
// cmd.CommandType = CommandType.Text;
// cmd.CommandText = SQL;
// dt.Load(cmd.ExecuteReader());
// PatientUID = dt.Rows[0]["UID"].ToString();
// }
// catch (Exception er)
// {
// MessageBox.Show(er.Message.ToString());
// }
// finally
// {
// this.Disconnect();
// }
// return PatientUID;
//}
public DataTable FindPackage(string PackageCode)
{
DataTable dt = new DataTable();
string SQL = "select UID , PackageName from BillPackage where Code = '" + PackageCode + "'";
exc = new ExcData();
dt = exc.data_Table(SQL);
return dt;
}
private void btSave_Click(object sender, EventArgs e)
{
exc = new ExcData();
string SQL = string.Empty;
string SQLChk = string.Empty;
int NowRow = 0;
foreach (DataGridViewRow row in gvPackage.Rows)
{
//Loop ทำงานเฉพาะคนที่ Check Box
if (Convert.ToBoolean(row.Cells["Check"].Value) == true)
{
SQLChk = "SELECT * FROM [tblProchklistMapPackage] where ProChkList = '" + ddlProChkList.SelectedValue.ToString() + "' and PackageCode = '" + gvPackage.Rows[NowRow].Cells["Code"].Value.ToString() + "' and StatusFlag = 'A'";
DataTable dtChk = new DataTable();
dtChk = exc.data_Table(SQLChk);
if (dtChk.Rows.Count <= 0 || dtChk == null)
{
SQL = "INSERT INTO [tblProchklistMapPackage]([ProChkList] ,[PackageCode] ,[StatusFlag])"
+ " VALUES('" + ddlProChkList.SelectedValue.ToString() + "' ,'" + gvPackage.Rows[NowRow].Cells["Code"].Value.ToString() + "' ,'A')";
if (exc.ExecData(SQL) == false)
{
MessageBox.Show("Save package code : " + gvPackage.Rows[NowRow].Cells["Code"].Value.ToString() + " failed.");
}
}
}
NowRow++;
}
BindProchklistMapPackage(ddlProChkList.SelectedValue.ToString());
}
private void btFind_Click(object sender, EventArgs e)
{
ExcData exc = new ExcData();
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");
string SQL = string.Empty;
if(lblGenLabNo.Checked == true)
{
SQL = "SELECT Forename as Name , Surname as LastName , DOE , [NO] , [ChildCompany],[STS] FROM [tblPatientList] WHERE DOE BETWEEN '" + DateFrom + "' AND '" + DateTo + "' ORDER BY NO";
}
else
{
SQL = "SELECT Forename as Name , Surname as LastName , DOE , [NO] , [ChildCompany],[STS] FROM [tblPatientList] WHERE DOE BETWEEN '" + DateFrom + "' AND '" + DateTo + "' AND STS in ('A','R') ORDER BY STS DESC , NO";
}
dtPatient = exc.data_Table(SQL);
bs.DataSource = dtPatient;
gvPatient.DataSource = bs;
gvPatient.Refresh();
lblCountPT.Text = dtPatient.Rows.Count.ToString();
if (lblGenLabNo.Checked == true)
{
CheckAll();
}
else
{
CheckOnlyStatusRA();
}
}
private void btFind_Click(object sender, EventArgs e)
{
ExcData exc = new ExcData();
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");
string SQL = string.Empty;
var strSQL = new StringBuilder();
if (rdbPayor.IsChecked == true)
{
strSQL.Append("SELECT A.HN,A.Name,A.LastName,A.DOE,A.[NO],A.[Payor],B.[BookCreate],A.[Shift],A.[LabEpisode] LabNo,A.[DOB] ");
strSQL.Append("FROM [Patient] A ");
strSQL.Append("LEFT JOIN tblPatientList B ON A.HN=B.HN AND A.DOE=B.DOE ");
strSQL.Append("WHERE A.DOE BETWEEN '" + DateFrom + "' AND '" + DateTo + "' ORDER BY NO;");
//SQL = "SELECT HN, Name , LastName , DOE , [NO] , [Payor],[BookCreate],[Shift], [LabEpisode] LabNo ,[DOB] FROM [Patient] WHERE DOE BETWEEN '" + DateFrom + "' AND '" + DateTo + "' ORDER BY NO";
}
else
{
strSQL.Append("SELECT A.HN,A.Name,A.LastName,A.DOE,A.[NO],A.[Payor],B.[BookCreate],A.[Shift],A.[LabEpisode] LabNo,A.[DOB] ");
strSQL.Append("FROM [Patient] A ");
strSQL.Append("LEFT JOIN tblPatientList B ON A.HN=B.HN AND A.DOE=B.DOE ");
strSQL.Append("WHERE A.HN='" + txtHN.Text.Trim() + "' ORDER BY NO;");
//SQL = "SELECT HN, Name , LastName , DOE , [NO] , [Payor],[BookCreate],[Shift], [LabEpisode] LabNo ,[DOB] FROM [Patient] WHERE HN = '" + txtHN.Text.Trim() + "' ORDER BY DOE DESC";
}
dtPatient = exc.data_Table(strSQL.ToString());
strSQL.Length = 0; strSQL.Capacity = 0;
if (dtPatient != null && dtPatient.Rows.Count > 0)
{
bs.DataSource = dtPatient;
gvPatient.DataSource = bs;
gvPatient.Columns["HN"].Width = 80;
gvPatient.Columns["Name"].Width = 130;
gvPatient.Columns["LastName"].Width = 130;
gvPatient.Columns["DOE"].Width = 100;
gvPatient.Columns["NO"].Width = 50;
gvPatient.Columns["Payor"].Width = 200;
gvPatient.Columns["BookCreate"].Width = 100;
gvPatient.Columns["Shift"].Width = 80;
gvPatient.Columns["LabNo"].Width = 50;
gvPatient.Columns["DOB"].Width = 50;
gvPatient.Refresh();
}
else
{
MessageBox.Show("ไม่พบข้อมูล");
}
lblCountPT.Text = dtPatient.Rows.Count.ToString() + " Record.";
CheckAll();
}
private DataTable FindProchklistMapPackage(string ProChkList)
{
exc = new ExcData();
//db = new SQL();
string SQL = "SELECT [ProChkList] ,[PackageCode] FROM [tblProchklistMapPackage] WHERE [ProChkList] = '" + ProChkList + "' AND StatusFlag = 'A'";
return exc.data_Table(SQL);
}
private void btFind_Click(object sender, EventArgs e)
{
ExcData exc = new ExcData();
DataTable dtPatient = new DataTable();
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");
string SQL = "SELECT Forename as Name , Surname as LastName , DOE , ProChkList, NO, ChildCompany FROM [tblPatientList] WHERE DOE BETWEEN '" + DateFrom + "' AND '" + DateTo + "'";
dtPatient = exc.data_Table(SQL);
bs.DataSource = dtPatient;
gvPatient.DataSource = bs;
gvPatient.Columns["Name"].Width = 150;
gvPatient.Columns["LastName"].Width = 150;
gvPatient.Columns["DOE"].Width = 140;
gvPatient.Columns["NO"].Width = 50;
gvPatient.Columns["ChildCompany"].Width = 200;
gvPatient.Columns["ProChkList"].Width = 100;
gvPatient.Refresh();
lblCountPT.Text = dtPatient.Rows.Count.ToString();
CheckAll();
txtFilterPayor.Enabled = true;
btLoad.Enabled = true;
}
private void btFind_Click(object sender, EventArgs e)
{
ExcData exc = new ExcData();
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");
string SQL = string.Empty;
SQL = "SELECT Forename as Name , Surname as LastName , DOE , [NO] , [ChildCompany],HNStatus,[STS] FROM [tblPatientList] WHERE DOE BETWEEN '" + DateFrom + "' AND '" + DateTo + "' ORDER BY NO";
dtPatient = exc.data_Table(SQL);
bs.DataSource = dtPatient;
gvPatient.DataSource = bs;
gvPatient.Columns["Name"].Width = 150;
gvPatient.Columns["LastName"].Width = 150;
gvPatient.Columns["DOE"].Width = 140;
gvPatient.Columns["NO"].Width = 50;
gvPatient.Columns["ChildCompany"].Width = 230;
gvPatient.Columns["HNStatus"].Width = 50;
gvPatient.Columns["STS"].Width = 50;
gvPatient.Refresh();
lblCountPT.Text = dtPatient.Rows.Count.ToString() + " Record.";
CheckAll();
}