C# Common.UserModel类代码示例

        public ResultModel CheckContractSubBusinessInvoiceApplyConfirm(UserModel user, int subId)
        {
            ResultModel result = new ResultModel();

            string cmdText = "select COUNT(*) from dbo.Inv_BusinessInvoice bi inner join dbo.Invoice inv on inv.InvoiceId = bi.InvoiceId where bi.SubContractId = 1 and inv.InvoiceStatus in (@entryStatus,@readyStatus)";

            SqlParameter[] paras = new SqlParameter[3];
            paras[0] = new SqlParameter("@subId", subId);
            paras[1] = new SqlParameter("@entryStatus", (int)NFMT.Common.StatusEnum.已录入);
            paras[1] = new SqlParameter("@readyStatus", (int)NFMT.Common.StatusEnum.已生效);

            object obj = DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, cmdText, paras);
            int i = 0;
            if (obj == null || !int.TryParse(obj.ToString(), out i) || i <= 0)
            {
                result.ResultStatus = -1;
                result.Message = "检验业务发票失败";
                return result;
            }
            if (i > 0)
            {
                result.ResultStatus = -1;
                result.Message = "子合约中含有未完成的业务发票，不能进行确认完成操作。";
                return result;
            }

            result.ResultStatus = 0;
            result.Message = "业务发票全部完成";

            return result;
        }

        public ResultModel CheckContractSubCashInConfirm(UserModel user, int subId)
        {
            ResultModel result = new ResultModel();

            string cmdText = "select COUNT(*) from NFMT.dbo.Fun_CashInContract_Ref cic inner join NFMT.dbo.Fun_CashIn ci on cic.CashInId = ci.CashInId where cic.SubContractId [email protected] and ci.CashInStatus in (@entryStatus,@readyStatus)";

            SqlParameter[] paras = new SqlParameter[3];
            paras[0] = new SqlParameter("@subId", subId);
            paras[1] = new SqlParameter("@entryStatus", (int)NFMT.Common.StatusEnum.已录入);
            paras[1] = new SqlParameter("@readyStatus", (int)NFMT.Common.StatusEnum.已生效);

            object obj = DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, cmdText, paras);
            int i = 0;
            if (obj == null || !int.TryParse(obj.ToString(), out i) || i <= 0)
            {
                result.ResultStatus = -1;
                result.Message = "检验收款登记失败";
                return result;
            }
            if (i > 0)
            {
                result.ResultStatus = -1;
                result.Message = "子合约中含有未完成的收款登记，不能进行确认完成操作。";
                return result;
            }

            result.ResultStatus = 0;
            result.Message = "收款登记全部完成";

            return result;
        }

        public ResultModel Confirm(UserModel user, int cashInId)
        {
            ResultModel result = new ResultModel();

            try
            {
                using (System.Transactions.TransactionScope scope = new TransactionScope())
                {
                    //获取收款登记
                    result = this.cashinDAL.Get(user, cashInId);
                    if (result.ResultStatus != 0)
                        return result;

                    Model.CashIn cashIn = result.ReturnValue as Model.CashIn;
                    if (cashIn == null || cashIn.CashInId <= 0)
                    {
                        result.ResultStatus = -1;
                        result.Message = "收款登记不存在";
                        return result;
                    }

                    result = this.cashinDAL.Confirm(user, cashIn);

                    scope.Complete();
                }
            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }

            return result;
        }

        public ResultModel GetCanAllotBala(UserModel user, int cashInId, bool isUpdate, decimal alreadyAllotBala = 0)
        {
            ResultModel result = new ResultModel();

            try
            {
                System.Text.StringBuilder sb = new System.Text.StringBuilder();
                sb.Append(" select ci.CashInBala - ISNULL(ref.bala,0) ");
                if (isUpdate)
                    sb.AppendFormat(" + {0} ", alreadyAllotBala);
                sb.AppendFormat(" from dbo.Fun_CashIn ci left join (select ref.CashInId,SUM(ISNULL(ref.AllotBala,0)) bala  from dbo.Fun_CashInCorp_Ref ref where ref.DetailStatus >={0}  group by ref.CashInId) ref on ci.CashInId = ref.CashInId where ci.CashInId = {1}", (int)Common.StatusEnum.已生效,cashInId);

                object obj = NFMT.DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, sb.ToString(), null);
                decimal canAllotBala = 0;
                if (obj == null || string.IsNullOrEmpty(obj.ToString()) || !decimal.TryParse(obj.ToString(), out canAllotBala))
                {
                    result.ResultStatus = -1;
                    result.Message = "获取失败";
                }
                else
                {
                    result.ReturnValue = canAllotBala;
                    result.Message = "获取成功";
                    result.ResultStatus = 0;
                }
            }
            catch (Exception e)
            {
                result.Message = e.Message;
                result.ResultStatus = -1;
            }

            return result;
        }

        public ResultModel Confirm(UserModel user, int orderId)
        {
            ResultModel result = new ResultModel();

            try
            {
                using (System.Transactions.TransactionScope scope = new TransactionScope())
                {
                    result = this.documentorderDAL.Get(user, orderId);
                    if (result.ResultStatus != 0)
                        return result;

                    Model.DocumentOrder order = result.ReturnValue as Model.DocumentOrder;
                    if (order == null || order.OrderId <= 0)
                    {
                        result.Message = "制单指令不存在";
                        result.ResultStatus = -1;
                        return result;
                    }

                    result = this.documentorderDAL.Confirm(user, order);
                    if (result.ResultStatus != 0)
                        return result;

                    scope.Complete();
                }
            }
            catch (Exception ex)
            {
                result.Message = ex.Message;
                result.ResultStatus = -1;
            }

            return result;
        }

        /// <summary>
        /// 校验子合约中付款申请是否全部确认完成
        /// </summary>
        /// <param name="user"></param>
        /// <param name="subId"></param>
        /// <returns></returns>
        public ResultModel CheckContractSubPayApplyConfirm(UserModel user, int subId)
        {
            ResultModel result = new ResultModel();

            string cmdText = "select COUNT(*) from NFMT.dbo.Fun_ContractPayApply_Ref pac inner join NFMT.dbo.Fun_PayApply pa on pa.PayApplyId = pac.PayApplyId inner join NFMT.dbo.Apply app on pa.ApplyId = app.ApplyId where pac.ContractSubId [email protected] and app.ApplyStatus in (@entryStatus,@readyStatus)";

            SqlParameter[] paras = new SqlParameter[3];
            paras[0] = new SqlParameter("@subId", subId);
            paras[1] = new SqlParameter("@entryStatus", (int)NFMT.Common.StatusEnum.已录入);
            paras[1] = new SqlParameter("@readyStatus", (int)NFMT.Common.StatusEnum.已生效);

            object obj = DBUtility.SqlHelper.ExecuteScalar(this.ConnectString, CommandType.Text, cmdText, paras);
            int i = 0;
            if (obj == null || !int.TryParse(obj.ToString(), out i) || i <= 0)
            {
                result.ResultStatus = -1;
                result.Message = "检验付款申请失败";
                return result;
            }
            if (i > 0)
            {
                result.ResultStatus = -1;
                result.Message = "子合约中含有未完成的付款申请，不能进行确认完成操作。";
                return result;
            }

            result.ResultStatus = 0;
            result.Message = "付款申请全部完成";

            return result;
        }

        public ResultModel GetContractDetail(UserModel user, int contractId, TradeDirectionEnum tradeDirection)
        {
            ResultModel result = new ResultModel();

            try
            {
                System.Data.DataTable dt = NFMT.DBUtility.SqlHelper.ExecuteDataTable(this.ConnectString, GetSQLString(contractId, tradeDirection), null, System.Data.CommandType.Text);
                if (dt != null && dt.Rows.Count > 0)
                {
                    result.ResultStatus = 0;
                    result.Message = "获取成功";
                    result.ReturnValue = dt;
                }
                else
                {
                    result.ResultStatus = -1;
                    result.Message = "获取失败";
                }
            }
            catch (Exception e)
            {
                result.Message = e.Message;
                result.ResultStatus = -1;
            }

            return result;
        }

        /// <summary>
        /// 添加操作记录
        /// </summary>
        /// <param name="user">当前操作用户</param>
        /// <param name="log">记录实体</param>
        /// <param name="details">记录明细列表</param>
        /// <returns></returns>
        public static ResultModel InsertOperateLog(UserModel user, OperateLogModel log, List<OperateLogDetailModel> details)
        {
            ResultModel result = new ResultModel();

            using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope())
            {
                result = InsertOperateLog(user, log);
                if (result.ResultStatus != 0)
                    return result;

                foreach (OperateLogDetailModel m in details)
                {
                    result = InsertOperateLogDetail(user, m);
                    if (result.ResultStatus != 0)
                        return result;
                }

                scope.Complete();

                result.AffectCount = 1;
                result.Message = string.Format("操作记录添加成功，明细共{0}条", details.Count);
                result.ResultStatus = 0;
                result.ReturnValue = 1;
            }

            return result;
        }

 public override ResultModel AllowOperate(UserModel user, IModel obj, OperateEnum operate)
 {
     return new ResultModel()
     {
         ResultStatus = 0
     };
 }

        public ResultModel ChangePwd(UserModel user, string oldPwd, string newPwd)
        {
            ResultModel result = new ResultModel();

            try
            {
                using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
                {
                    result = accountDAL.ValidatePwd(user, oldPwd);
                    if (result.ResultStatus != 0)
                        return result;

                    result = accountDAL.ChangePwd(user, newPwd);
                    if (result.ResultStatus != 0)
                        return result;

                    scope.Complete();
                }
            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
            }
            finally
            {
                if (result.ResultStatus != 0)
                    this.Log.ErrorFormat("{0} {1}，序号:{2}", user.EmpName, result.Message, result.ReturnValue);
                else if (this.Log.IsInfoEnabled)
                    this.Log.InfoFormat("{0} {1}，序号:{2}", user.EmpName, result.Message, result.ReturnValue);
            }

            return result;
        }

        public ResultModel GetAttachIds(UserModel user, int stockInId)
        {
            ResultModel result = new ResultModel();

            try
            {
                string sql = string.Format("select AttachId from dbo.St_StockInAttach sia left join dbo.Attach a on sia.AttachId = a.AttachId where sia.StockInAttachId = {0} and a.AttachStatus = {1} ", stockInId, (int)Common.StatusEnum.已生效);
                DataTable dt = NFMT.DBUtility.SqlHelper.ExecuteDataTable(this.ConnectString, sql, null, CommandType.Text);
                string returnStr = string.Empty;
                if (dt != null && dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        returnStr += dr["AttachId"].ToString() + ",";
                    }
                    if (!string.IsNullOrEmpty(returnStr) && returnStr.IndexOf(",") > -1)
                        returnStr = returnStr.Substring(0, returnStr.Length - 1);

                    result.ResultStatus = 0;
                    result.Message = "获取成功";
                    result.ReturnValue = returnStr;
                }
                else
                {
                    result.ResultStatus = -1;
                    result.Message = "获取失败";
                }
            }
            catch (Exception e)
            {
                result.Message = e.Message;
                result.ResultStatus = -1;
            }
            return result;
        }

        public ResultModel ChangePwd(UserModel user, string newPwd)
        {
            ResultModel result = new ResultModel();

            try
            {
                string sql = string.Format("update dbo.Account set PassWord = '{0}' where EmpId = {1} and AccStatus = {2}", newPwd.Trim(), user.EmpId, (int)Common.StatusEnum.已生效);
                int i = NFMT.DBUtility.SqlHelper.ExecuteNonQuery(this.ConnectString, CommandType.Text, sql, null);
                if (i > 0)
                {
                    result.ResultStatus = 0;
                    result.Message = "修改密码成功";
                }
                else
                {
                    result.ResultStatus = -1;
                    result.Message = "修改密码失败";
                }
            }
            catch (Exception e)
            {
                result.Message = e.Message;
                result.ResultStatus = -1;
            }

            return result;
        }

        public ResultModel BaseAudit(UserModel user, Model.DataSource obj, bool isPass)
        {
            ResultModel result = new ResultModel();

            try
            {
                NFMT.Common.Operate operate = NFMT.Common.Operate.CreateOperate(obj.DalName, obj.AssName);

                if (operate == null)
                {
                    result.Message = "模板不存在";
                    result.ResultStatus = -1;
                    return result;
                }

                result = operate.Get(user, obj.BaseName, obj.TableCode, obj.RowId);

                if (result.ResultStatus == 0)
                {
                    NFMT.Common.IModel model = result.ReturnValue as NFMT.Common.IModel;

                    result = operate.Audit(user, model, isPass);
                }
            }
            catch (Exception ex)
            {
                result.ResultStatus = -1;
                result.Message = ex.Message;
                return result;
            }

            return result;
        }

        public ResultModel GetLastCapitalBySubId(UserModel user, int subId)
        {
            ResultModel result = new ResultModel();

            //获取当前子合约下所有大于已生效的资金流水
            NFMT.Funds.BLL.FundsLogBLL fundsLogBLL = new Funds.BLL.FundsLogBLL();
            result = fundsLogBLL.Load(user, subId);
            if (result.ResultStatus != 0)
                return result;

            List<NFMT.Funds.Model.FundsLog> fundsLogs = result.ReturnValue as List<NFMT.Funds.Model.FundsLog>;
            if (fundsLogs == null)
            {
                result.ResultStatus = -1;
                result.Message = "获取剩余资金失败";
                return result;
            }

            decimal lastCapital = fundsLogs.Sum(temp => temp.FundsBala);

            //子合约价格确认单
            result = this.LoadInterestListBySubId(user, subId,StatusEnum.已录入);
            if (result.ResultStatus != 0)
                return result;

            List<Model.Interest> interests = result.ReturnValue as List<Model.Interest>;

            decimal curCapital = interests.Sum(temp => temp.CurCapital);

            result.ResultStatus = 0;
            result.ReturnValue = lastCapital - curCapital;

            return result;
        }

        public ResultModel LoadByStockPayApplyId(UserModel user, int stockPayApplyId)
        {
            int readyStatus = (int)Common.StatusEnum.已生效;
            string cmdText = string.Format("select * from dbo.Fun_PaymentStockDetail where PayApplyDetailId={0} and DetailStatus>={1}", stockPayApplyId, readyStatus);

            return Load<Model.PaymentStockDetail>(user, CommandType.Text, cmdText);
        }