| | |
|---|
| | | throw (e); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //å®¡æ ¸(å
å«åå®¡æ ¸åæ§å¶) |
|---|
| | | //å®¡æ ¸(å
å«å®¡æ ¸åæ§å¶) |
|---|
| | | public bool CheckBill(Int64 lngBillKey, string HBillNo,string procName , string sUser, ref string sReturn) |
|---|
| | | { |
|---|
| | | string sql = ""; |
|---|
| | |
|---|
| | | oCn.BeginTran(); |
|---|
| | | |
|---|
| | | //æ´æ°åæ®ç¶æ |
|---|
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' Where HInterID=" + lngBillKey.ToString()); |
|---|
| | | |
|---|
| | | oCn.RunProc(" Update " + MvarItemKey + " set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "',HBillStatus=2 Where HInterID=" + lngBillKey.ToString()); |
|---|
| | | |
|---|
| | | //å®¡æ ¸åæ§å¶ |
|---|
| | | sql = "exec " + procName + " " + lngBillKey + ",'" + HBillNo + "','" + sUser + "'"; |
|---|
| | | ds = oCn.RunProcReturn(sql, procName); |
|---|
