private void BindExpertsInfo()
{
DataTable dt = new DAL.Tables.T_ExpertsPredict().Open("", "ID=" + Shove._Web.Utility.FilteSqlInfusion(hidID.Value) + "", "");
if (dt == null || dt.Rows.Count == 0)
{
Shove._Web.JavaScript.Alert(this.Page, "记录不存在！");
return;
}
tbName.Text = dt.Rows[0]["Name"].ToString();
cbisShow.Checked = Shove._Convert.StrToBool(dt.Rows[0]["ON"].ToString(), true);
tbOldImage.Text = dt.Rows[0]["Url"].ToString().Trim();
Shove.ControlExt.SetDownListBoxText(ddlImage, dt.Rows[0]["Url"].ToString());
if (dt.Rows[0]["Url"].ToString().Trim() == "")
{
cbNoEditImage.Checked = false;
cbNoEditImage.Visible = false;
}
tbDescription.Text = dt.Rows[0]["Description"].ToString();
ddlLotteries.SelectedValue = dt.Rows[0]["LotteryID"].ToString();
}
private void BindExpertsPredict()
{
DataTable dtExpertsPredict = new DAL.Tables.T_ExpertsPredict().Open("", "", "[ID]");
if (dtExpertsPredict == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName + "(-40)");
return;
}
ddlExpertsPredictNews.DataSource = dtExpertsPredict;
ddlExpertsPredictNews.DataTextField = "Name";
ddlExpertsPredictNews.DataValueField = "ID";
ddlExpertsPredictNews.DataBind();
}
private void BindData()
{
hlAdd.NavigateUrl = "ExpertsPredictAdd.aspx";
DataTable dt = new DAL.Tables.T_ExpertsPredict().Open("", "LotteryID=" + ddlLotteries.SelectedValue, "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName + "(-62)");
return;
}
g.DataSource = dt;
g.DataBind();
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string Name = tbName.Text.Trim();
if (Name == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入专家姓名！");
return;
}
else
{
if (new DAL.Tables.T_Users().GetCount("Name='" + tbName.Text.Trim() + "'") == 0)
{
Shove._Web.JavaScript.Alert(this.Page, "用户名不存在！");
return;
}
}
string Image = "";
//if (tbImage.Value.Trim() != "")
//{
// string UploadPath = this.Server.MapPath("../Private/" + _Site.ID.ToString() + "/ExpertsImages");
// if (!System.IO.Directory.Exists(UploadPath))
// {
// System.IO.Directory.CreateDirectory(UploadPath);
// }
// if (Shove._IO.File.UploadFile(this.Page, tbImage, "../Private/" + _Site.ID.ToString() + "/ExpertsImages/", ref Image, true, "image") != 0)
// {
// Shove._Web.JavaScript.Alert(this.Page, "图片文件上传错误！");
// return;
// }
//}
if (ddlImage.SelectedIndex > 0)
{
Image = ddlImage.SelectedItem.Text;
}
string Description = tbDescription.Text.Trim();
if (Description == "")
{
Shove._Web.JavaScript.Alert(this.Page, "请输入专家描述！");
return;
}
DAL.Tables.T_ExpertsPredict t_ExpertsPredict = new DAL.Tables.T_ExpertsPredict();
t_ExpertsPredict.ON.Value = cbisShow.Checked;
t_ExpertsPredict.Name.Value = Name;
t_ExpertsPredict.LotteryID.Value = ddlLotteries.SelectedValue;
t_ExpertsPredict.URL.Value = Image;
t_ExpertsPredict.Description.Value = Description;
long Result = t_ExpertsPredict.Insert();
if (Result < 0)
{
Shove._Web.JavaScript.Alert(this, "添加失败");
return;
}
Shove._Web.Cache.ClearCache("Default_GetExpertsPredict");
Shove._Web.JavaScript.Alert(this, "添加成功", "ExpertsPredict.aspx");
}
