private async Task <PIJIAresult> WriteIntoSQL_async(object[,] data, string strYM)
{
// 20200519 獨立成一個副程式
CSDataContext dc = new CSDataContext();
int totalN = data.GetUpperBound(0);
int add_N = 0;
int change_N = 0;
int all_N = 0;
await Task.Run(() =>
{
for (int i = 2; i <= totalN; i++)
{
// 找到KEY值, YM, bid: YM=strYM, bid=Item(1), 第二個值就是bid
// 查詢,看看是否有重複
// 沒有重複就是新增, 有重複就是修改
var q = from o in dc.tbl_pijia
where (o.YM == strYM) && (o.bid == (string)data[i, 2]) && (o.uid == (string)data[i, 14])
select o;
if (q.Count() == 0) // 資料庫裡面沒有 INSERT
{
// MedFee 有小數點, 所以要先變成double, 再變成int
tbl_pijia newPijia = new tbl_pijia()
{
YM = strYM,
STATUS = (string)data[i, header_order[1]],
bid = (string)data[i, header_order[2]],
op = (string)data[i, header_order[3]],
VDATE = (string)data[i, header_order[4]] ?? string.Empty,
SDATE = (string)data[i, header_order[5]],
VIST = (string)data[i, header_order[6]],
RMNO = (string)data[i, header_order[7]],
DEPTNAME = (string)data[i, header_order[8]],
DOCTNAME = (string)data[i, header_order[9]],
POSINAME = (string)data[i, header_order[10]],
HEATH_CARD = (string)data[i, header_order[11]] ?? string.Empty,
Youmian = (string)data[i, header_order[12]] ?? string.Empty,
PAYNO = (string)data[i, header_order[13]] ?? string.Empty,
uid = (string)data[i, header_order[14]],
cname = (string)data[i, header_order[15]],
MedFee = (int)double.Parse((string)data[i, header_order[16]]),
RegFee = int.Parse((string)data[i, header_order[17]]),
Copay = int.Parse((string)data[i, header_order[18]]),
Deposit = int.Parse((string)data[i, header_order[19]]),
SelfPay = int.Parse((string)data[i, header_order[20]]),
PharmW = int.Parse((string)data[i, header_order[21]]),
Arrears = int.Parse((string)data[i, header_order[22]]),
Discount = int.Parse((string)data[i, header_order[23]]),
AMTreceivable = int.Parse((string)data[i, header_order[24]]),
AMTreceived = int.Parse((string)data[i, header_order[25]]),
bremark = (string)data[i, header_order[26]] ?? string.Empty,
remark = (string)data[i, header_order[27]] ?? string.Empty,
QDATE = _qdate
};
// 20200526 加入QDATE
dc.tbl_pijia.InsertOnSubmit(newPijia);
dc.SubmitChanges();
add_N++;
}
else
{
// 資料庫裡已經有了, 檢查是否有異,有異UPDATE
tbl_pijia oldPijia = q.ToList()[0]; // this is a record
string strChange = string.Empty;
bool bChange = false;
if (oldPijia.STATUS != (string)data[i, header_order[1]])
{
strChange += $";改狀態: {oldPijia.STATUS}=>{(string)data[i, header_order[1]]}";
bChange = true;
oldPijia.STATUS = (string)data[i, header_order[1]];
}
if (oldPijia.op != (string)data[i, header_order[3]])
{
strChange += $";改批價人員: {oldPijia.op}=>{(string)data[i, header_order[3]]}";
bChange = true;
oldPijia.op = (string)data[i, header_order[3]];
}
if (oldPijia.VDATE != ((string)data[i, header_order[4]] ?? string.Empty))
{
strChange += $";改作廢日期: {oldPijia.VDATE}=>{((string)data[i, header_order[4]] ?? string.Empty)}";
bChange = true;
oldPijia.VDATE = ((string)data[i, header_order[4]] ?? string.Empty);
}
if (oldPijia.SDATE != (string)data[i, header_order[5]])
{
strChange += $";改看診日期: {oldPijia.SDATE}=>{(string)data[i, header_order[5]]}";
bChange = true;
oldPijia.SDATE = (string)data[i, header_order[5]];
}
if (oldPijia.VIST != (string)data[i, header_order[6]])
{
strChange += $";改午別: {oldPijia.VIST}=>{(string)data[i, header_order[6]]}";
bChange = true;
oldPijia.VIST = (string)data[i, header_order[6]];
}
if (oldPijia.RMNO != (string)data[i, header_order[7]])
{
strChange += $";改診別: {oldPijia.RMNO}=>{(string)data[i, header_order[7]]}";
bChange = true;
oldPijia.RMNO = (string)data[i, header_order[7]];
}
if (oldPijia.DEPTNAME != (string)data[i, header_order[8]])
{
strChange += $";改科別: {oldPijia.DEPTNAME}=>{(string)data[i, header_order[8]]}";
bChange = true;
oldPijia.DEPTNAME = (string)data[i, header_order[8]];
}
if (oldPijia.DOCTNAME != (string)data[i, header_order[9]])
{
strChange += $";改醫師: {oldPijia.DOCTNAME}=>{(string)data[i, header_order[9]]}";
bChange = true;
oldPijia.DOCTNAME = (string)data[i, header_order[9]];
}
if (oldPijia.POSINAME != (string)data[i, header_order[10]])
{
strChange += $";改身分: {oldPijia.POSINAME}=>{(string)data[i, header_order[10]]}";
bChange = true;
oldPijia.POSINAME = (string)data[i, header_order[10]];
}
if (oldPijia.HEATH_CARD != ((string)data[i, header_order[11]] ?? string.Empty))
{
strChange += $";改就醫序號: {oldPijia.HEATH_CARD}=>{((string)data[i, header_order[11]] ?? string.Empty)}";
bChange = true;
oldPijia.HEATH_CARD = ((string)data[i, header_order[11]] ?? string.Empty);
}
if (oldPijia.Youmian != ((string)data[i, header_order[12]] ?? string.Empty))
{
strChange += $";改優免: {oldPijia.Youmian}=>{((string)data[i, header_order[12]] ?? string.Empty)}";
bChange = true;
oldPijia.Youmian = ((string)data[i, header_order[12]] ?? string.Empty);
}
if (oldPijia.PAYNO != ((string)data[i, header_order[13]] ?? string.Empty))
{
strChange += $";改部分負擔: {oldPijia.PAYNO}=>{((string)data[i, header_order[13]] ?? string.Empty)}";
bChange = true;
oldPijia.PAYNO = ((string)data[i, header_order[13]] ?? string.Empty);
}
if (oldPijia.cname != (string)data[i, header_order[15]])
{
strChange += $";改患者姓名: {oldPijia.cname}=>{(string)data[i, header_order[15]]}";
bChange = true;
oldPijia.cname = (string)data[i, header_order[15]];
}
if (oldPijia.MedFee != (int)double.Parse((string)data[i, header_order[16]]))
{
strChange += $";改醫療費用: {oldPijia.MedFee}=>{(string)data[i, header_order[16]]}";
bChange = true;
oldPijia.MedFee = (int)double.Parse((string)data[i, header_order[16]]);
}
if (oldPijia.RegFee != int.Parse((string)data[i, header_order[17]]))
{
strChange += $";改掛號費用: {oldPijia.RegFee}=>{(string)data[i, header_order[17]]}";
bChange = true;
oldPijia.RegFee = int.Parse((string)data[i, header_order[17]]);
}
if (oldPijia.Copay != int.Parse((string)data[i, header_order[18]]))
{
strChange += $";改部分負擔: {oldPijia.Copay}=>{(string)data[i, header_order[18]]}";
bChange = true;
oldPijia.Copay = int.Parse((string)data[i, header_order[18]]);
}
if (oldPijia.Deposit != int.Parse((string)data[i, header_order[19]]))
{
strChange += $";改押金: {oldPijia.Deposit}=>{(string)data[i, header_order[19]]}";
bChange = true;
oldPijia.Deposit = int.Parse((string)data[i, header_order[19]]);
}
if (oldPijia.SelfPay != int.Parse((string)data[i, header_order[20]]))
{
strChange += $";改自付金額: {oldPijia.SelfPay}=>{(string)data[i, header_order[20]]}";
bChange = true;
oldPijia.SelfPay = int.Parse((string)data[i, header_order[20]]);
}
if (oldPijia.PharmW != int.Parse((string)data[i, header_order[21]]))
{
strChange += $";改藥費加重: {oldPijia.PharmW}=>{(string)data[i, header_order[21]]}";
bChange = true;
oldPijia.PharmW = int.Parse((string)data[i, header_order[21]]);
}
if (oldPijia.Arrears != int.Parse((string)data[i, header_order[22]]))
{
strChange += $";改欠收: {oldPijia.Arrears}=>{(string)data[i, header_order[22]]}";
bChange = true;
oldPijia.Arrears = int.Parse((string)data[i, header_order[22]]);
}
if (oldPijia.Discount != int.Parse((string)data[i, header_order[23]]))
{
strChange += $";改折扣: {oldPijia.Discount}=>{(string)data[i, header_order[23]]}";
bChange = true;
oldPijia.Discount = int.Parse((string)data[i, header_order[23]]);
}
if (oldPijia.AMTreceivable != int.Parse((string)data[i, header_order[24]]))
{
strChange += $";改應收金額: {oldPijia.AMTreceivable}=>{(string)data[i, header_order[24]]}";
bChange = true;
oldPijia.AMTreceivable = int.Parse((string)data[i, header_order[24]]);
}
if (oldPijia.AMTreceived != int.Parse((string)data[i, header_order[25]]))
{
strChange += $";改實收金額: {oldPijia.AMTreceived}=>{(string)data[i, header_order[25]]}";
bChange = true;
oldPijia.AMTreceived = int.Parse((string)data[i, header_order[25]]);
}
if (oldPijia.bremark != ((string)data[i, header_order[26]] ?? string.Empty))
{
strChange += $";改收據說明: {oldPijia.bremark}=>{((string)data[i, header_order[26]] ?? string.Empty)}";
bChange = true;
oldPijia.bremark = ((string)data[i, header_order[26]] ?? string.Empty);
}
if (oldPijia.remark != ((string)data[i, header_order[27]] ?? string.Empty))
{
strChange += $";改說明: {oldPijia.remark}=>{((string)data[i, header_order[27]] ?? string.Empty)}";
bChange = true;
oldPijia.remark = ((string)data[i, header_order[27]] ?? string.Empty);
}
if (bChange)
{
// tbl_opd的Pijia欄位也要歸零
var r = from opd in dc.tbl_opd
where opd.CASENO == oldPijia.CASENO
select opd;
tbl_opd opdOPD = r.ToList()[0];
opdOPD.Pijia = null;
// CASENO, G要歸零
oldPijia.CASENO = null;
oldPijia.G = null;
// 做實改變
// 20200526 加入QDATE
oldPijia.QDATE = _qdate;
dc.SubmitChanges();
change_N++;
// 做記錄
Logging.Record_admin("修改批價資料", $"{strYM}-{(string)data[i, 13]}: {strChange}");
}
}
all_N++;
}
});
return(new PIJIAresult()
{
NewPIJIA = add_N,
ChangePIJIA = change_N,
AllPIJIA = all_N
});
}
public void Transform()
{
#region 宣告
DataSet ds = new DataSet();
System.Data.DataTable dtO = new System.Data.DataTable();
System.Data.DataTable dtP = new System.Data.DataTable();
int new_opd_N = 0;
int change_opd_N = 0;
int change_order_N = 0;
int total_rows = 0;
#endregion 宣告
#region 整理datatable
//整理datatable, 分拆成兩個, 一旦可以通過,那這個檔案應該沒有問題,如果有問題,就不是正確的檔案
try
{
ds.ReadXml(_loadpath, XmlReadMode.ReadSchema);
dtP = ds.Tables[0]; // dtP for tbl_opd_order, P stands for prescription
dtP.Columns.Remove("STATUS");
dtP.Columns.Remove("REGNO");
dtP.Columns.Remove("PNAME");
dtP.Columns.Remove("SEX");
dtP.Columns.Remove("BIRTH");
dtP.Columns.Remove("ORI_TOTAL");
dtP.Columns.Remove("TOTAL");
dtP.Columns.Remove("AMT8");
dtP.Columns.Remove("RECT_NO");
dtO = dtP.Copy();
// 移除dtO不必要欄位, 先轉移給暫存檔, 因為要distinct, O stands for OPD
dtO.Columns.Remove("CODE");
dtO.Columns.Remove("ENAME");
dtO.Columns.Remove("TIMES_DAY");
dtO.Columns.Remove("METHODE");
dtO.Columns.Remove("TIME_QTY1");
dtO.Columns.Remove("DAYS");
dtO.Columns.Remove("BILL_QTY");
dtO.Columns.Remove("CHRONIC");
dtO.Columns.Remove("PUT_TYPE");
dtO.Columns.Remove("HC");
dtO.Columns.Remove("PRICE");
dtO.Columns.Remove("AMT");
dtO.Columns.Remove("ORI_AMT");
dtO.Columns.Remove("CLASS");
dtO.Columns.Remove("PRN_CODE");
dtO.Columns.Remove("RESULT");
// 移除dtP不需要的欄位(for tbl_opd_order)
dtP.Columns.Remove("VIST");
dtP.Columns.Remove("RMNO");
dtP.Columns.Remove("DEPTNAME");
dtP.Columns.Remove("DOCTNAME");
dtP.Columns.Remove("POSINAME");
dtP.Columns.Remove("PAYNO");
dtP.Columns.Remove("HEATH_CARD");
dtP.Columns.Remove("STEXT");
dtP.Columns.Remove("OTEXT");
dtP.Columns.Remove("ICDCODE1");
dtP.Columns.Remove("ICDCODE2");
dtP.Columns.Remove("ICDCODE3");
dtO = dtO.DefaultView.ToTable(true, new string[] { "CASENO", "SDATE", "VIST", "RMNO", "DEPTNAME", "DOCTNAME",
"IDNO", "POSINAME", "PAYNO", "HEATH_CARD", "STEXT", "OTEXT", "ICDCODE1", "ICDCODE2",
"ICDCODE3" }); // true stands for distinct
}
catch (Exception ex)
{
Logging.Record_error(ex.Message);
log.Error(ex.Message);
tb.ShowBalloonTip("錯誤!", ex.Message, BalloonIcon.Error);
return;
}
// 通過測試
total_rows = dtO.Rows.Count;
Logging.Record_admin("OPD file format", $"correct, {total_rows} records.");
log.Info($"OPD XML 檔案格式正確, 共{total_rows}筆.");
tb.ShowBalloonTip("正確", $"OPD XML 檔案格式正確, 共{total_rows}筆.", BalloonIcon.Info);
#endregion 整理datatable
#region 進行讀取資料
//Main.ProgressBar1.Minimum = 1
//Main.ProgressBar1.Maximum = totalN
CSDataContext dc = new CSDataContext();
// 開始回圈
foreach (DataRow dtO_Row in dtO.Rows)
{
//Main.ProgressBar1.Value = i + 1 // 顯示一下進度
// 檢查案號是否已經在資料庫中, dtO.CASENO, tbl_opd.CASENO
string strCASENO = (string)dtO_Row["CASENO"];
if (string.IsNullOrEmpty(strCASENO))
{
Logging.Record_error("在輸入門診資料時, 缺少案號CASENO");
log.Error("在輸入門診資料時, 缺少案號CASENO");
tb.ShowBalloonTip("錯誤!", "在輸入門診資料時, 缺少案號CASENO", BalloonIcon.Error);
// 下一個
continue;
}
var q = from o in dc.tbl_opd
where o.CASENO == strCASENO
select o;
if (q.Count() == 0) // 資料庫裡面沒有 INSERT
{
try
{
tbl_opd newOPD = new tbl_opd()
{
CASENO = strCASENO, // CASENO
VIST = (string)dtO_Row["VIST"], // VIST
RMNO = byte.Parse((string)dtO_Row["RMNO"]), // RMNO
uid = (string)dtO_Row["IDNO"], // uid
DEPTNAME = (string)dtO_Row["DEPTNAME"], // DEPTNAME
DOCTNAME = (string)dtO_Row["DOCTNAME"], // DOCTNAME
POSINAME = (string)dtO_Row["POSINAME"], // POSINAME
PAYNO = (string)dtO_Row["PAYNO"], // PAYNO
HEATH_CARD = (string)dtO_Row["HEATH_CARD"], // HEATH_CARD
ICDCODE1 = (string)dtO_Row["ICDCODE1"], // ICDCODE1
ICDCODE2 = (string)dtO_Row["ICDCODE2"], // ICDCODE2
ICDCODE3 = (string)dtO_Row["ICDCODE3"], // ICDCODE3
INS_CODE = "A", // INS_CODE, default value "A"
STEXT = (string)dtO_Row["STEXT"], // STEXT
OTEXT = (string)dtO_Row["OTEXT"], // OTEXT
QDATE = _qdate // 20200526 加入
};
string tempstr;
tempstr = dtO_Row["SDATE"].ToString();
if (DateTime.TryParse($"{tempstr.Substring(0, 4)}/{tempstr.Substring(4, 2)}/{tempstr.Substring(6, 2)}", out DateTime temp_date))
{
newOPD.SDATE = temp_date;
}
dc.tbl_opd.InsertOnSubmit(newOPD);
dc.SubmitChanges();
new_opd_N++;
// tbl_opd沒有資料, tbl_opd_order就一定沒有資料, 所以要加入, 這裡的挑戰是要加上醫令序
// datatable 此時不能使用LINQ查詢
List <DataRow> q2 = dtP.Select("CASENO='" + strCASENO + "'").ToList();
// 處理tbl_opd_order部分
int j = 1;
foreach (DataRow dtP_Row in q2)
{
tbl_opd_order newPr = new tbl_opd_order()
{
CASENO = strCASENO,
uid = (string)dtO_Row["IDNO"],
SDATE = temp_date,
OD_idx = (byte)(j + 1),
rid = (string)dtP_Row["CODE"], //CODE
TIMES_DAY = (string)dtP_Row["TIMES_DAY"], //TIMES_DAY
METHOD = (string)dtP_Row["METHODE"], //METHOD
TIME_QTY1 = (string)dtP_Row["TIME_QTY1"], //TIME_QTY1
DAYS = (string)dtP_Row["DAYS"], //DAYS
BILL_QTY = (string)dtP_Row["BILL_QTY"], //BILL_QTY
HC = (string)dtP_Row["HC"], //HC
PRICE = (string)dtP_Row["PRICE"], //PRICE
AMT = (string)dtP_Row["AMT"], //AMT
CLASS = (string)dtP_Row["CLASS"], //CLASS
CHRONIC = (string)dtP_Row["CHRONIC"], //CHRONIC
QDATE = _qdate // 20200526 加入
};
dc.tbl_opd_order.InsertOnSubmit(newPr);
dc.SubmitChanges();
j++;
}
}
catch (Exception ex)
{
log.Error(ex.Message);
tb.ShowBalloonTip("錯誤!", ex.Message, BalloonIcon.Error);
Logging.Record_error(ex.Message);
}
}
else // 資料庫裡已經有了, 檢查是否有異,有異UPDATE
{
// 先處理tbl_opd部分
tbl_opd oldOPD = (from p in dc.tbl_opd
where p.CASENO == strCASENO
select p).ToList()[0]; // this is a record
string strChange = string.Empty;
bool bChange = false;
try
{
string tempstr = string.Empty;
if (oldOPD.DEPTNAME != (string)dtO_Row["DEPTNAME"])
{
strChange += $"改科別: {oldOPD.DEPTNAME} => {dtO_Row["DEPTNAME"]}";
bChange = true;
oldOPD.DEPTNAME = (string)dtO_Row["DEPTNAME"]; // DEPTNAME
}
if (oldOPD.DOCTNAME != (string)dtO_Row["DOCTNAME"])
{
strChange += $"改醫師: {oldOPD.DOCTNAME} => {dtO_Row["DOCTNAME"]}";
bChange = true;
oldOPD.DOCTNAME = (string)dtO_Row["DOCTNAME"]; //DOCTNAME
}
if (oldOPD.POSINAME != (string)dtO_Row["POSINAME"])
{
strChange += $"改身分: {oldOPD.POSINAME} => {dtO_Row["POSINAME"]}";
bChange = true;
oldOPD.POSINAME = (string)dtO_Row["POSINAME"]; //POSINAME
}
if (oldOPD.PAYNO != (string)dtO_Row["PAYNO"])
{
strChange += $"改負擔: {oldOPD.PAYNO} => {dtO_Row["PAYNO"]}";
bChange = true;
oldOPD.PAYNO = (string)dtO_Row["PAYNO"]; //PAYNO
}
if (oldOPD.HEATH_CARD != (string)dtO_Row["HEATH_CARD"])
{
strChange += $"改卡號: {oldOPD.HEATH_CARD} => {dtO_Row["HEATH_CARD"]}";
bChange = true;
oldOPD.HEATH_CARD = (string)dtO_Row["HEATH_CARD"]; //HEATH_CARD
}
if (oldOPD.ICDCODE1 != (string)dtO_Row["ICDCODE1"])
{
strChange += $"改診斷1: {oldOPD.ICDCODE1} => {dtO_Row["ICDCODE1"]}";
bChange = true;
oldOPD.ICDCODE1 = (string)dtO_Row["ICDCODE1"]; //ICDCODE1
}
if (oldOPD.ICDCODE2 != (string)dtO_Row["ICDCODE2"])
{
strChange += $"改診斷2: {oldOPD.ICDCODE2} => {dtO_Row["ICDCODE2"]}";
bChange = true;
oldOPD.ICDCODE2 = (string)dtO_Row["ICDCODE2"]; //ICDCODE2
}
if (oldOPD.ICDCODE3 != (string)dtO_Row["ICDCODE3"])
{
strChange += $"改診斷3: {oldOPD.ICDCODE3} => {dtO_Row["ICDCODE3"]}";
bChange = true;
oldOPD.ICDCODE3 = (string)dtO_Row["ICDCODE3"]; //ICDCODE3
}
if (bChange == true)
{
// 做實改變
oldOPD.QDATE = _qdate;
dc.SubmitChanges();
change_opd_N++;
// 做記錄
Logging.Record_admin("update opd", $"{strCASENO}: {strChange}");
}
}
catch (Exception ex)
{
log.Error(strCASENO + ex.Message);
tb.ShowBalloonTip("錯誤!", strCASENO + ex.Message, BalloonIcon.Error);
Logging.Record_error(strCASENO + ex.Message);
}
// 再處理tbl_opd_order部分
// 先製造兩個list of tbl_opd_order
List <Prescription> oldPre = (from d in dc.tbl_opd_order
where d.CASENO == strCASENO
orderby d.rid, d.TIMES_DAY
select new Prescription()
{
CASENO = d.CASENO,
Rid = d.rid,
TIMES_DAY = d.TIMES_DAY,
METHOD = d.METHOD,
TIME_QTY1 = d.TIME_QTY1,
DAYS = d.DAYS,
BILL_QTY = d.BILL_QTY,
HC = d.HC,
PRICE = d.PRICE,
AMT = d.AMT,
CLAS = d.CLASS,
CHRONIC = d.CHRONIC
}).ToList();
List <Prescription> newPre = new List <Prescription>();
List <DataRow> q2 = dtP.Select($"CASENO='{strCASENO}'", "CODE, TIMES_DAY").ToList();
// 這個r.count一定大於等於1
// 處理tbl_opd_order部分
int totalP = q2.Count();
for (int j = 0; j < totalP; j++)
{
Prescription newP = new Prescription()
{
CASENO = strCASENO,
Rid = (string)q2[j]["CODE"], //CODE
TIMES_DAY = (string)q2[j]["TIMES_DAY"], //TIMES_DAY
METHOD = (string)q2[j]["METHODE"], //METHOD
TIME_QTY1 = (string)q2[j]["TIME_QTY1"], //TIME_QTY1
DAYS = (string)q2[j]["DAYS"], //DAYS
BILL_QTY = (string)q2[j]["BILL_QTY"], //BILL_QTY
HC = (string)q2[j]["HC"], //HC
PRICE = (string)q2[j]["PRICE"], //PRICE
AMT = (string)q2[j]["AMT"], //AMT
CLAS = (string)q2[j]["CLASS"], //CLASS
CHRONIC = (string)q2[j]["CHRONIC"] //CHRONIC
};
newPre.Add(newP);
}
// Now we have 2 lists now, but lists are only references
// 先比較兩者是否相同, 相同則跳下一筆
string strT = Exact(oldPre, newPre);
if (strT.Length != 0) // "" stands for identical
{
// 若不同則找出哪裡不同, 記錄下來
Logging.Record_admin("update opd order", $"{strCASENO}: {strT}");
// 最後把舊的刪掉, 插入新的
// 刪掉舊的
var q3 = from p in dc.tbl_opd_order
where p.CASENO == strCASENO
select p;
foreach (tbl_opd_order pr in q3)
{
dc.tbl_opd_order.DeleteOnSubmit(pr);
}
dc.SubmitChanges();
// 插入新的
// datatable 此時不能使用LINQ查詢
List <DataRow> q4 = dtP.Select($"CASENO='{strCASENO}'").ToList();
// 處理tbl_opd_order部分
int totalPr = q4.Count;
for (int j = 0; j < totalPr; j++)
{
tbl_opd_order newPr = new tbl_opd_order()
{
CASENO = strCASENO,
uid = oldOPD.uid,
SDATE = oldOPD.SDATE,
OD_idx = (byte)(j + 1),
rid = (string)q4[j]["CODE"], //CODE
TIMES_DAY = (string)q4[j]["TIMES_DAY"], //TIMES_DAY
METHOD = (string)q4[j]["METHODE"], //METHOD
TIME_QTY1 = (string)q4[j]["TIME_QTY1"], //TIME_QTY1
DAYS = (string)q4[j]["DAYS"], //DAYS
BILL_QTY = (string)q4[j]["BILL_QTY"], //BILL_QTY
HC = (string)q4[j]["HC"], //HC
PRICE = (string)q4[j]["PRICE"], //PRICE
AMT = (string)q4[j]["AMT"], //AMT
CLASS = (string)q4[j]["CLASS"], //CLASS
CHRONIC = (string)q4[j]["CHRONIC"], //CHRONIC
QDATE = _qdate // 20200526加入
};
dc.tbl_opd_order.InsertOnSubmit(newPr);
dc.SubmitChanges();
}
change_order_N++;
}
}
}
// 這樣的add opd沒什麼用
// Record_adm("add opd", dtO.TableName)
string summary = $"一共讀取{new_opd_N}筆新門診紀錄, 更改{change_opd_N}筆門診紀錄, 更改{change_order_N}筆醫令.";
tb.ShowBalloonTip("讀取完成", summary, BalloonIcon.Info);
log.Info(summary);
Logging.Record_admin("opd_import", summary);
dtO.Dispose();
dtP.Dispose();
ds.Dispose();
#endregion 進行讀取資料
this.Dispose();
}