/// <summary> /// 更新总账科目信息 /// </summary> /// <param name="acc">总账科目对象</param> /// <returns></returns> public string UpdLedgerAcc(T_GeneralLedgerAccount acc) { AccountSvc svc = new AccountSvc(); bool result = false; string msg = string.Empty; List <T_GeneralLedgerAccount> accs = svc.GetLedgerAccounts(Session["CurrentCompanyGuid"].ToString()); if (accs.Any(i => !i.LA_GUID.Equals(acc.LA_GUID) && i.AccCode.Equals(acc.AccCode))) { msg = FMS.Resource.Account.Account.AccExisted; } else { result = svc.UpdLedgerAcc(acc); msg = result ? General.Resource.Common.Success : General.Resource.Common.Failed; } return(string.Format("{{\"Result\":{0},\"Msg\":\"{1}\"}}" , result.ToString().ToLower(), msg)); }
/// <summary> /// 更新总账科目 /// </summary> /// <param name="acc">总账科目对象</param> /// <returns></returns> public bool UpdLedgerAcc(T_GeneralLedgerAccount acc) { DBHelper dh = new DBHelper(); dh.strCmd = "SP_UpdLedgerAccount"; dh.AddPare("@Name", SqlDbType.NVarChar, 100, acc.Name); dh.AddPare("@AccGroup", SqlDbType.Int, 0, acc.AccGroup); dh.AddPare("@id", SqlDbType.NVarChar, 40, acc.LA_GUID); dh.AddPare("@AccCode", SqlDbType.Int, 0, acc.AccCode); dh.AddPare("@Useable", SqlDbType.Bit, 0, acc.Useable); try { dh.NonQuery(); return(true); } catch { return(false); } }