/// <summary>
/// 第一次请求页面时绑定数据（主要是绑定本人名片和剩下的9个MQ名片）
/// </summary>
private void FirstBind()
{
if (listUserCard != null)
{
if (listUserCard.Count > 0)
{
SelfModel = listUserCard[0];
if (SelfModel != null)
{
this.companyId_hidden.Value = SelfModel.CompanyId;
listUserCard.RemoveAt(0);//请求第一页时删除出了本人以外的数据
Repeater1.DataSource = listUserCard;
Repeater1.DataBind();
BindPage();
}
else
{
this.ExportPageInfo1.Visible = false;
this.place_holder.Visible = false;
}
}
else
{
this.ExportPageInfo1.Visible = false;
this.place_holder.Visible = false;
}
}
else
{
this.ExportPageInfo1.Visible = false;
this.place_holder.Visible = false;
}
}
/// <summary>
/// 根据同业中心ID获取该中心登录者除外的会员名片信息列表
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="recordCount">总记录数</param>
/// <param name="clusterId">同业中心ID</param>
/// <param name="mq">登录者MQ</param>
/// <returns>会员名片实体列表</returns>
public IList <Model.MQStructure.IMClusterUserCard> GetUserCardListByClusterId(int pageSize, int pageIndex, ref int recordCount, int clusterId, int mq)
{
var lst = new List <EyouSoft.Model.MQStructure.IMClusterUserCard>(); // 会员名片实体列表
var mdl = this.GetUserCardInfoByMq(clusterId, mq); // 会员名片实体
DbCommand cmd = this._database.GetStoredProcCommand(mdl == null ? "T_StocPage" : "T_StocPageFor_IMUserCard");
// 首页
if (pageIndex == 1 && mdl != null)
{
pageSize = pageSize - 1;
}
this._database.AddInParameter(cmd, "PageSize", DbType.Int32, pageSize);
this._database.AddInParameter(cmd, "PageIndex", DbType.Int32, pageIndex);
this._database.AddInParameter(cmd, "TableName", DbType.String, "view_ClusterUserCardInfo_All");
this._database.AddInParameter(cmd, "FieldsList", DbType.String, "UserName,CompanyID,CompanyName,Subject,Contact,MQ,CompanyLogo,EshopUrl");
this._database.AddInParameter(cmd, "FieldSearchKey", DbType.String, string.Format("ClusterID = {0} AND MQ <> {1}", clusterId, mq));
this._database.AddInParameter(cmd, "OrderString", DbType.String, "Frequency DESC");
this._database.AddInParameter(cmd, "IsGroupBy", DbType.String, "0");
IDataReader dr = DbHelper.RunReaderProcedure(cmd, this._database);
if (dr.Read())
{
recordCount = dr.GetInt32(0);
}
dr.NextResult();
using (dr)
{
while (dr.Read())
{
// 公告信息实体
var model = new EyouSoft.Model.MQStructure.IMClusterUserCard
{
// 用户姓名（性别）
UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("UserName")),
// 公司ID
CompanyId = dr.GetString(dr.GetOrdinal("CompanyID")),
// 公司名称
CompanyName = dr.IsDBNull(dr.GetOrdinal("CompanyName")) ? string.Empty : dr.GetString(dr.GetOrdinal("CompanyName")),
// 主营业务
Subject = dr.IsDBNull(dr.GetOrdinal("Subject")) ? string.Empty : dr.GetString(dr.GetOrdinal("Subject")),
// 联系方式
Contact = dr.IsDBNull(dr.GetOrdinal("Contact")) ? string.Empty : dr.GetString(dr.GetOrdinal("Contact")),
// 同业MQ号
MQ = dr.IsDBNull(dr.GetOrdinal("MQ")) ? 0 : dr.GetInt32(dr.GetOrdinal("MQ")),
// 公司LOGO地址
CompanyLogo = dr.IsDBNull(dr.GetOrdinal("CompanyLogo")) ? string.Empty : dr.GetString(dr.GetOrdinal("CompanyLogo")),
// 公司网店地址
EshopUrl = dr.IsDBNull(dr.GetOrdinal("EshopUrl")) ? string.Empty : dr.GetString(dr.GetOrdinal("EshopUrl")),
};
// 追加到会员名片实体列表
lst.Add(model);
}
}
if (pageIndex == 1 && mdl != null)
{
lst.Insert(0, mdl);
}
// 返回会员名片实体列表
return(lst);
}
/// <summary>
/// 根据同业MQ号获取同业中心会员名片信息
/// </summary>
/// <param name="clusterId">同业中心ID</param>
/// <param name="mq">MQ帐号</param>
/// <returns>会员名片信息实体</returns>
public Model.MQStructure.IMClusterUserCard GetUserCardInfoByMq(int clusterId, int mq)
{
EyouSoft.Model.MQStructure.IMClusterUserCard model = null; // 会员名片实体
var strSql = new StringBuilder(); // SQL编辑器
strSql.Append(" SELECT TOP(1)");
strSql.Append(" UserName"); // 用户姓名（性别）
strSql.Append(" ,CompanyID"); // 公司ID
strSql.Append(" ,CompanyName"); // 公司名称
strSql.Append(" ,Subject"); // 主营业务
strSql.Append(" ,Contact"); // 联系方式
strSql.Append(" ,MQ"); // MQ
strSql.Append(" ,CompanyLogo"); // 公司LOGO地址
strSql.Append(" ,EshopUrl"); // 公司网店地址
strSql.Append(" FROM");
strSql.Append(" view_ClusterUserCardInfo_All");
strSql.Append(" WHERE");
strSql.Append(" ClusterID = @ClusterID");
strSql.Append(" AND MQ = @MQ");
DbCommand cmd = this._database.GetSqlStringCommand(strSql.ToString()); // SQL执行
this._database.AddInParameter(cmd, "@ClusterID", DbType.Int32, clusterId); // 同业中心ID
this._database.AddInParameter(cmd, "@MQ", DbType.Int32, mq); // 同业MQ号
using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._database))
{
while (dr.Read())
{
model = new EyouSoft.Model.MQStructure.IMClusterUserCard
{
// 用户姓名（性别）
UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? string.Empty : dr.GetString(dr.GetOrdinal("UserName")),
// 公司ID
CompanyId = dr.GetString(dr.GetOrdinal("CompanyID")),
// 公司名称
CompanyName = dr.IsDBNull(dr.GetOrdinal("CompanyName")) ? string.Empty : dr.GetString(dr.GetOrdinal("CompanyName")),
// 主营业务
Subject = dr.IsDBNull(dr.GetOrdinal("Subject")) ? string.Empty : dr.GetString(dr.GetOrdinal("Subject")),
// 联系方式
Contact = dr.IsDBNull(dr.GetOrdinal("Contact")) ? string.Empty : dr.GetString(dr.GetOrdinal("Contact")),
// 同业MQ号
MQ = dr.IsDBNull(dr.GetOrdinal("MQ")) ? 0 : dr.GetInt32(dr.GetOrdinal("MQ")),
// 公司LOGO地址
CompanyLogo = dr.IsDBNull(dr.GetOrdinal("CompanyLogo")) ? string.Empty : dr.GetString(dr.GetOrdinal("CompanyLogo")),
// 公司网店地址
EshopUrl = dr.IsDBNull(dr.GetOrdinal("EshopUrl")) ? string.Empty : dr.GetString(dr.GetOrdinal("EshopUrl")),
};
}
}
// 返回会员名片实体
return(model);
}
