public void DataConnectionTests_SOut_HasInjectionChars()
{
Assert.IsTrue(SOut.HasInjectionChars("'"));
Assert.IsTrue(SOut.HasInjectionChars("\""));
Assert.IsTrue(SOut.HasInjectionChars("\r"));
Assert.IsTrue(SOut.HasInjectionChars("\n"));
Assert.IsTrue(SOut.HasInjectionChars("\t"));
Assert.IsTrue(SOut.HasInjectionChars("'\"\r\n\t"));
Assert.IsTrue(SOut.HasInjectionChars("abc\t"));
Assert.IsFalse(SOut.HasInjectionChars(""));
Assert.IsFalse(SOut.HasInjectionChars("a"));
Assert.IsFalse(SOut.HasInjectionChars("12345"));
Assert.IsFalse(SOut.HasInjectionChars("abcde"));
Assert.IsFalse(SOut.HasInjectionChars("^@bcd3$"));
}
// 动态显示每次药品出库的批发价和零售价的总金额
private void SelectPrice()
{
decimal price = 0;
foreach (ListViewItem item in this.listView_DrugOut.Items)
{
object[] o = item.Tag as object[];
SOut dgout = o[0] as SOut;
decimal dprice = dgout.SalePrice;
decimal number = dgout.Number;
price += number * dprice;
}
lbl_price.Text = string.Format("{0:0.00}", price) + "元";
lbl_SelectPrice.Visible = true;
lbl_price.Visible = true;
}
///<summary></summary>
public static DataTable GetPatUncollected(DateTime dateFrom, DateTime dateTo, List <long> listClinicNums)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
return(Meth.GetTable(MethodBase.GetCurrentMethod(), dateFrom, dateTo, listClinicNums));
}
#if DEBUG
Stopwatch s = new Stopwatch();
s.Start();
#endif
bool hasClinicsEnabled = ReportsComplex.RunFuncOnReportServer(() => Prefs.HasClinicsEnabledNoCache);
List <long> listHiddenUnearnedDefNums = ReportsComplex.RunFuncOnReportServer(() =>
Defs.GetDefsNoCache(DefCat.PaySplitUnearnedType).FindAll(x => !string.IsNullOrEmpty(x.ItemValue)).Select(x => x.DefNum).ToList()
);
string query = $@"SELECT proc.ProcDate,CONCAT(patient.LName,', ',patient.FName) Patient,procedurecode.AbbrDesc,proc.Fee,
proc.Fee-proc.InsEst PatPortion,
COALESCE(adj.adjAmt,0) Adjustment,
COALESCE(pay.splitAmt,0) Payment,
proc.Fee-proc.InsEst+COALESCE(adj.adjAmt,0)-COALESCE(pay.splitAmt,0) Uncollected
FROM (
SELECT procedurelog.ProcNum,procedurelog.CodeNum,procedurelog.ProcDate,procedurelog.PatNum,
procedurelog.ProcFee*(procedurelog.BaseUnits+procedurelog.UnitQty)
-SUM(IF(claimproc.Status={SOut.Int((int)ClaimProcStatus.CapComplete)},claimproc.WriteOff,0)) Fee,
SUM(IF(claimproc.Status={SOut.Int((int)ClaimProcStatus.NotReceived)},claimproc.InsPayEst,
IF(claimproc.Status IN({SOut.Int((int)ClaimProcStatus.Received)},{SOut.Int((int)ClaimProcStatus.Supplemental)}),claimproc.InsPayAmt,0)))
+SUM(IF(claimproc.Status NOT IN({SOut.Int((int)ClaimProcStatus.CapComplete)},{SOut.Int((int)ClaimProcStatus.InsHist)}),claimproc.WriteOff,0)) InsEst
FROM procedurelog
LEFT JOIN claimproc ON claimproc.ProcNum=procedurelog.ProcNum
AND claimproc.Status IN ({
string.Join(",",new[] { ClaimProcStatus.NotReceived,ClaimProcStatus.Received,ClaimProcStatus.Supplemental,ClaimProcStatus.CapComplete }
.Select(x => SOut.Int((int)x)))})
WHERE procedurelog.ProcStatus={SOut.Int((int)ProcStat.C)}
AND procedurelog.ProcDate BETWEEN {SOut.Date(dateFrom)} AND {SOut.Date(dateTo)}" ;
if (hasClinicsEnabled && listClinicNums.Count > 0)
{
query += $@"
AND procedurelog.ClinicNum IN({string.Join(",",listClinicNums.Select(x => SOut.Long(x)))})" ;
}
query += $@"
GROUP BY procedurelog.ProcNum
ORDER BY NULL
) proc
INNER JOIN patient ON patient.PatNum=proc.PatNum
INNER JOIN procedurecode ON procedurecode.CodeNum=proc.CodeNum
LEFT JOIN (
SELECT adjustment.ProcNum,SUM(adjustment.AdjAmt) adjAmt
FROM adjustment
WHERE adjustment.ProcNum!=0
AND adjustment.ProcDate BETWEEN {SOut.Date(dateFrom)} AND {SOut.Date(dateTo)}
GROUP BY adjustment.ProcNum
ORDER BY NULL
) adj ON adj.ProcNum=proc.ProcNum
LEFT JOIN (
SELECT paysplit.ProcNum,SUM(paysplit.SplitAmt) splitAmt
FROM paysplit
WHERE paysplit.ProcNum!=0 " ;
if (listHiddenUnearnedDefNums.Count > 0)
{
query += $"AND paysplit.UnearnedType NOT IN ({string.Join(",",listHiddenUnearnedDefNums)}) ";
}
query += @"GROUP BY paysplit.ProcNum
ORDER BY NULL
) pay ON pay.ProcNum=proc.ProcNum
WHERE proc.Fee-proc.InsEst+COALESCE(adj.adjAmt,0)-COALESCE(pay.splitAmt,0)>0.005
ORDER BY proc.ProcDate,patient.LName,patient.FName,procedurecode.ProcCode" ;
DataTable table = ReportsComplex.RunFuncOnReportServer(() => Db.GetTable(query));
#if DEBUG
s.Stop();
Console.WriteLine("Total time to generate report with " + string.Format("{0:#,##0.##}", table.Rows.Count) + " rows: "
+ (s.Elapsed.Hours > 0?(s.Elapsed.Hours + " hours "):"") + (s.Elapsed.Minutes > 0?(s.Elapsed.Minutes + " min "):"")
+ (s.Elapsed.TotalSeconds - (s.Elapsed.Hours * 60 * 60) - (s.Elapsed.Minutes * 60)) + " sec");
#endif
return(table);
}
