private void load()
{
string sql = "SELECT [PKEY],[DEPARTMENT_ID],[TRADING_DATE],[BILL_NUMBER],[EXCHANGES_UNIT],[SUM_VALUE],[SUM_MONEY],";
sql += "[MAKE_ORDER_STAFF],[MATERIEL_STAFF],[ORDERR_REVIEW],[REVIEW_DATE],[IS_REVIEW],[STAFF_SAVE_ID],[IS_RED_BILL] ";
sql += "FROM [dbo].[WAREHOUSE_MANAGEMENT_OUT] ORDER BY PKEY";
m_tableDataList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql))
{
foreach (DataRow row in dataTable.Rows)
{
MaterielOutOrderTable record = new MaterielOutOrderTable();
record.pkey = DbDataConvert.ToInt32(row["PKEY"]);
record.departmentID = DbDataConvert.ToInt32(row["DEPARTMENT_ID"]);
record.departmentName = AuxiliaryMaterial.getInctance().getAuxiliaryMaterialNameFromPkey("BASE_DEPARTMENT_LIST", record.departmentID);
record.tradingDate = DbDataConvert.ToDateTime(row["TRADING_DATE"]).ToString("yyyy-MM-dd");
record.billNumber = DbDataConvert.ToString(row["BILL_NUMBER"]);
record.exchangesUnit = DbDataConvert.ToString(row["EXCHANGES_UNIT"]);
record.sumValue = DbDataConvert.ToString(row["SUM_VALUE"]);
record.sumMoney = DbDataConvert.ToString(row["SUM_MONEY"]);
record.staffSaveId = DbDataConvert.ToInt32(row["STAFF_SAVE_ID"]);
record.staffSaveName = Staff.getInctance().getStaffNameFromPkey(record.staffSaveId);
record.materielOutStaffId = DbDataConvert.ToInt32(row["MATERIEL_STAFF"]);
record.materielOutStaffName = Staff.getInctance().getStaffNameFromPkey(record.materielOutStaffId);
record.makeOrderStaff = DbDataConvert.ToInt32(row["MAKE_ORDER_STAFF"]);
record.makeOrderStaffName = Staff.getInctance().getStaffNameFromPkey(record.makeOrderStaff);
record.isReview = DbDataConvert.ToString(row["IS_REVIEW"]);
if (DbDataConvert.ToString(row["ORDERR_REVIEW"]).Length > 0)
{
record.orderrReview = DbDataConvert.ToInt32(row["ORDERR_REVIEW"]);
record.orderrReviewName = Staff.getInctance().getStaffNameFromPkey(record.orderrReview);
record.reviewDate = DbDataConvert.ToDateTime(row["REVIEW_DATE"]).ToString("yyyy-MM-dd");
}
record.isRedBill = DbDataConvert.ToInt32(row["IS_RED_BILL"]);
m_tableDataList.Add(m_tableDataList.Count, record);
}
}
}
private void load()
{
string sql = "SELECT [PKEY],[TRADING_DATE],[BILL_NUMBER],[EXCHANGES_UNIT],[SUM_VALUE],[SUM_MONEY],[MAKE_ORDER_STAFF],[APPLY_STAFF]";
sql += ",[ORDERR_REVIEW],[REVIEW_DATE],[IS_REVIEW] ";
sql += " FROM [dbo].[WAREHOUSE_MANAGEMENT_PRO_OCCUPIED] ORDER BY PKEY";
m_tableDataList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql))
{
foreach (DataRow row in dataTable.Rows)
{
MaterielProOccupiedOrderTable record = new MaterielProOccupiedOrderTable();
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.exchangesUnit = DbDataConvert.ToString(row["EXCHANGES_UNIT"]);
record.sumValue = DbDataConvert.ToString(row["SUM_VALUE"]);
record.sumMoney = DbDataConvert.ToString(row["SUM_MONEY"]);
record.makeOrderStaff = DbDataConvert.ToInt32(row["MAKE_ORDER_STAFF"]);
record.makeOrderStaffName = Staff.getInctance().getStaffNameFromPkey(record.makeOrderStaff);
record.applyStaffId = DbDataConvert.ToInt32(row["APPLY_STAFF"]);
record.applyStaffName = Staff.getInctance().getStaffNameFromPkey(record.applyStaffId);
record.makeOrderStaff = DbDataConvert.ToInt32(row["MAKE_ORDER_STAFF"]);
record.makeOrderStaffName = Staff.getInctance().getStaffNameFromPkey(record.makeOrderStaff);
record.isReview = DbDataConvert.ToString(row["IS_REVIEW"]);
if (DbDataConvert.ToString(row["ORDERR_REVIEW"]).Length > 0)
{
record.orderrReview = DbDataConvert.ToInt32(row["ORDERR_REVIEW"]);
record.orderrReviewName = Staff.getInctance().getStaffNameFromPkey(record.orderrReview);
record.reviewDate = DbDataConvert.ToDateTime(row["REVIEW_DATE"]).ToString("yyyy-MM-dd");
}
m_tableDataList.Add(m_tableDataList.Count, record);
}
}
}
private void load()
{
string sql = "SELECT [PKEY],[CUSTOMER_ID],[TRADING_DATE],[BILL_NUMBER],[SALE_TYPE],[PAYMENT_DATE],";
sql += "[EXCHANGES_UNIT],[BUSINESS_PEOPLE_ID],[SUM_VALUE],[SUM_MONEY],[SUM_TRANSPORTATION_COST],[SUM_OTHER_COST],";
sql += "[TOTAL_MONEY], [MAKE_ORDER_STAFF],[ORDERR_REVIEW],[REVIEW_DATE],[IS_REVIEW],";
sql += "[SOURCE_BILL_TYPE], [SOURCE_BILL_NUMBER],[STAFF_SAVE_ID],[STAFF_CHECK_ID],[RECEIVED_OK],[RECEIVED_NO_OK],";
sql += "[IS_RED_BILL],[IS_IN_LEDGER],[ORDERR_IN_LEDGER],[IN_LEDGER_DATE] ";
sql += "FROM [dbo].[SALE_OUT_ORDER] ORDER BY PKEY DESC";
m_tableDataList.Clear();
using (DataTable dataTable = DatabaseAccessFactoryInstance.Instance.QueryDataTable(FormMain.DB_NAME, sql))
{
foreach (DataRow row in dataTable.Rows)
{
SaleOutOrderTable record = new SaleOutOrderTable();
record.pkey = DbDataConvert.ToInt32(row["PKEY"]);
record.customerId = DbDataConvert.ToInt32(row["CUSTOMER_ID"]);
record.customerName = Customer.getInctance().getCustomerNameFromPkey(record.customerId);
record.tradingDate = DbDataConvert.ToDateTime(row["TRADING_DATE"]).ToString("yyyy-MM-dd");
record.billNumber = DbDataConvert.ToString(row["BILL_NUMBER"]);
record.saleType = DbDataConvert.ToString(row["SALE_TYPE"]);
record.paymentDate = DbDataConvert.ToDateTime(row["PAYMENT_DATE"]).ToString("yyyy-MM-dd");
record.exchangesUnit = DbDataConvert.ToString(row["EXCHANGES_UNIT"]);
record.businessPeopleId = DbDataConvert.ToInt32(row["BUSINESS_PEOPLE_ID"]);
record.businessPeopleName = Staff.getInctance().getStaffNameFromPkey(record.businessPeopleId);
record.makeOrderStaff = DbDataConvert.ToInt32(row["MAKE_ORDER_STAFF"]);
record.makeOrderStaffName = Staff.getInctance().getStaffNameFromPkey(record.makeOrderStaff);
if (DbDataConvert.ToString(row["ORDERR_REVIEW"]).Length > 0)
{
record.orderrReview = DbDataConvert.ToInt32(row["ORDERR_REVIEW"]);
record.orderrReviewName = Staff.getInctance().getStaffNameFromPkey(record.orderrReview);
record.reviewDate = DbDataConvert.ToDateTime(row["REVIEW_DATE"]).ToString("yyyy-MM-dd");
}
record.isReview = DbDataConvert.ToString(row["IS_REVIEW"]);
record.sumValue = DbDataConvert.ToString(row["SUM_VALUE"]);
record.sumMoney = DbDataConvert.ToString(row["SUM_MONEY"]);
record.sumTransportationCost = DbDataConvert.ToString(row["SUM_TRANSPORTATION_COST"]);
record.sumOtherCost = DbDataConvert.ToString(row["SUM_OTHER_COST"]);
record.totalMoney = DbDataConvert.ToString(row["TOTAL_MONEY"]);
// 销售出库单比销售订单中多出的字段
record.sourceBillType = DbDataConvert.ToString(row["SOURCE_BILL_TYPE"]);
record.sourceBillNumber = DbDataConvert.ToString(row["SOURCE_BILL_NUMBER"]);
record.staffSaveId = DbDataConvert.ToInt32(row["STAFF_SAVE_ID"]);
record.staffSaveName = Staff.getInctance().getStaffNameFromPkey(record.staffSaveId);
record.staffCheckId = DbDataConvert.ToInt32(row["STAFF_CHECK_ID"]);
record.staffCheckName = Staff.getInctance().getStaffNameFromPkey(record.staffCheckId);
// 已收款金额和未收款金额
record.paymentOk = DbDataConvert.ToString(row["RECEIVED_OK"]);
record.paymentNoOk = DbDataConvert.ToString(row["RECEIVED_NO_OK"]);
// 红字蓝字标示和是否入账标记
record.isRedBill = DbDataConvert.ToInt32(row["IS_RED_BILL"]);
// 记账相关信息
if (DbDataConvert.ToString(row["ORDERR_IN_LEDGER"]).Length > 0)
{
record.orderInLedger = DbDataConvert.ToInt32(row["ORDERR_IN_LEDGER"]);
record.orderInLedgerName = Staff.getInctance().getStaffNameFromPkey(record.orderrReview);
record.inLedgerDate = DbDataConvert.ToDateTime(row["IN_LEDGER_DATE"]).ToString("yyyy-MM-dd");
}
record.isInLedger = DbDataConvert.ToInt32(row["IS_IN_LEDGER"]);
m_tableDataList.Add(m_tableDataList.Count, record);
}
}
}
