| | |
|---|
| | | string sql = string.Empty; |
|---|
| | | DataTable dt = new DataTable(); |
|---|
| | | List<string> fidList = new List<string>(); |
|---|
| | | if (FCusName == "瑞与祺") |
|---|
| | | string parameterSql = $"select HValue from Xt_SystemParameter where HKey ='Cg_POInStockBill_ErpAduit'"; |
|---|
| | | var HValue = oCn.RunProcReturn(parameterSql, "dt").Tables[0].Rows[0][0].ToString(); |
|---|
| | | if (HValue == "Y") |
|---|
| | | { |
|---|
| | | if (FCusName == "瑞与祺" || FCusName == "") |
|---|
| | | { |
|---|
| | | sql = string.Format(@" |
|---|
| | | SELECT T3.FNAME AS FTYPENAME,M.HBILLNO,B.HINTERID,B.HENTRYID,C.FID,C.FENTRYID, D.FBILLNO,B.HQTY,CD.FRECEIVEORGID,CDOO.FNUMBER AS FRECEIVENUMBER |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //更新主表状态 审核 |
|---|
| | | sql = string.Format(@"update Cg_POInStockBillMain set |
|---|
| | | HBillStatus = 2 , |
|---|
