1

llj

1 天以前 0dcb91179f6370e1a5358598f15b48b586c3426c

1

 WebAPI/Controllers/ÎïÁ÷¹ÜÀí/Ô˵¥·ÑÓýáËãµ¥/Pay_WayBillPaymentBillController.cs

@@ -97,7 +97,12 @@
            string msg3 = sArray[1].ToString(); //子表
            string refSav = sArray[2].ToString();//操作方式数据类型 1添加 3修改 2 å¤åˆ¶
            string msg4 = sArray[3].ToString();//用户名
            string msg5 = sArray[4].ToString();
            if (msg5 != null || msg5 != "")
            {

                msg5 = msg5.Substring(1);
            }
            DBUtility.ClsPub.CurUserName = msg4;

            string UserName = "";
@@ -227,6 +232,10 @@
                {

                    bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo);
                    if (msg5 != "")
                    {
                        oCN.RunProc("update WL_YayBillMain set HDate_Accounting=getdate() , HSurer_Accounting='" + msg4 +"'" +" where HInterID in (" + msg5 + ")");
                    }
                }
                else if (refSav == "Update")
                {
@@ -948,6 +957,28 @@
        }
        #endregion


        #region èŽ·å–运单源单数据
        [Route("Pay_WayBillPaymentBillController/getOrginBill")]
        [HttpGet]
        public object getOrginBill(int HInterID,int HEntryID)
        {
            string sql1 = "select * from  h_v_WL_YayBillEdit  where HInterID= "+ HInterID+ " and HEntryID="+ HEntryID;
            //string sql = sql1 + sWhere + " order by å•æ®å· desc";
            ds = oCN.RunProcReturn(sql1, "h_v_WL_YayBill");
            if(ds!=null||ds.Tables.Count>0)
            {
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            objJsonResult.code = "0";
            objJsonResult.count = 0;
            objJsonResult.Message = "没有返回任何记录！";
            objJsonResult.data = null;
            return objJsonResult;
        }
        #endregion
    }
}