protected void Page_Load(object sender, EventArgs e)
{
cityBll = EyouSoft.BLL.SystemStructure.SysCity.CreateInstance();
provinceBll = EyouSoft.BLL.SystemStructure.SysProvince.CreateInstance();
//获取当前页
pageIndex = Utils.GetInt(Request.QueryString["Page"], 1);
//获取查询条件
int province = Utils.GetInt(Utils.GetQueryStringValue("province"));
int city = Utils.GetInt(Utils.GetQueryStringValue("city"));
string companyName = Utils.InputText(Server.UrlDecode(Request.QueryString["companyname"] ?? "")).Trim();
string admin = Utils.InputText(Server.UrlDecode(Request.QueryString["admin"] ?? "")).Trim();
string myCompanyId = SiteUserInfo.CompanyID;
EyouSoft.Model.CompanyStructure.QueryParamsCompany query = new EyouSoft.Model.CompanyStructure.QueryParamsCompany();
query.CityId = city;
query.PorvinceId = province;
query.CompanyName = companyName;
query.ContactName = admin;
//绑定我的客户
IList <EyouSoft.Model.CompanyStructure.MyCustomer> myCustomerList = EyouSoft.BLL.CompanyStructure.MyCustomer.CreateInstance().GetList(myCompanyId, query, pageSize, pageIndex, ref recordCount);
if (myCustomerList != null && myCustomerList.Count > 0)
{
asc_rptCustomerList.DataSource = myCustomerList;
asc_rptCustomerList.DataBind();
BindPage();
}
else
{
asc_rptCustomerList.EmptyText = "暂无客户信息";
this.ExportPageInfo1.Visible = false;
}
}
/// <summary>
/// 获取我的客户列表
/// </summary>
/// <param name="currentCompanyId">当前登录人公司ID</param>
/// <param name="query">查询条件实体</param>
/// <param name="pageSize">分页大小</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总的记录数</param>
/// <returns></returns>
public IList <EyouSoft.Model.CompanyStructure.MyCustomer> GetList(string currentCompanyId, EyouSoft.Model.CompanyStructure.QueryParamsCompany query, int pageSize, int pageIndex, ref int recordCount)
{
return(idal.GetList(currentCompanyId, query, pageSize, pageIndex, ref recordCount));
}
private void InitLocalAgencyList()
{
int intRecordCount = 0;
string CompanyName = Server.UrlDecode(Utils.GetQueryStringValue("CompanyName"));
string ContactName = Server.UrlDecode(Utils.GetQueryStringValue("ContactName"));
CurrencyPage = Utils.GetInt(Utils.InputText(Request.QueryString["Page"]), 1);
EyouSoft.IBLL.CompanyStructure.ICompanyInfo bll = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance();
EyouSoft.Model.CompanyStructure.QueryParamsCompany query = new EyouSoft.Model.CompanyStructure.QueryParamsCompany();
query.CityId = RequestCityID;
query.CompanyName = CompanyName;
query.ContactName = ContactName;
query.PorvinceId = ProvinceID;
IList <EyouSoft.Model.CompanyStructure.CompanyInfo> list = bll.GetListLocalAgency(query, intPageSize, CurrencyPage, ref intRecordCount);
if (intRecordCount > 0)
{
string[] CompanyIDList = new string[list.Count];
CompanyIDList = (from c in list where true select c.ID).ToArray();
AttachList = EyouSoft.BLL.CompanyStructure.CompanyAttachInfo.CreateInstance().GetList(CompanyIDList);
this.rptLocalAgencyList.DataSource = list;
this.rptLocalAgencyList.DataBind();
if (EyouSoft.Common.URLREWRITE.UrlReWriteUtils.IsReWriteUrl(Request))
{
this.ExporPageInfoSelect1.Placeholder = "#PageIndex#";
this.ExporPageInfoSelect1.IsUrlRewrite = true;
string strTemp = EyouSoft.Common.URLREWRITE.UrlReWriteUtils.GetUrlForPage(Request);
if (strTemp.Split('_').Count() == 3)
{
this.ExporPageInfoSelect1.PageLinkURL = strTemp.Split('_')[0] + "_" + strTemp.Split('_')[1] + "_0" + "_" + CityId + "_#PageIndex#";
}
else
{
this.ExporPageInfoSelect1.PageLinkURL = strTemp + "_#PageIndex#";
}
//this.ExporPageInfoSelect1.PageLinkURL = EyouSoft.Common.URLREWRITE.UrlReWriteUtils.GetUrlForPage(Request) + "_#PageIndex#";
}
else
{
this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"].ToString() + "?";
this.ExporPageInfoSelect1.UrlParams = Request.QueryString;
}
this.ExporPageInfoSelect1.intPageSize = intPageSize;
this.ExporPageInfoSelect1.CurrencyPage = CurrencyPage;
this.ExporPageInfoSelect1.intRecordCount = intRecordCount;
//this.ExporPageInfoSelect1.PageLinkURL = Request.ServerVariables["SCRIPT_NAME"] + "?CityID=" + CityId + "&";
//this.ExporPageInfoSelect1.UrlParams = Request.QueryString;
}
else
{
this.ExporPageInfoSelect1.Visible = false;
this.pnlNoData.Visible = true;
}
this.txtCompanyName.Value = CompanyName;
this.txtContactName.Value = ContactName;
list = null;
bll = null;
}
/// <summary>
/// 获取我的客户列表
/// </summary>
/// <param name="currentCompanyId">当前登录人公司ID</param>
/// <param name="query">查询条件实体</param>
/// <param name="pageSize">分页大小</param>
/// <param name="pageIndex">当前页</param>
/// <param name="recordCount">总的记录数</param>
/// <returns></returns>
public virtual IList <EyouSoft.Model.CompanyStructure.MyCustomer> GetList(string currentCompanyId, EyouSoft.Model.CompanyStructure.QueryParamsCompany query, int pageSize, int pageIndex, ref int recordCount)
{
IList <EyouSoft.Model.CompanyStructure.MyCustomer> list = new List <EyouSoft.Model.CompanyStructure.MyCustomer>();
string tableName = "view_CompanyCustomerList";
string fields = "*";
string primaryKey = "ID";
string orderByString = "IssueTime DESC";
#region 查询条件
StringBuilder strWhere = new StringBuilder();
//设置查询条件
strWhere.AppendFormat(" CompanyID='{0}' ", currentCompanyId);
if (query != null)
{
if (query.PorvinceId > 0) //按省份查询
{
strWhere.AppendFormat(" AND ProvinceId={0} ", query.PorvinceId);
}
if (query.CityId > 0) //按城市查询
{
strWhere.AppendFormat(" AND CityId={0} ", query.CityId);
}
if (!string.IsNullOrEmpty(query.CompanyName))
{
strWhere.AppendFormat(" AND CompanyName LIKE '%{0}%' ", query.CompanyName);
}
if (!string.IsNullOrEmpty(query.ContactName))
{
strWhere.AppendFormat(" AND ContactName LIKE '%{0}%' ", query.ContactName);
}
if (!string.IsNullOrEmpty(query.CompanyBrand))
{
strWhere.AppendFormat(" AND CompanyBrand LIKE '%{0}%' ", query.CompanyBrand);
}
}
#endregion 查询条件
using (IDataReader dr = DbHelper.ExecuteReader(this._database, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields, strWhere.ToString(), orderByString))
{
while (dr.Read())
{
EyouSoft.Model.CompanyStructure.MyCustomer model = new EyouSoft.Model.CompanyStructure.MyCustomer();
#region 初始化model
//tbl_CompanyCustomerList表中的字段
model.ID = dr.IsDBNull(dr.GetOrdinal("ID")) == true ? "" : dr.GetString(dr.GetOrdinal("ID"));
model.CurrentCompanyID = dr.IsDBNull(dr.GetOrdinal("CompanyID")) == true ? "" : dr.GetString(dr.GetOrdinal("CompanyID"));
model.CurrentOperatorID = dr.IsDBNull(dr.GetOrdinal("OperatorID")) == true ? "" : dr.GetString(dr.GetOrdinal("OperatorID"));
model.CustomerCompanyID = dr.IsDBNull(dr.GetOrdinal("CustomerCompanyID")) == true ? "" : dr.GetString(dr.GetOrdinal("CustomerCompanyID"));
model.CityId = dr.GetInt32(dr.GetOrdinal("CityId"));
model.CompanyBrand = dr.IsDBNull(dr.GetOrdinal("CompanyBrand")) == true ? "" : dr.GetString(dr.GetOrdinal("CompanyBrand"));
model.CompanyName = dr.IsDBNull(dr.GetOrdinal("CompanyName")) == true ? "" : dr.GetString(dr.GetOrdinal("CompanyName"));
//设置公司所有的身份//未实现//(未取该字段)
//string CompanyRoleListXml = dr.IsDBNull(dr.GetOrdinal("CompanyRoleList")) == true ? "" : dr.GetString(dr.GetOrdinal("CompanyRoleList"));
//if (!String.IsNullOrEmpty(CompanyRoleListXml))
//{
// System.Xml.XmlDocument xmlDoc = new System.Xml.XmlDocument();
// xmlDoc.LoadXml(CompanyRoleListXml);
// System.Xml.XmlNodeList NodeList = xmlDoc.GetElementsByTagName("TypeId");
// for (int i = 0; i < NodeList.Count; i++)
// {
// model.CompanyRole.SetRole((EyouSoft.Model.CompanyStructure.CompanyType)int.Parse(NodeList[i].Attributes[0].Value));
// }
//}
model.ContactInfo.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactName"));
model.ContactInfo.Email = dr.IsDBNull(dr.GetOrdinal("ContactEmail")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactEmail"));
model.ContactInfo.Fax = dr.IsDBNull(dr.GetOrdinal("ContactFax")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactFax"));
model.ContactInfo.Mobile = dr.IsDBNull(dr.GetOrdinal("ContactMobile")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactMobile"));
model.ContactInfo.MQ = dr.IsDBNull(dr.GetOrdinal("ContactMQ")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactMQ"));
model.ContactInfo.MSN = dr.IsDBNull(dr.GetOrdinal("ContactMSN")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactMSN"));
model.ContactInfo.QQ = dr.IsDBNull(dr.GetOrdinal("ContactQQ")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactQQ"));
model.ContactInfo.Tel = dr.IsDBNull(dr.GetOrdinal("ContactTel")) == true ? "" : dr.GetString(dr.GetOrdinal("ContactTel"));
model.License = dr.IsDBNull(dr.GetOrdinal("License")) == true ? "" : dr.GetString(dr.GetOrdinal("License"));
model.ProvinceId = dr.GetInt32(dr.GetOrdinal("ProvinceId"));
model.OpCompanyId = dr.IsDBNull(dr.GetOrdinal("OpCompanyId"))
? 0
: dr.GetInt32(dr.GetOrdinal("OpCompanyId"));
#endregion 初始化model
list.Add(model);
model = null;
}
}
return(list);
}
