/// <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);
}
