private void load()
{
string sql = "SELECT [PKEY],[TRADING_DATE],[BILL_NUMBER],[VOUCHERS_NUMBER],[BILL_NAME],[BILL_TYPE_ID],[SOURCE_BILL_NUMBER],[EXCHANGES_UNIT],";
sql += "[TURNOVER],[BALANCE],[MAKE_ORDER_STAFF],[ORDERR_EVIEW],[IS_REVIEW],[NOTE] FROM [dbo].[CASH_CASHSUB_LEDGER] ORDER BY TRADING_DATE";
m_cashCashsubLedgerList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql))
{
foreach (DataRow row in dataTable.Rows)
{
CashCashsubLedgerTable record = new CashCashsubLedgerTable();
record.pkey = DbDataConvert.ToInt32(row["PKEY"]);
record.tradingDate = DbDataConvert.ToDateTime(row["TRADING_DATE"]).ToString("yyyy-MM-dd");
record.billNumber = DbDataConvert.ToString(row["BILL_NUMBER"]);
record.vouchersNumber = DbDataConvert.ToString(row["VOUCHERS_NUMBER"]);
record.billName = DbDataConvert.ToString(row["BILL_NAME"]);
record.billTypeID = DbDataConvert.ToInt32(row["BILL_TYPE_ID"]);
record.sourceBillNumber = DbDataConvert.ToString(row["SOURCE_BILL_NUMBER"]);
record.exchangesUnit = DbDataConvert.ToInt32(row["EXCHANGES_UNIT"]);
if (record.billName == "付款单")
{
record.billTypeName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_PAYMENT_TYPE_LIST", record.billTypeID);
record.exchangesUnitName = Supplier.getInctance().getSupplierNameFromPkey(record.exchangesUnit);
}
else
{
record.billTypeName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_RECEIVABLE_TYPE_LIST", record.billTypeID);
record.exchangesUnitName = Customer.getInctance().getCustomerNameFromPkey(record.exchangesUnit);
}
record.turnover = DbDataConvert.ToDouble(row["TURNOVER"]);
record.makeOrderStaff = DbDataConvert.ToInt32(row["MAKE_ORDER_STAFF"]);
record.makeOrderStaffName = Staff.getInctance().getStaffNameFromPkey(record.makeOrderStaff);
record.isReview = DbDataConvert.ToString(row["IS_REVIEW"]);
record.note = DbDataConvert.ToString(row["NOTE"]);
if (record.isReview == "1")
{
record.balance = DbDataConvert.ToDouble(row["BALANCE"]);
record.orderReview = DbDataConvert.ToInt32(row["ORDERR_EVIEW"]);
record.orderReviewName = Staff.getInctance().getStaffNameFromPkey(record.orderReview);
}
m_cashCashsubLedgerList.Add(m_cashCashsubLedgerList.Count, record);
}
}
}
public CashCashsubLedgerTable getCashCashsubLedgerInfoFromOrderNumber(string billNumber)
{
if (m_cashCashsubLedgerList.Count == 0)
{
load();
}
CashCashsubLedgerTable bill = new CashCashsubLedgerTable();
foreach (KeyValuePair <int, CashCashsubLedgerTable> index in m_cashCashsubLedgerList)
{
if (index.Value.billNumber == billNumber)
{
bill = index.Value;
}
}
return(bill);
}
public void insert(CashCashsubLedgerTable record)
{
if (checkBillIsExist(record.billNumber))
{
delete(record.billNumber);
}
string insert = "INSERT INTO [dbo].[CASH_CASHSUB_LEDGER]([TRADING_DATE],[BILL_NUMBER],[VOUCHERS_NUMBER],[BILL_NAME],";
insert += "[BILL_TYPE_ID],[SOURCE_BILL_NUMBER],[EXCHANGES_UNIT],[TURNOVER],[MAKE_ORDER_STAFF],[IS_REVIEW],[NOTE]) VALUES(";
insert += "'" + record.tradingDate + "',";
insert += "'" + record.billNumber + "',";
insert += "'" + record.vouchersNumber + "',";
insert += "'" + record.billName + "',";
insert += record.billTypeID + ",";
insert += "'" + record.sourceBillNumber + "',";
insert += record.exchangesUnit + ",";
insert += record.turnover + ",";
insert += record.makeOrderStaff + ", 0 ,";
insert += "'" + record.note + "'";
insert += ")";
try
{
DatabaseAccessFactoryInstance.Instance.ExecuteCommand(FormMain.DB_NAME, insert);
load();
MessageBoxExtend.messageOK("数据保存成功");
}
catch (Exception error)
{
MessageBoxExtend.messageWarning(error.Message);
return;
}
}
