/// <summary>
/// 绑定专家列表
/// </summary>
public void GetFCExpertList()
{
string Key = "FCExpert";
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
if (dt == null || dt.Rows.Count == 0)
{
dt = new DAL.Views.V_Experts().Open("top 10 UserName,UserID,LotteryName,LotteryID", "[ON]=1 and [isCanIssued]=1", "");
if (dt != null)
{
dt.Columns.Add("ID", typeof(int));
int i = 1;
foreach (DataRow dr in dt.Rows)
{
dr["ID"] = i;
i++;
}
Shove._Web.Cache.SetCache(Key, dt, 60);
}
}
dTFCExpert.DataSource = dt;
dTFCExpert.DataBind();
}
private void BindData()
{
string UseLotteriesList = DAL.Functions.F_GetExpertsLotteryList(_Site.ID, _User.ID);
if (UseLotteriesList == "")
{
PF.GoError(ErrorNumber.NoData, "没有您的相关数据或者您的申请还未处理", this.GetType().BaseType.FullName);
return;
}
DataTable dt = new DAL.Views.V_Experts().Open("ID,LotteryName", "UserID = " + _User.ID.ToString() + " and LotteryID in (" + UseLotteriesList + ")", "");
if ((dt == null) || (dt.Rows.Count == 0))
{
PF.GoError(ErrorNumber.NoData, "没有您的相关数据或者您的申请还未处理", this.GetType().BaseType.FullName);
return;
}
long ID = Shove._Convert.StrToLong(Shove._Web.Utility.GetRequest("ID"), -1);
Shove.ControlExt.FillDropDownList(ddlExperts, dt, "LotteryName", "ID");
if (ID > 0)
{
Shove.ControlExt.SetDownListBoxTextFromValue(ddlExperts, ID.ToString());
}
ddlExperts_SelectedIndexChanged(ddlExperts, new EventArgs());
}
public DataTable GetFCExpertListCache(int lID)
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("FCExpert" + lID);
if (dt == null || dt.Rows.Count == 0)
{
dt = new DAL.Views.V_Experts().Open("UserName,UserID,LotteryName,LotteryID", "[ON]=1 and [isCommend]=1 and LotteryID =" + lID, "");
if (dt != null)
{
dt.Columns.Add("ID", typeof(int));
int i = 1;
foreach (DataRow dr in dt.Rows)
{
dr["ID"] = i;
i++;
}
Shove._Web.Cache.SetCache("FCExpert" + lID, dt, 60);
}
}
return(dt);
}
private void BindData()
{
labName.Text = _User.Name;
labUserType.Text = ((_User.UserType == 1) ? "普通用户" : "高级用户");
labLevel.Text = _User.Level.ToString();
string UseLotteriesList = DAL.Functions.F_GetExpertsLotteryList(_Site.ID, _User.ID);
if (UseLotteriesList == "")
{
labExpertsList.Text = "<font color='red'>您还不是任何彩种的专家!</font>";
return;
}
DataTable dt = new DAL.Views.V_Experts().Open("ID,LotteryName,[DateTime],MaxPrice,BonusScale,Level", "UserID = " + _User.ID.ToString() + " and LotteryID in (" + UseLotteriesList + ")", "");
if ((dt == null) || (dt.Rows.Count == 0))
{
labExpertsList.Text = "<font color='red'>您还不是任何彩种的专家!</font>";
return;
}
g.DataSource = dt;
g.DataBind();
}
private void BindData()
{
if (ddlLottery.Items.Count < 1)
{
return;
}
DataTable dt = new DAL.Views.V_Experts().Open("", "SiteID = " + _Site.ID.ToString() + (ddlLottery.SelectedValue == "0" ? "" : " and LotteryID = " + Shove._Web.Utility.FilteSqlInfusion(ddlLottery.SelectedValue)), "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
PF.DataGridBindData(g, dt, gPager);
}
private void MoreThanExpertsMaxPrice(long ExpertsID)
{
DataTable dt = new DAL.Views.V_Experts().Open("MaxPrice", "ID = " + ExpertsID, "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
if (dt.Rows.Count == 0)
{
PF.GoError(ErrorNumber.NoData, "暂无数据", this.GetType().BaseType.FullName);
return;
}
double MaxPrice1 = Math.Round(double.Parse(dt.Rows[0][0].ToString()), 2);
labMaxPrice.Text = MaxPrice1.ToString();
}
private void ddlExpertsBindData()
{
string UseLotteriesList = DAL.Functions.F_GetExpertsLotteryList(_Site.ID, _User.ID);
if (UseLotteriesList == "")
{
PF.GoError(ErrorNumber.NoData, "没有您的相关数据或者您的申请还未处理", "Room_ExpertsCommendsList");
return;
}
DataTable dt = new DAL.Views.V_Experts().Open("ID,LotteryName", "UserID = " + _User.ID.ToString() + " and LotteryID in (" + UseLotteriesList + ")", "");
if ((dt == null) || (dt.Rows.Count == 0))
{
PF.GoError(ErrorNumber.NoData, "没有您的相关数据或者您的申请还未处理", "Room_ExpertsCommendsList");
return;
}
Shove.ControlExt.FillDropDownList(ddlExperts, dt, "LotteryName", "ID");
ddlExperts_SelectedIndexChanged(ddlExperts, new EventArgs());
}
public DataTable GetFCExpertListCache(int lID)
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("FCExpert" + lID);
if (dt == null || dt.Rows.Count == 0)
{
dt = new DAL.Views.V_Experts().Open("UserName,UserID,LotteryName,LotteryID", "[ON]=1 and [isCommend]=1 and LotteryID =" + lID, "");
if (dt != null)
{
dt.Columns.Add("ID", typeof(int));
int i = 1;
foreach (DataRow dr in dt.Rows)
{
dr["ID"] = i;
i++;
}
Shove._Web.Cache.SetCache("FCExpert" + lID, dt, 60);
}
}
return dt;
}
public DataTable GetFCExpertListCache(int lID)
{
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable("FCExpert" + lID);
if ((cacheAsDataTable == null) || (cacheAsDataTable.Rows.Count == 0))
{
cacheAsDataTable = new Views.V_Experts().Open("UserName,UserID,LotteryName,LotteryID", "[ON]=1 and [isCommend]=1 and LotteryID =" + lID, "");
if (cacheAsDataTable == null)
{
return cacheAsDataTable;
}
cacheAsDataTable.Columns.Add("ID", typeof(int));
int num = 1;
foreach (DataRow row in cacheAsDataTable.Rows)
{
row["ID"] = num;
num++;
}
Shove._Web.Cache.SetCache("FCExpert" + lID, cacheAsDataTable, 60);
}
return cacheAsDataTable;
}
private void BindData()
{
if (this.ddlLottery.Items.Count >= 1)
{
DataTable dt = new Views.V_Experts().Open("", "SiteID = " + base._Site.ID.ToString() + ((this.ddlLottery.SelectedValue == "0") ? "" : (" and LotteryID = " + Utility.FilteSqlInfusion(this.ddlLottery.SelectedValue))), "");
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName);
}
else
{
PF.DataGridBindData(this.g, dt, this.gPager);
}
}
}