本文整理汇总了C#中ADODB.Recordset.update方法的典型用法代码示例。如果您正苦于以下问题:C# ADODB.Recordset.update方法的具体用法?C# ADODB.Recordset.update怎么用?C# ADODB.Recordset.update使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类ADODB.Recordset
的用法示例。
在下文中一共展示了ADODB.Recordset.update方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: printTransactionA4
//.........这里部分代码省略.........
//rsNew("transactionItem_quantity").DefinedSize = rsNew("transactionItem_price").DefinedSize
//rsNew2("transactionItem_quantity").Attributes = rsNew("transactionItem_price").Attributes
//rsNew2("transactionItem_quantity").NumericScale = rsNew("transactionItem_price").NumericScale
//rsNew2("transactionItem_quantity").Precision = rsNew("transactionItem_price").Precision
foreach (lineItem lineitem_Renamed_loopVariable in lTransaction.lineItems) {
lineitem_Renamed = lineitem_Renamed_loopVariable;
rsNew.AddNew();
if (lineitem_Renamed.revoke) {
} else {
rsNew.Fields("transactionItem_build").Value = lineitem_Renamed.build;
rsNew.Fields("transactionItem_code").Value = lineitem_Renamed.code;
rsNew.Fields("transactionItem_depositType").Value = lineitem_Renamed.depositType;
rsNew.Fields("transactionItem_id").Value = lineitem_Renamed.id;
rsNew.Fields("transactionItem_lineNo").Value = lineitem_Renamed.lineNo;
rsNew.Fields("transactionItem_name").Value = lineitem_Renamed.name;
rsNew.Fields("transactionItem_originalPrice").Value = lineitem_Renamed.originalPrice;
rsNew.Fields("transactionItem_price").Value = lineitem_Renamed.price;
rsNew.Fields("transactionItem_quantity").Value = lineitem_Renamed.quantity;
rsNew.Fields("transactionItem_receiptName").Value = Strings.LTrim(Strings.Mid(lineitem_Renamed.receiptName, Strings.InStr(1, lineitem_Renamed.receiptName, "x") + 1, Strings.Len(lineitem_Renamed.receiptName)));
//lineitem.receiptName
rsNew.Fields("transactionItem_reversal").Value = lineitem_Renamed.reversal;
rsNew.Fields("transactionItem_revoke").Value = lineitem_Renamed.revoke;
rsNew.Fields("transactionItem_set").Value = lineitem_Renamed.setBuild;
rsNew.Fields("transactionItem_shrink").Value = lineitem_Renamed.shrink;
rsNew.Fields("transactionItem_type").Value = lineitem_Renamed.transactionType;
rsNew.Fields("transactionItem_vat").Value = lineitem_Renamed.vat;
if (lineitem_Renamed.vat > 0)
lnVat = lnVat + ((lineitem_Renamed.quantity * lineitem_Renamed.price) - ((lineitem_Renamed.quantity * lineitem_Renamed.price) / (1 + (lineitem_Renamed.vat / 100))));
QuoteTotal = QuoteTotal + (lineitem_Renamed.quantity * lineitem_Renamed.price);
//If gParameters.A4Exclusive = True Then TCurrency = TCurrency + ((lineitem.quantity * lineitem.price) / (1 + (lineitem.vat) / 100))
//TCurrency = 0 'TCurrency + ((lineitem.quantity * lineitem.price) / (1 + (lineitem.vat) / 100))
rsNew.update();
}
}
//rsNew.MoveFirst
//vValue = rsNew("transactionItem_quantity")
vValue = "";
lRetVal = modUtilities.RegOpenKeyEx(modUtilities.HKEY_LOCAL_MACHINE, "Software\\4POS\\pos", 0, modUtilities.KEY_QUERY_VALUE, ref hkey);
lRetVal = modUtilities.QueryValueEx(hkey, "A4Items", ref vValue);
modUtilities.RegCloseKey(hkey);
if (string.IsNullOrEmpty(vValue))
vValue = "0";
if (vValue == "1") {
rsNew.Sort = "transactionItem_receiptName";
} else if (vValue == "0") {
}
Report.Database.Tables(1).SetDataSource(rsNew);
//Report.Database.Tables(2).SetDataSource rsNew, 3
Report.SetParameterValue("txtCompanyName", lTransaction.companyName);
Report.SetParameterValue("txtCompanyDetails1", lTransaction.heading1);
if (!string.IsNullOrEmpty(lTransaction.heading2)) {
Report.SetParameterValue("txtCompanyDetails2", lTransaction.heading2);
if (!string.IsNullOrEmpty(lTransaction.heading3)) {
Report.SetParameterValue("txtCompanyDetails3", lTransaction.heading3);
//If gParameters.tr_PrintInvoice = False Then
if (!string.IsNullOrEmpty(lTransaction.taxNumber)) {
Report.SetParameterValue("txtCompanyDetails4", "TAX NO :" + lTransaction.taxNumber);
}
//End If
} else {