private void gridData_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (gridData.Columns[e.ColumnIndex].Name == "colChageDoc" && e.RowIndex >= 0)
{
changing();
dataCls result = (dataCls)bindingData.Current;
int tpr_id = result.tpr_id;
bool success = true;
if (ableChangeDoctor(tpr_id))
{
frmSelectDoctor frm = new frmSelectDoctor();
frmSelectDoctor.selectDocType type = frm.getSelectType;
if (ableChangeDoctor(tpr_id))
{
if (type == frmSelectDoctor.selectDocType.SelectedDoctor)
{
success = new Class.FunctionDataCls().changeDoctor(result.tpr_id, frm.get_mut_username, "PE");
}
else if (type == frmSelectDoctor.selectDocType.NoRequestDoctor)
{
success = new Class.FunctionDataCls().cancelPEDoctor(result.tpr_id);
}
}
else
{
MessageBox.Show("ไม่สามารถเปลี่ยนแพทย์" + Environment.NewLine + "เนื่องจากได้มีการเรียกคนไข้เข้าห้องตรวจแล้ว", "Alert.", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("ไม่สามารถเปลี่ยนแพทย์" + Environment.NewLine + "เนื่องจากได้มีการเรียกคนไข้เข้าห้องตรวจแล้ว", "Alert.", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
changeDoctor();
}
}
private void chargeReport(string pInvoice) {
dataCls data = new dataCls();
string sql = "";
sql = @"SELECT I.INVOICE_ID,T.TABLE_ID,T.NUMBER AS tableno, I.NUMBER_INVOICE, I.DESCRIPTION CLIENT,
(SELECT sum( DET.QUANTITY * DET.PRICE) totalproducto
FROM INVOICE IC
INNER JOIN INVOICE_DETAIL DET ON DET.INVOICE_ID = IC.INVOICE_ID
INNER JOIN PRODUCTS P ON P.PRODUCT_ID = DET.PRODUCT_ID
INNER JOIN TABLES T ON T.TABLE_ID = IC.TABLE_ID
WHERE IC.INVOICE_ID = I.INVOICE_ID ) AS SUBTOTAL,
I.IVA,
(SELECT sum( DET.QUANTITY * DET.PRICE) totalproducto
FROM INVOICE IC
INNER JOIN INVOICE_DETAIL DET ON DET.INVOICE_ID = IC.INVOICE_ID
INNER JOIN PRODUCTS P ON P.PRODUCT_ID = DET.PRODUCT_ID
INNER JOIN TABLES T ON T.TABLE_ID = IC.TABLE_ID
WHERE IC.INVOICE_ID = I.INVOICE_ID ) TOTAL,
I.DATE_REGISTRATION,
P.DESCRIPTION AS PRODUCT, DET.QUANTITY, DET.PRICE AS PRICE, DET.QUANTITY * DET.PRICE TOTAL_PRODUCT, DET.DATE_REGISTRATION [DATE]
FROM INVOICE I
INNER JOIN INVOICE_DETAIL DET ON DET.INVOICE_ID = I.INVOICE_ID
INNER JOIN PRODUCTS P ON P.PRODUCT_ID = DET.PRODUCT_ID
INNER JOIN TABLES T ON T.TABLE_ID = I.TABLE_ID
WHERE I.INVOICE_ID = " + pInvoice;
this.DataSource = data.GET_DT(sql, data.CONECTION);
}
private void gridData_RowPrePaint(object sender, DataGridViewRowPrePaintEventArgs e)
{
DataGridView dgv = (DataGridView)sender;
dataCls data = (dataCls)dgv.Rows[e.RowIndex].DataBoundItem;
switch (data.status)
{
case "P":
dgv.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.FromArgb(248, 241, 7);
break;
case "R":
dgv.Rows[e.RowIndex].DefaultCellStyle.BackColor = Color.FromArgb(41, 242, 13);
break;
}
}
