Esempio n. 1
0
        /// <summary>
        /// 更新明细科目
        /// </summary>
        /// <param name="acc">明细科目对象</param>
        /// <returns></returns>
        public bool UpdDetailedAccount(T_DetailedAccount acc)
        {
            DBHelper dh = new DBHelper();

            dh.strCmd = "SP_UpdDetailsAccount";
            dh.AddPare("@ID", SqlDbType.NVarChar, 40, acc.DA_GUID);
            dh.AddPare("@CODE", SqlDbType.Int, 0, acc.AccCode);
            dh.AddPare("@NAME", SqlDbType.NVarChar, 100, acc.Name);
            dh.AddPare("@PID", SqlDbType.NVarChar, 40, acc.ParentAccGuid);
            dh.AddPare("@C_ID", SqlDbType.NVarChar, 40, acc.C_GUID);
            dh.AddPare("@D_ID", SqlDbType.NVarChar, 40, acc.D_GUID);
            try
            {
                dh.NonQuery();
                return(true);
            }
            catch
            {
                return(false);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 更新明细科目
        /// </summary>
        /// <param name="acc">明细科目对象</param>
        /// <returns></returns>
        public string UpdDetailedAccount(T_DetailedAccount acc, string flag, string cname)
        {
            if (flag == "1")
            {
                acc.D_GUID = acc.Name;
                acc.Name   = cname;
            }
            AccountSvc svc                = new AccountSvc();
            bool       result             = false;
            string     msg                = string.Empty;
            List <T_DetailedAccount> accs = svc.GetDetailsAccs(Session["CurrentCompany"].ToString());

            if (accs.Any(i => !i.DA_GUID.Equals(acc.DA_GUID) && i.AccCode.Equals(acc.AccCode)))
            {
                msg = FMS.Resource.Account.Account.AccExisted;
            }
            else
            {
                result = svc.UpdDetailedAccount(acc);
                msg    = result ? General.Resource.Common.Success : General.Resource.Common.Failed;
            }
            return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}"
                                 , result.ToString().ToLower(), msg));
        }