using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Text;
|
using CY.IDAL;
|
using System.Data.SqlClient;
|
using System.Data;
|
using CY.Model;
|
|
namespace CY.SQLDAL
|
{
|
public class EC_FirmInfoDAL : IEC_FirmInfoDAL
|
{
|
|
private Database _dataBase = null;
|
|
public EC_FirmInfoDAL()
|
{
|
_dataBase = new Database();
|
}
|
|
public EC_FirmInfoDAL(Database dataBase)
|
{
|
_dataBase = dataBase;
|
}
|
|
/// <summary>
|
/// 新增
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.EC_FirmInfo trueModel = model as Model.EC_FirmInfo;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter("@BusinessLicense",trueModel.BusinessLicense),
|
new SqlParameter("@LegalRepresentative",trueModel.LegalRepresentative),
|
new SqlParameter("@BusinessLicensePic",trueModel.BusinessLicensePic),
|
new SqlParameter("@OrganizationCodeCertificate",trueModel.OrganizationCodeCertificate),
|
new SqlParameter("@TaxRegistrationCertificate",trueModel.TaxRegistrationCertificate),
|
new SqlParameter("@Contacts",trueModel.Contacts),
|
new SqlParameter("@FileSize",trueModel.FileSize),
|
new SqlParameter("@ShorMessageNum",trueModel.ShorMessageNum),
|
new SqlParameter("@FirmType",trueModel.FirmType),
|
new SqlParameter("@MachineType",trueModel.MachineType),
|
new SqlParameter("@SupplyInfo",trueModel.SupplyInfo),
|
new SqlParameter("@FirmDescribe",trueModel.FirmDescribe),
|
new SqlParameter("@FileId",trueModel.FileId),
|
new SqlParameter("@MemberId",trueModel.MemberId),
|
new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
|
new SqlParameter("@Operator",trueModel.Operator),
|
new SqlParameter("@FirmStencilId",trueModel.FirmStencilId ?? 0) ,
|
new SqlParameter("@DomainName",trueModel.DomainName ?? "") ,
|
new SqlParameter("@Remark",trueModel.Remark) ,
|
new SqlParameter("@PrintLicenseImg",trueModel.PrintLicenseImg ?? "")
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_FirmInfo_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 修改
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.EC_FirmInfo trueModel = model as Model.EC_FirmInfo;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter("@Keyid",trueModel.Keyid),
|
new SqlParameter("@BusinessLicense",trueModel.BusinessLicense),
|
new SqlParameter("@LegalRepresentative",trueModel.LegalRepresentative),
|
new SqlParameter("@BusinessLicensePic",trueModel.BusinessLicensePic),
|
new SqlParameter("@OrganizationCodeCertificate",trueModel.OrganizationCodeCertificate),
|
new SqlParameter("@TaxRegistrationCertificate",trueModel.TaxRegistrationCertificate),
|
new SqlParameter("@Contacts",trueModel.Contacts),
|
new SqlParameter("@FileSize",trueModel.FileSize),
|
new SqlParameter("@ShorMessageNum",trueModel.ShorMessageNum),
|
new SqlParameter("@FirmType",trueModel.FirmType),
|
new SqlParameter("@MachineType",trueModel.MachineType),
|
new SqlParameter("@SupplyInfo",trueModel.SupplyInfo),
|
new SqlParameter("@FirmDescribe",trueModel.FirmDescribe),
|
new SqlParameter("@FileId",trueModel.FileId),
|
new SqlParameter("@MemberId",trueModel.MemberId),
|
new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
|
new SqlParameter("@Operator",trueModel.Operator),
|
new SqlParameter("@Remark",trueModel.Remark) ,
|
new SqlParameter("@FirmStencilId",trueModel.FirmStencilId ?? 0) ,
|
new SqlParameter("@DomainName",trueModel.DomainName ?? "") ,
|
new SqlParameter("@PrintLicenseImg",trueModel.PrintLicenseImg ?? "")
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_FirmInfo_Update", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 删除
|
/// </summary>
|
/// <param name="id"></param>
|
/// <returns></returns>
|
public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
|
{
|
Model.EC_FirmInfo trueModel = model as Model.EC_FirmInfo;
|
if (trueModel == null)
|
{
|
return false;
|
}
|
IList<SqlParameter> sqlParms = new List<SqlParameter>()
|
{
|
new SqlParameter("@Keyid",trueModel.Keyid)
|
};
|
try
|
{
|
_dataBase.Query("sp_EC_FirmInfo_DeleteRow", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
return true;
|
}
|
|
/// <summary>
|
/// 分页查询
|
/// </summary>
|
/// <param name="query"></param>
|
/// <param name="pagination"></param>
|
/// <returns></returns>
|
public IEnumerable<Model.EC_FirmInfo> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
|
{
|
throw new NotImplementedException();
|
}
|
|
/// <summary>
|
/// 分页查询
|
/// </summary>
|
/// <param name="pagination"></param>
|
/// <param name="Province"></param>
|
/// <param name="City"></param>
|
/// <param name="County"></param>
|
/// <param name="FirmDescribe"></param>
|
/// <param name="MachineType"></param>
|
/// <returns></returns>
|
public IEnumerable<Model.EC_FirmInfo> SelectModelPage(Infrastructure.Query.Pagination pagination, string Province, string City, string County, string FirmDescribe, string MachineType)
|
{
|
try
|
{
|
string condtion = " b.MemberType='印刷厂商' and b.UseState ='3' ";
|
if (!string.IsNullOrEmpty(Province))
|
condtion += " and b.Province ='" + Province + "'";
|
if (!string.IsNullOrEmpty(City))
|
condtion += " and b.City ='" + City + "'";
|
if (!string.IsNullOrEmpty(County))
|
condtion += " and b.County ='" + County + "'";
|
if (!string.IsNullOrEmpty(FirmDescribe))
|
condtion += " and a.FirmDescribe like '%" + FirmDescribe + "%'";
|
else if (!string.IsNullOrEmpty(MachineType))
|
condtion += " and a.MachineType like '%" + MachineType + "%'";
|
|
IList<EC_FirmInfo> result = _dataBase.SelectModelPage<Model.EC_FirmInfo>(pagination, " a.*,d.Stencil_Url,b.Name as CompanyName,b.Province as Province,b.City as City,c.QQ as QQ,b.bid as bid,b.bdomainname as bdomainname,b.bstenciid as bstenciid", " EC_FirmInfo a join EC_MemberBasic b on a.MemberId = b.MemberId join EC_MemberExtend c on a.MemberId = c.Keyid LEFT JOIN dbo.Sys_FirmStencil AS d ON a.FirmStencilId = d.Keyid ", " a.LastUpdateTime DESC", " LastUpdateTime DESC", condtion) as IList<EC_FirmInfo>;//执行查询
|
return null == result ? null : result;//返回结果
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
/// <summary>
|
/// 单个查询
|
/// </summary>
|
/// <param name="query"></param>
|
/// <returns></returns>
|
public IEnumerable<Model.EC_FirmInfo> SelectAllModel(Infrastructure.Query.Query query)
|
{
|
throw new NotImplementedException();
|
}
|
|
/// <summary>
|
/// 根据会员编号获得厂商信息
|
/// </summary>
|
/// <param name="MemberId">会员编号</param>
|
/// <returns></returns>
|
public EC_FirmInfo GetModelByMemberId(Guid MemberId)
|
{
|
if (MemberId == null)
|
return null;//错误数据返会空
|
|
IList<EC_FirmInfo> result = _dataBase.SelectModel<EC_FirmInfo>("*", "EC_FirmInfo", string.Format(" MemberId='{0}'", MemberId)) as IList<EC_FirmInfo>;//执行查询
|
|
return (null == result || result.Count == 0) ? null : result[0];//返回结果
|
}
|
|
/// <summary>
|
/// 检测域名是否重复
|
/// </summary>
|
/// <param name="DomainName"></param>
|
/// <param name="MemberId"></param>
|
/// <returns></returns>
|
public int IsExitsDomain(string DomainName, Guid MemberId)
|
{
|
try
|
{
|
IList<EC_MemberBasic> result = _dataBase.SelectModel<EC_MemberBasic>("*", "EC_MemberBasic", " bdomainname = '" + DomainName + "'") as IList<EC_MemberBasic>;//执行查询
|
if (null == result || result.Count == 0)
|
{
|
return 0;
|
}
|
else
|
{
|
if (result[0].MemberId == MemberId)
|
return 0;
|
else
|
return 1;
|
}
|
}
|
catch (Exception ex)
|
{
|
throw ex;
|
}
|
}
|
|
|
/// <summary>
|
/// 根据会员的域名获取代表值，如果没找到返回-1
|
/// </summary>
|
/// <param name="domainName"></param>
|
/// <returns></returns>
|
public int GetBid(string domainName)
|
{
|
int bid = -1;
|
IList<EC_MemberBasic> result = _dataBase.SelectModel<EC_MemberBasic>("*", "EC_MemberBasic", " bdomainname = '" + domainName + "'") as IList<EC_MemberBasic>;
|
if (result != null && result.Count > 0)
|
{
|
if (result[0].bid.HasValue)
|
bid = result[0].bid.Value;
|
}
|
return bid;
|
}
|
}
|
}
|
