/// <summary> /// 更新往来单位 /// </summary> /// <param name="companyCussent">往来单位信息类</param> public void Update(CostCussentInfo companyCussent) { SqlParameter[] parms = GetCompanyCussentParameters(); parms[0].Value = companyCussent.CompanyId; parms[1].Value = companyCussent.CompanyClassId; parms[2].Value = companyCussent.CompanyName; parms[3].Value = companyCussent.Linkman; parms[4].Value = companyCussent.Address; parms[5].Value = companyCussent.PostalCode; parms[6].Value = companyCussent.Phone; parms[7].Value = companyCussent.Mobile; parms[8].Value = companyCussent.Fax; parms[9].Value = companyCussent.WebSite; parms[10].Value = companyCussent.Email; parms[11].Value = companyCussent.BankAccounts; parms[12].Value = companyCussent.AccountNumber; parms[13].Value = companyCussent.DateCreated; parms[14].Value = companyCussent.CompanyType; parms[15].Value = companyCussent.State; parms[16].Value = companyCussent.Description; parms[17].Value = companyCussent.SubjectInfo; parms[18].Value = companyCussent.InvoiceAccountsId; parms[19].Value = companyCussent.VoucherAccountsId; parms[20].Value = companyCussent.CashAccountsId; parms[21].Value = companyCussent.NoVoucherAccountsId; try { SqlHelper.ExecuteNonQuery(GlobalConfig.ERP_DB_NAME, false, SQL_UPDATE_COMPANYCUSSENT, parms); } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
/// <summary>根据费用分类ID获取具有相应权限的费用单位 ADD 2014-12-09 陈重文 /// </summary> /// <param name="filialeId">公司ID</param> /// <param name="branchId">部门ID</param> /// <param name="companyClassId">费用分类ID</param> /// <returns></returns> public IList <CostCussentInfo> GetPermissionCompanyCussentList(Guid filialeId, Guid branchId, Guid companyClassId) { const string SQL = @"SELECT CompanyId,CompanyClassId,CompanyName,Linkman, [Address],PostalCode,Phone,Mobile,Fax,WebSite,Email, BankAccounts,AccountNumber,DateCreated,CompanyType, [State],[Description],SubjectInfo,InvoiceAccountsId, VoucherAccountsId,CashAccountsId,NoVoucherAccountsId FROM CostCompany WHERE CompanyClassId=@CompanyClassId AND CompanyId IN ( SELECT CompanyId FROM CostPermission WHERE FilialeId=@FilialeId AND BranchId=@BranchId )"; var parms = new[] { new SqlParameter("@CompanyClassId", SqlDbType.UniqueIdentifier) { Value = companyClassId } , new SqlParameter("@FilialeId", SqlDbType.UniqueIdentifier) { Value = filialeId }, new SqlParameter("@BranchId", SqlDbType.UniqueIdentifier) { Value = branchId } }; IList <CostCussentInfo> companyCussentList = new List <CostCussentInfo>(); using (var rdr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL, parms)) { while (rdr.Read()) { var companyCussent = new CostCussentInfo(rdr.GetGuid(0), rdr.GetGuid(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetString(7), rdr.GetString(8), rdr.GetString(9), rdr.GetString(10), rdr.GetString(11), rdr.GetString(12), rdr.GetDateTime(13), rdr.GetInt32(14), rdr.GetInt32(15), rdr.GetString(16), rdr[17] == DBNull.Value ? "" : rdr.GetString(17), rdr[18] == DBNull.Value ? Guid.Empty : rdr.GetGuid(18), rdr[19] == DBNull.Value ? Guid.Empty : rdr.GetGuid(19), rdr[20] == DBNull.Value ? Guid.Empty : rdr.GetGuid(20), rdr[21] == DBNull.Value ? Guid.Empty : rdr.GetGuid(21)); companyCussentList.Add(companyCussent); } return(companyCussentList); } }
/// <summary> /// 获取往来单位信息列表 /// </summary> /// <returns></returns> public IList <CostCussentInfo> GetCompanyCussentList() { IList <CostCussentInfo> companyCussentList = new List <CostCussentInfo>(); using (var rdr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_SELECT_COMPANYCUSSENT_LIST, null)) { while (rdr.Read()) { var companyCussent = new CostCussentInfo(rdr.GetGuid(0), rdr.GetGuid(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetString(7), rdr.GetString(8), rdr.GetString(9), rdr.GetString(10), rdr.GetString(11), rdr.GetString(12), rdr.GetDateTime(13), rdr.GetInt32(14), rdr.GetInt32(15), rdr.GetString(16), rdr[17] == DBNull.Value ? "" : rdr.GetString(17), rdr[18] == DBNull.Value ? Guid.Empty : rdr.GetGuid(18), rdr[19] == DBNull.Value ? Guid.Empty : rdr.GetGuid(19), rdr[20] == DBNull.Value ? Guid.Empty : rdr.GetGuid(20), rdr[21] == DBNull.Value ? Guid.Empty : rdr.GetGuid(21)); companyCussentList.Add(companyCussent); } } return(companyCussentList); }
public string GetClass(object companyId) { if (new Guid(companyId.ToString()) == Guid.Empty) { return(string.Empty); } CostCussentInfo info = _costCussentDao.GetCompanyCussent(new Guid(companyId.ToString())); string className = info.CompanyId != Guid.Empty ? info.CompanyName : _costDao.GetCompanyClass(new Guid(companyId.ToString())).CompanyClassName; if (string.IsNullOrEmpty(className)) { className = string.Empty; } return(className); }
/// <summary> /// 获取指定分类号的往来单位列表 /// </summary> /// <param name="companyClassId">往来单位分类编号</param> /// <returns></returns> public IList <CostCussentInfo> GetCompanyCussentList(Guid companyClassId) { IList <CostCussentInfo> companyCussentList = new List <CostCussentInfo>(); var parm = new SqlParameter(PARM_COMPANYCLASSID, SqlDbType.UniqueIdentifier) { Value = companyClassId }; using (var rdr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_SELECT_COMPANYCUSSENT_BY_COMPANYCLASS_LIST_ALL, parm)) { while (rdr.Read()) { var companyCussent = new CostCussentInfo(rdr.GetGuid(0), rdr.GetGuid(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetString(7), rdr.GetString(8), rdr.GetString(9), rdr.GetString(10), rdr.GetString(11), rdr.GetString(12), rdr.GetDateTime(13), rdr.GetInt32(14), rdr.GetInt32(15), rdr.GetString(16), rdr[17] == DBNull.Value ? "" : rdr.GetString(17), rdr[18] == DBNull.Value ? Guid.Empty : rdr.GetGuid(18), rdr[19] == DBNull.Value ? Guid.Empty : rdr.GetGuid(19), rdr[20] == DBNull.Value ? Guid.Empty : rdr.GetGuid(20), rdr[21] == DBNull.Value ? Guid.Empty : rdr.GetGuid(21)); companyCussentList.Add(companyCussent); } } return(companyCussentList); }
/// <summary> /// 获取指定类型,指定状态的往来单位信息列表 /// </summary> /// <param name="companyType"></param> /// <param name="state"></param> /// <returns></returns> public IList <CostCussentInfo> GetCompanyCussentList(CompanyType companyType, State state) { IList <CostCussentInfo> companyCussentList = new List <CostCussentInfo>(); var parms = new[] { new SqlParameter(PARM_COMPANYTYPE, SqlDbType.Int), new SqlParameter(PARM_STATE, SqlDbType.Int) }; parms[0].Value = companyType; parms[1].Value = state; using (var rdr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_SELECT_COMPANYCUSSENT_BY_COMPANYTYPEANDSTATE_LIST, parms)) { while (rdr.Read()) { var companyCussent = new CostCussentInfo(rdr.GetGuid(0), rdr.GetGuid(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetString(7), rdr.GetString(8), rdr.GetString(9), rdr.GetString(10), rdr.GetString(11), rdr.GetString(12), rdr.GetDateTime(13), rdr.GetInt32(14), rdr.GetInt32(15), rdr.GetString(16), rdr[17] == DBNull.Value ? "" : rdr.GetString(17), rdr[18] == DBNull.Value ? Guid.Empty : rdr.GetGuid(18), rdr[19] == DBNull.Value ? Guid.Empty : rdr.GetGuid(19), rdr[20] == DBNull.Value ? Guid.Empty : rdr.GetGuid(20), rdr[21] == DBNull.Value ? Guid.Empty : rdr.GetGuid(21)); companyCussentList.Add(companyCussent); } } return(companyCussentList); }
/// <summary> /// 获取往来单位信息类 /// </summary> /// <param name="companyId">往来单位编号</param> /// <returns></returns> public CostCussentInfo GetCompanyCussent(Guid companyId) { CostCussentInfo companyCussent; var parm = new SqlParameter(PARM_COMPANYID, SqlDbType.UniqueIdentifier) { Value = companyId }; using (var rdr = SqlHelper.ExecuteReader(GlobalConfig.ERP_DB_NAME, true, SQL_SELECT_COMPANYCUSSENT, parm)) { if (rdr.Read()) { companyCussent = new CostCussentInfo(rdr.GetGuid(0), rdr.GetGuid(1), rdr.GetString(2), rdr.GetString(3), rdr.GetString(4), rdr.GetString(5), rdr.GetString(6), rdr.GetString(7), rdr.GetString(8), rdr.GetString(9), rdr.GetString(10), rdr.GetString(11), rdr.GetString(12), rdr.GetDateTime(13), rdr.GetInt32(14), rdr.GetInt32(15), rdr.GetString(16), rdr[17] == DBNull.Value ? "" : rdr.GetString(17), rdr[18] == DBNull.Value ? Guid.Empty : rdr.GetGuid(18), rdr[19] == DBNull.Value ? Guid.Empty : rdr.GetGuid(19), rdr[20] == DBNull.Value ? Guid.Empty : rdr.GetGuid(20), rdr[21] == DBNull.Value ? Guid.Empty : rdr.GetGuid(21)); } else { companyCussent = new CostCussentInfo(); } } return(companyCussent); }