protected void OnbtnPrint_Click(object sender, DirectEventArgs e)
{
string floor, timetype, area;
floor = Common.GetComboBoxValue(cboFLOOR);
if (floor == "")
{
floor = sFLOOR.Text;
}
area = Common.GetComboBoxValue(cboArea);
if (area == "")
{
area = sAREA.Text;
}
timetype = Common.GetComboBoxValue(cboTIME);
if (timetype == "")
{
timetype = sTIME.Text;
}
else
{
sTIME.Text = timetype;
}
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "../report/Report_Dialysis_h.aspx?_REPORT_NAME=weeksch" + "&_REPORT_sQM=" + sFLOOR.Text + "&_REPORT_P=" + timetype;
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
}
protected void OnbtnPrintS_Click(object sender, DirectEventArgs e)
{
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "../report/Report_Dialysis_h.aspx?_REPORT_NAME=drug_term&_PAT_IC=" + Patient_ID.Text + "&_REPORT_P=short";
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
}
protected void btnPrint_Click(object sender, DirectEventArgs e)
{
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "../report/Report_Dialysis_h.aspx?_REPORT_NAME=s01&_INFO_DATE=" + _Get_YMD2(DateField1.Text) + "&_REPORT_P=" + sTIME.Text;
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
}
protected void Btn_Print_Click(object Sender, DirectEventArgs e)
{
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "../report/Report_Dialysis_h.aspx?_PAT_ID=" + _PAT_ID + "&_REPORT_NAME=A09";
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
}
protected void OnbtnPrint_Click(object sender, DirectEventArgs e)
{
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "../report/Report_Dialysis_h.aspx?_PAT_ID=" + _PAT_ID + "&_INFO_DATE=" + sel_date.Text + "&_REPORT_NAME=f6a";
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
}
protected void OnbtnPrint_Click(object sender, DirectEventArgs e)
{
GetWeek();
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "report/Report_Dialysis_h.aspx?_REPORT_NAME=checkin&_INFO_DATE=" + sDATE.Text + "&_REPORT_P=" + sWEEK.Text + "&_REPORT_sQM=" + sFLOOR.Text;
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
}
protected void BtnPrint_Click(object sender, DirectEventArgs e)
{
string Url = "../report/Report_Dialysis_h.aspx?_PAT_IC=" + _PAT_IC + "&_BEG_DATE=" + _Get_YMD(start_date.Text) + "&_END_DATE=" + _Get_YMD(end_date.Text) + "&_REPORT_NAME=100";
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = Url;
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
}
protected void btnPrint_Click(object sender, DirectEventArgs e)
{
btnDetail_Click(sender, e);
toDay = DateTime.Now.ToString("yyyy-MM-dd");
string seldate = _Get_YMD2(this.DateField1.Text);
string sSQL2 = "SELECT * FROM drug_itemlist ";
sSQL2 += "WHERE dyivl_ivdate='" + toDay + "' ";
DataTable dt2 = db.Query(sSQL2);
string SerialNo = "";
if (dt2.Rows.Count > 0)
{
SerialNo = dt2.Rows[0]["dyivl_serialno"].ToString();
}
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "../report/Report_Dialysis_h.aspx?_INFO_DATE=" + seldate + "&_REPORT_NAME=s05&_REPORT_P=" + SerialNo;
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
}
protected void btnPrint_Click(object sender, DirectEventArgs e)
{
BtnSaveRight_Click(sender, e);
string sno = SNO.Text;
string date = RPT_DATE.Text;
if (sno != null && sno.Length > 0)
{
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "../report/Report_Dialysis_h.aspx?_INFO_DATE=" + date + "&_REPORT_NAME=s03&_REPORT_P=" + sno;
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
// update the print log
string dateString = DateTime.Now.ToString("yyyy-MM-dd");
string SQLT_IV_UPDATE = "UPDATE dailyiv_list SET dyiv_printdate = '{0}' WHERE dyiv_serialno = '{1}'; ";
string sqlUpdate = string.Format(SQLT_IV_UPDATE, dateString, sno);
db.Excute(sqlUpdate);
//扣庫存
string sSQL = "SELECT * FROM dailyiv_itemlist ";
sSQL += "WHERE dyivl_serialno='" + sno + "' AND dyivl_rec='N'";
DataTable dt = db.Query(sSQL);
int outamt = 0;
int invamt = 0;
foreach (DataRow row in dt.Rows)
{
string item = row["dyivl_item"].ToString();
int qty = int.Parse(row["right_qty"].ToString()); //正確的領用數量
string sql = "SELECT invs_outamt, invs_invamt FROM inventory_stock ";
sql += "WHERE invs_name='" + item + "'";
DataTable dt1 = db.Query(sql);
if (dt1.Rows.Count > 0)
{
outamt = int.Parse(dt1.Rows[0]["invs_outamt"].ToString()) + qty;
invamt = int.Parse(dt1.Rows[0]["invs_invamt"].ToString()) - qty;
try
{
sql = "UPDATE inventory_stock SET ";
sql += "invs_outamt='" + outamt + "',";
sql += "invs_invamt='" + invamt + "',";
sql += "invs_lastupdate='" + date + "' ";
sql += "WHERE invs_name='" + item + "'; ";
sql += "UPDATE dailyiv_itemlist SET ";
sql += "dyivl_rec='Y', ";
sql += "dyivl_qty=right_qty ";
sql += "WHERE dyivl_serialno='" + sno + "'; ";
db.Excute(sql);
}
catch (Exception ex)
{
_NotificationShow("储存失败!");
}
}
}
//扣庫存
}
else
{
_NotificationShow("请选择要列印的项目。");
}
}
protected void BtnPrint_Click(object sender, DirectEventArgs e)
{
string json = e.ExtraParams["SelectedRow"];
Dictionary <string, string>[] selRow = JSON.Deserialize <Dictionary <string, string>[]>(json);
ChangeRecords <InvReturnModel> recs = new StoreDataHandler(e.ExtraParams["data"]).BatchObjectData <InvReturnModel>();
string dateString = DateTime.Now.ToString("yyyy-MM-dd");
if (selRow.Count() > 0)
{
dateString = selRow[0]["dyiv_ivdate"];
}
// 原则上这样的行为只会有 insert.
string SQLT_INV_RETURN_UPDATE = @"
UPDATE inv_return
SET invr_rtnamt='{0}',
invr_datereturn='{1}'
WHERE invr_id = '{2}'; ";
string SQLT_INV_RETURN_INSERT = @"
INSERT INTO inv_return (invr_no, invr_name, invr_preamt, invr_rtnamt, invr_serialno, invr_datereturn)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}'); ";
// inserting or update?
try {
if (recs.Updated.Count > 0)
{
int id;
string sql = "";
if (int.TryParse(recs.Updated[0].Id, out id))
{
foreach (InvReturnModel curItem in recs.Updated)
{
sql += string.Format(SQLT_INV_RETURN_UPDATE,
curItem.RetAmt,
dateString,
curItem.Id);
}
}
else
{
foreach (InvReturnModel curItem in recs.Updated)
{
sql += string.Format(SQLT_INV_RETURN_INSERT,
curItem.No,
curItem.Name,
curItem.PreAmt,
curItem.RetAmt,
curItem.SerialNo,
dateString);
}
db.Excute(sql);
}
}
if (selRow.Count() > 0)
{
string serialno = selRow[0]["dyiv_serialno"].ToString();
string usrnm = selRow[0]["dyiv_usrnm"].ToString();
string printdate = selRow[0]["dyiv_printdate"];
string ivdate = selRow[0]["dyiv_ivdate"];
PrintWindow.Show();
PrintWindow.Loader.SuspendScripting();
PrintWindow.Loader.Url = "../report/Report_Dialysis_h.aspx?_INFO_DATE=" + ivdate + "&_REPORT_NAME=s04&_REPORT_P=" + serialno;
PrintWindow.Loader.DisableCaching = true;
PrintWindow.LoadContent();
//入庫存
string sSQL = "SELECT * FROM inv_return ";
sSQL += "WHERE invr_serialno='" + serialno + "' AND invr_rtnamt<>'0' ";
DataTable dt = db.Query(sSQL);
int inamt = 0;
int invamt = 0;
foreach (DataRow row in dt.Rows)
{
string item = row["invr_name"].ToString();
int qty = int.Parse(row["invr_preamt"].ToString());
string sql = "SELECT invs_inamt, invs_invamt FROM inventory_stock ";
sql += "WHERE invs_name='" + item + "'";
DataTable dt1 = db.Query(sql);
if (dt1.Rows.Count > 0)
{
inamt = int.Parse(dt1.Rows[0]["invs_inamt"].ToString()) - qty;
invamt = int.Parse(dt1.Rows[0]["invs_invamt"].ToString()) + qty;
try
{
sql = "UPDATE inventory_stock SET ";
sql += "invs_inamt='" + inamt + "',";
sql += "invs_invamt='" + invamt + "',";
sql += "invs_lastupdate='" + printdate + "' ";
sql += "WHERE invs_name='" + item + "'; ";
sql += "UPDATE inv_return SET invr_rec='Y' ";
sql += "WHERE invr_serialno='" + serialno + "';";
db.Excute(sql);
}
catch (Exception ex)
{
_NotificationShow("储存失败!");
}
}
}
//入庫存
}
else
{
_NotificationShow("请选择要列印的项目。");
}
} catch (Exception ex) {
Common._ErrorMsgShow(ex.Message.ToString());
}
}