| | |
|---|
| | | "," + oSub.HPayTotal.ToString() + "," + oSub.HSubsidyTotal.ToString() + "," + oSub.HDeuctTotal.ToString() + "," + oSub.HShoudPay.ToString() + "," + oSub.HInsurance.ToString() + "," + oSub.HTaxBefore.ToString() + "," + oSub.HTax.ToString() + "," + oSub.HRelPay.ToString() + |
|---|
| | | "," + Convert.ToString(oSub.HPayStatus ? 1 : 0) + ",'" + oSub.HPayRemark + "','" + oSub.HUnPayRemark + "'" + |
|---|
| | | " "; |
|---|
| | | foreach (Model.ClsGy_SelfEntryValue oSelfValue in oSub.oSelfValue) |
|---|
| | | { |
|---|
| | | sInsertSubBill = sInsertSubBill + "," + oSelfValue.HSQLColumnName; |
|---|
| | | DBUtility.Xt_BaseBillFun.Sub_GetSelfInsertSQL(ref sInsertSubBillValue, oSelfValue.HDataType, oSelfValue.HValue); |
|---|
| | | } |
|---|
| | | sInsertSubBillValue = sInsertSubBillValue + ")"; |
|---|
| | | oCn.RunProc(sInsertSubBill + sInsertSubBillValue); |
|---|
| | | //foreach (Model.ClsGy_SelfEntryValue oSelfValue in oSub.oSelfValue) |
|---|
| | | //{ |
|---|
| | | // sInsertSubBill = sInsertSubBill + "," + oSelfValue.HSQLColumnName; |
|---|
| | | // DBUtility.Xt_BaseBillFun.Sub_GetSelfInsertSQL(ref sInsertSubBillValue, oSelfValue.HDataType, oSelfValue.HValue); |
|---|
| | | //} |
|---|
| | | //sInsertSubBillValue = sInsertSubBillValue + ")"; |
|---|
| | | //oCn.RunProc(sInsertSubBill + sInsertSubBillValue); |
|---|
| | | //èªå®ä¹å æ°å¢ å¹» |
|---|
| | | } |
|---|
| | | // |
|---|
