Service 中的一些写法

1.Service 中调用存储过程

 context.UseTransaction(() =>
            {
                //使用存储过程
                DbParam[] pars = new DbParam[]
                {
                 DbParam.Create("@FlowID", curStep.FlowID),
                 DbParam.Create("@FlowName",curStep.FlowName),
                 DbParam.Create("@CurStepNo", curStep.FlowCheckStepNo),
                 DbParam.Create("@BackStepNo", backCurStep.FlowCheckStepNo),
                DbParam.Create("@LoginEmpID", Common.LoginEmp.EmpID),
                 DbParam.Create("@ReturnMsg",""),
               };
               
                pars[5].Size = 300;
                pars[5].DbType = DbType.String;
                pars[5].Direction = ParamDirection.Output;
                //虽然无返回值，但是要加ToList() 否则无法形成参数值返回
                context.SqlQuery<Object>("MultBackDeal", CommandType.StoredProcedure, pars).ToList();
               
                string msg = pars[7].Value.ToString();
                if (msg!="")
                    throw new ApplicationException(msg);
            });