protected void Page_Load(object sender, EventArgs e)
{
if (!CheckMasterGrant(YuYingPermission.业114广告_管理该栏目))
{
Utils.ResponseNoPermit(YuYingPermission.业114广告_管理该栏目, true);
return;
}
#region 异步删除数据
if (Request.QueryString["mode"] != null && Request.QueryString["mode"].ToString() == "del")
{
bool result = EyouSoft.BLL.AdvStructure.SiteExtend.CreateInstance().DelSiteExtend(Utils.GetInt(Request.QueryString["id"], 0));
Response.Clear();
if (result)
{
Response.Write("success");
}
else
{
Response.Write("error");
}
Response.End();
}
#endregion
#region 异步添加数据
if (Request.QueryString["mode"] != null && Request.QueryString["mode"].ToString() == "add")
{
string strHtml = "error";
Response.Clear();
int CityId = Utils.GetInt(Request.QueryString["cityid"], 0);
string companyId = Request.QueryString["cid"] == null?"":Request.QueryString["cid"].ToString();
if (CityId > 0 && !string.IsNullOrEmpty(companyId))
{
EyouSoft.Model.CompanyStructure.CompanyDetailInfo CompanyInfo = EyouSoft.BLL.CompanyStructure.CompanyInfo.CreateInstance().GetModel(companyId);
if (CompanyInfo != null)
{
EyouSoft.Model.AdvStructure.SiteExtendInfo model = new EyouSoft.Model.AdvStructure.SiteExtendInfo();
model.CompanyID = CompanyInfo.ID;
model.CompanyName = CompanyInfo.CompanyName;
model.IsBold = false;
model.IsShow = true;
model.ShowCityID = CityId;
model.SortID = 0;
EyouSoft.BLL.AdvStructure.SiteExtend.CreateInstance().AddSiteExtend(model);
model = null;
strHtml = JsonConvert.SerializeObject(EyouSoft.BLL.AdvStructure.SiteExtend.CreateInstance().GetSiteExtendList(CityId, true));
}
CompanyInfo = null;
}
Response.Write(strHtml);
Response.End();
}
#endregion
if (Request.QueryString["mode"] != null && (Request.QueryString["mode"].ToString().ToLower() == "getlist" ||
Request.QueryString["mode"].ToString().ToLower() == "getalllist"))
{
BindList();
}
}
/// <summary>
/// 描述：添加分站旅行社推广记录
/// </summary>
/// <param name="SiteExtendInfo"></param>
/// <returns></returns>
public bool AddSiteExtend(EyouSoft.Model.AdvStructure.SiteExtendInfo SiteExtendInfo)
{
if (SiteExtendInfo.ShowCityID != 0 && !string.IsNullOrEmpty(SiteExtendInfo.CompanyID))
{
if (!IsZixst(SiteExtendInfo.ShowCityID, SiteExtendInfo.CompanyID))
{
return(dal.AddSiteExtend(SiteExtendInfo));
}
}
return(false);
}
/// <summary>
/// 描述：添加分站旅行社推广记录
/// </summary>
/// <param name="SiteExtendInfo"></param>
/// <returns></returns>
public bool AddSiteExtend(EyouSoft.Model.AdvStructure.SiteExtendInfo SiteExtendInfo)
{
DbCommand dc = this.DB.GetSqlStringCommand(SQL_ADD_SiteExtend);
this.DB.AddInParameter(dc, "SortID", DbType.Int32, SiteExtendInfo.SortID);
this.DB.AddInParameter(dc, "CompanyID", DbType.AnsiStringFixedLength, SiteExtendInfo.CompanyID);
this.DB.AddInParameter(dc, "IsBold", DbType.AnsiStringFixedLength, SiteExtendInfo.IsBold ? "1" : "0");
this.DB.AddInParameter(dc, "Color", DbType.String, SiteExtendInfo.Color);
this.DB.AddInParameter(dc, "IsShow", DbType.AnsiStringFixedLength, SiteExtendInfo.IsShow ? "1" : "0");
this.DB.AddInParameter(dc, "ShowCity", DbType.String, SiteExtendInfo.ShowCity);
this.DB.AddInParameter(dc, "ShowCityID", DbType.Int32, SiteExtendInfo.ShowCityID);
this.DB.AddInParameter(dc, "ShowProID", DbType.Int32, SiteExtendInfo.ShowProID);
return(DbHelper.ExecuteSql(dc, DB) > 0 ? true : false);
}
/// <summary>
/// 描述：根据城市编号获得分站旅行社推广列表
/// </summary>
/// <param name="CityId">城市编号</param>
/// <param name="IsShow">显示状态,为NULL显示全部</param>
/// <returns></returns>
public IList <EyouSoft.Model.AdvStructure.SiteExtendInfo> GetSiteExtendList(int CityId, bool?IsShow)
{
DbCommand dc = this.DB.GetStoredProcCommand("proc_SiteExtendList");
if (IsShow.HasValue)
{
if (IsShow == true)
{
this.DB.AddInParameter(dc, "IsShow", DbType.AnsiStringFixedLength, "1");
}
else
{
this.DB.AddInParameter(dc, "IsShow", DbType.AnsiStringFixedLength, "0");
}
}
else
{
this.DB.AddInParameter(dc, "IsShow", DbType.AnsiStringFixedLength, null);
}
this.DB.AddInParameter(dc, "CityId", DbType.Int32, CityId);
IList <EyouSoft.Model.AdvStructure.SiteExtendInfo> items = new List <EyouSoft.Model.AdvStructure.SiteExtendInfo>();
EyouSoft.Model.AdvStructure.SiteExtendInfo item = null;
using (IDataReader rdr = DbHelper.ExecuteReader(dc, DB))
{
while (rdr.Read())
{
item = new EyouSoft.Model.AdvStructure.SiteExtendInfo()
{
ID = rdr.GetInt32(rdr.GetOrdinal("Id")),
SortID = rdr.GetInt32(rdr.GetOrdinal("SortID")),
CompanyID = rdr["CompanyID"].ToString(),
IsBold = rdr.IsDBNull(rdr.GetOrdinal("IsBold")) ? false : rdr.GetString(rdr.GetOrdinal("IsBold")) == "0" ? false : true,
Color = rdr["Color"].ToString(),
IsShow = rdr.IsDBNull(rdr.GetOrdinal("IsShow")) ? false : rdr.GetString(rdr.GetOrdinal("IsShow")) == "0" ? false : true,
ShowCity = rdr["CityName"].ToString(),
ShowCityID = rdr.IsDBNull(rdr.GetOrdinal("ShowCityID")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ShowCityID")),
ShowProID = rdr.IsDBNull(rdr.GetOrdinal("ShowProID")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ShowProID")),
CompanyName = rdr["CompanyName"].ToString(),
ProductNum = rdr.IsDBNull(rdr.GetOrdinal("ProductNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ProductNum")),
LoginCount = rdr.IsDBNull(rdr.GetOrdinal("LoginCount")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("LoginCount"))
};
items.Add(item);
}
}
return(items);
}
/// <summary>
/// 描述：获得分站旅行社推广列表
/// </summary>
/// <returns></returns>
public IList <EyouSoft.Model.AdvStructure.SiteExtendInfo> GetSiteExtendList(int pageSize, int pageIndex, ref int recordCount)
{
IList <EyouSoft.Model.AdvStructure.SiteExtendInfo> items = new List <EyouSoft.Model.AdvStructure.SiteExtendInfo>();
EyouSoft.Model.AdvStructure.SiteExtendInfo item = null;
StringBuilder cmdQuery = new StringBuilder();
string tableName = "tbl_FenSiteExtend";
string primaryKey = "Id";
string orderByString = "SortId ASC";
StringBuilder fields = new StringBuilder();
#region 要查询的字段
fields.Append(" *,(SELECT COUNT(*) FROM [tbl_TourList] WHERE CompanyID=tbl_FenSiteExtend.CompanyID) as ProductNum,(SELECT CompanyName FROM [tbl_CompanyInfo] WHERE ID=tbl_FenSiteExtend.CompanyID) as CompanyName,(SELECT CityName FROM [tbl_SysCity] WHERE Id=tbl_FenSiteExtend.ShowCityID) as CityName,(SELECT LoginCount FROM [tbl_CompanyInfo] WHERE Id=tbl_FenSiteExtend.CompanyID) as LoginCount ");
#endregion
#region 拼接查询条件
#endregion
using (IDataReader rdr = DbHelper.ExecuteReader(this.DB, pageSize, pageIndex, ref recordCount, tableName, primaryKey, fields.ToString(), cmdQuery.ToString(), orderByString))
{
while (rdr.Read())
{
item = new EyouSoft.Model.AdvStructure.SiteExtendInfo()
{
ID = rdr.GetInt32(rdr.GetOrdinal("Id")),
SortID = rdr.GetInt32(rdr.GetOrdinal("SortID")),
CompanyID = rdr["CompanyID"].ToString(),
IsBold = rdr.IsDBNull(rdr.GetOrdinal("IsBold")) ? false : rdr.GetString(rdr.GetOrdinal("IsBold")) == "0" ? false : true,
Color = rdr["Color"].ToString(),
IsShow = rdr.IsDBNull(rdr.GetOrdinal("IsShow")) ? false : rdr.GetString(rdr.GetOrdinal("IsShow")) == "0" ? false : true,
ShowCity = rdr["CityName"].ToString(),
ShowCityID = rdr.IsDBNull(rdr.GetOrdinal("ShowCityID")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ShowCityID")),
ShowProID = rdr.IsDBNull(rdr.GetOrdinal("ShowProID")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ShowProID")),
CompanyName = rdr["CompanyName"].ToString(),
ProductNum = rdr.IsDBNull(rdr.GetOrdinal("ProductNum")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("ProductNum")),
LoginCount = rdr.IsDBNull(rdr.GetOrdinal("LoginCount")) ? 0 : rdr.GetInt32(rdr.GetOrdinal("LoginCount"))
};
items.Add(item);
}
}
return(items);
}
protected void btnSave_Click(object sender, EventArgs e)
{
IList <EyouSoft.Model.AdvStructure.SiteExtendInfo> list = new List <EyouSoft.Model.AdvStructure.SiteExtendInfo>();
int CurrCityId = Utils.GetInt(hCurrCityId.Value, 362);
int CurrProvinceId = Utils.GetInt(hCurrProvinceId.Value, 33);
string CurrCityName = hCurrCityName.Value;
string[] Ids = Utils.GetFormValues("hKeyId");
string[] CompanyIds = Utils.GetFormValues("hCId");
string[] SotrNums = Utils.GetFormValues("txt_Sort");
string[] CompanyNames = Utils.GetFormValues("hCompanyName");
string[] Colors = Utils.GetFormValues("hColor");
string[] IsBolds = Utils.GetFormValues("hCk_Blod");
for (int i = 0; i < Ids.Length; i++)
{
EyouSoft.Model.AdvStructure.SiteExtendInfo model = new EyouSoft.Model.AdvStructure.SiteExtendInfo();
model.Color = Colors[i];
model.CompanyID = CompanyIds[i];
model.CompanyName = CompanyNames[i];
model.ID = int.Parse(Ids[i]);
model.IsBold = IsBolds[i] == "1" ? true : false;
model.IsShow = true;
model.ShowCity = CurrCityName;
model.ShowCityID = CurrCityId;
model.ShowProID = CurrProvinceId;
model.SortID = int.Parse(SotrNums[i]);
list.Add(model);
model = null;
}
if (list.Count > 0)
{
bool result = EyouSoft.BLL.AdvStructure.SiteExtend.CreateInstance().UpdateSiteExtend(list);
MessageBox.ShowAndRedirect(this, result?"保存成功！":"保存失败！", "/AdManagement/SanPinCenterNormalList.aspx");
}
}
/// <summary>
/// 描述：修改分站旅行社推广记录
/// </summary>
/// <param name="SiteExtendInfo"></param>
/// <returns></returns>
public bool UpdateSiteExtend(EyouSoft.Model.AdvStructure.SiteExtendInfo SiteExtendInfo)
{
return(dal.UpdateSiteExtend(SiteExtendInfo));
}
