SQL语句
'for payment type
sCmd = "Select Sum(B.PaymentAmount) As SPaymentAmount, Sum(B.Changes) As SChange, "
sCmd = sCmd & " B.PaymentType from Trans A INNER JOIN TransPayment B ON A.TransID = B.TransID "
sCmd = sCmd & " Where B.BusinessDate " & sDtCr & " And "
sCmd = sCmd & " A.TransStatus In (2, 3, 4) "
sCmd = sCmd & " Group By B.PaymentType "
sCmd = sCmd & " Order By B.PaymentType"
Set oRs = oCmn.ExecRS(sCmd, SDCN)
Do While Not oRs.EOF
cTotalSales = cTotalSales + IIf(IsNull(oRs!SPaymentAmount), 0, oRs!SPaymentAmount)
If UCase(Trim(oRs!PaymentType)) = "CASH" Then
cCashInDrawer = cCashInDrawer + IIf(IsNull(oRs!SPaymentAmount), 0, oRs!SPaymentAmount)
End If
sPrnLn = Space(9) & PADR(Trim(oRs!PaymentType), 10) & ": " & PADR(oCurrency.FormatCurrency(IIf(IsNull(oRs!SPaymentAmount), 0, oRs!SPaymentAmount), , , True), 10)
AddContents sPrnLn
'P_PrintText sPrnLn, oPrn
相关问答：
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
我一个项目，有个插入操作，具体是这样的：
我有进货信息表。在出货时选择相应的进货信息，输入数量，选择部门后，点保存按钮，由于网络延时，点一下没有反映，于是用户就又点一下，导致一次插入了两条记录:
例：
......
从数据库中查询一张表的数据
select 部门,姓名 from tb
如何才能生成下面的xml格式
XML code:
<folder state="unchecked" label="全部">
<folder state="unchecked&qu ......
protected void btnLogin_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
