Пример #1
0
        public List <IDictionary <string, object> > DealProcNewOrc(string procName, Model.EACmpCategory model, List <Dictionary <string, object> > list, IDbConnection conn, IDbTransaction trans)
        {
            var res = new List <IDictionary <string, object> >();

            if (string.IsNullOrEmpty(procName) || procName.Length < 2)
            {
                return(res);
            }
            var refid = "";

            if (list.Count > 0)
            {
                foreach (var item in list)
                {
                    refid += item["ID"].ToString() + ",";
                }
            }
            var user = UserService.GetUser();

            Dictionary <string, object> dict = new Dictionary <string, object>();

            dict.Add("UserID", user.Id);
            dict.Add("UserName", user.Name);
            dict.Add("YWID", model.ID);
            dict.Add("DATAID", refid);
            dict.Add("DWBH", model.DWBH);
            dict.Add("TMPTABLE", model.TmpTab);//增加 luchg 20190510

            WriteLogFile("存储" + procName + user.Id + "user.Name:" + user.Name + "ID:" + model.ID + "DWBH:" + model.DWBH + "TmpTab:" + model.TmpTab + " refid" + refid);


            res = ProcHelper.GetProcDataOracle(dict, procName, conn, trans);

            return(res);
            //Db.Execute($"exec {procName} @0,@1,@2 ", model.ID, refid, UserService.GetUserId());
        }