/// <summary>
/// 更新奖项设置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateAward(LuckyAward model)
{
string safesql = "";
safesql = " update Game_LuckyAward set ";
if (model.Award.ToString() != null && model.Award.ToString() != "")
{
safesql += "[Award]='" + model.Award + "',";
}
if (model.ActID.ToString() != null && model.ActID.ToString() != "")
{
safesql += "[ActID]='" + model.ActID + "',";
}
if (model.AwardContent != null && model.AwardContent != "")
{
safesql += "[AwardContent]='" + model.AwardContent + "',";
}
safesql += "[AwardNum]=" + (model.AwardNum != 0?model.AwardNum:1) + ",";
safesql += "[AwardPro]=" + (model.AwardPro != 0?model.AwardPro:1) + ",";
safesql += "[AwardSort]=" + (model.AwardSort != 0 ? model.AwardSort : 0) + ",";
safesql += "[IsDel]=" + (model.IsDel == 1 ? 1 : 0);
safesql += " where id='" + model.ID + "' ";
int rowsAffected = DbHelperSQL.ExecuteSql(safesql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加奖项设置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddAward(LuckyAward model)
{
string sql = @"INSERT INTO [Game_LuckyAward]
(ID,ActID,Award,AwardContent,AwardNum,AwardPro,AwardSort,AddTime,IsDel)
VALUES
(@ID,@ActID,@Award,@AwardContent,@AwardNum,@AwardPro,@AwardSort,@AddTime,@IsDel)";
System.Data.SqlClient.SqlParameter[] paras = new System.Data.SqlClient.SqlParameter[]
{
new System.Data.SqlClient.SqlParameter("@ID", model.ID),
new System.Data.SqlClient.SqlParameter("@ActID", model.ActID),
new System.Data.SqlClient.SqlParameter("@Award", model.Award),
new System.Data.SqlClient.SqlParameter("@AwardContent", model.AwardContent),
new System.Data.SqlClient.SqlParameter("@AwardNum", (model.AwardNum != 0?model.AwardNum:1)),
new System.Data.SqlClient.SqlParameter("@AwardPro", (model.AwardPro != 0?model.AwardPro:1)),
new System.Data.SqlClient.SqlParameter("@AwardSort", (model.AwardSort != 0?model.AwardSort:0)),
new System.Data.SqlClient.SqlParameter("@AddTime", DateTime.Now),
new System.Data.SqlClient.SqlParameter("@IsDel", (model.IsDel == 1?1:0))
};
int rowsAffected = DbHelperSQL.ExecuteSql(sql.ToString(), paras);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (null == Session["strSiteName"] || null == Session["strSiteCode"] || null == Session["strLoginName"])
{
Response.Write("<script language=JavaScript>;parent.location.href='../Index.aspx';</script>");
Response.End();
}
if (AwardName.Text.Trim() != null && AwardName.Text.Trim() != "")
{
LuckyAwardDAL dal = new LuckyAwardDAL();
string strSiteCode = Session["strSiteCode"].ToString();
if (dal.ExistAward(AwardName.Text, strSiteCode))
{
MessageBox.Show(this, "该奖项已经存在！");
}
else
{
LuckyAward model = new LuckyAward();
model.Award = AwardName.Text;
model.AwardContent = hd_content.Value;
model.ID = Guid.NewGuid().ToString("N").ToUpper();
if (AwardNum.Text.Trim() != null && AwardNum.Text.Trim() != "")
{
model.AwardNum = Convert.ToInt32(AwardNum.Text);
}
if (AwardPro.Text.Trim() != null && AwardPro.Text.Trim() != "")
{
model.AwardPro = Convert.ToInt32(AwardPro.Text);
}
if (ddlactlist.SelectedValue.Trim() != null && ddlactlist.SelectedValue.Trim() != "")
{
model.ActID = ddlactlist.SelectedValue;
}
model.AwardSort = Convert.ToInt32(awardsort.SelectedValue);
model.IsDel = 0;
if (dal.AddAward(model))
{
MessageBox.Show(this, "操作成功！");
}
else
{
MessageBox.Show(this, "操作失败！");
}
}
}
else
{
MessageBox.Show(this, "请输入相应标题名称！");
}
}
void ShowInfo(string strID)
{
LuckyAwardDAL dal = new LuckyAwardDAL();
DataSet ds = dal.GetAwardDetail(strID);
LuckyAward model = DataConvert.DataRowToModel <LuckyAward>(ds.Tables[0].Rows[0]);
AwardName.Text = model.Award;
hd_content.Value = model.AwardContent;
AwardNum.Text = model.AwardNum.ToString();
ddlactlist.SelectedIndex = ddlactlist.Items.IndexOf(ddlactlist.Items.FindByValue(model.ActID));
awardsort.SelectedIndex = awardsort.Items.IndexOf(awardsort.Items.FindByValue(model.AwardSort.ToString()));
AwardPro.Text = model.AwardPro.ToString();
if (strAction == "show")
{
this.btnReset.Visible = false;
this.btnSave.Visible = false;
}
}
/// <summary>
/// 获取奖项列表
/// </summary>
void GetAwardList()
{
if (strSiteCode.Trim() != null && strSiteCode.Trim() != "" &&
strActID.Trim() != null && strActID.Trim() != "")
{
string where = string.Empty;
where = " and SiteCode='" + strSiteCode + "' and a.ActID='" + strActID + "' ";
List <LuckyAward> modelList = new List <LuckyAward>();
//DataSet modellistds = AwardDal.GetAwardList(where);
DataSet modellistds = AwardDal.GetActAwardList(strActID, 0);
foreach (DataRow row in modellistds.Tables[0].Rows)
{
LuckyAward Awardmodel = DataConvert.DataRowToModel <LuckyAward>(row);
modelList.Add(Awardmodel);
}
int awardcount = modellistds.Tables[0].Rows.Count;
string awardpre = string.Empty;
//decimal awardpervalue =100/Convert.ToDecimal(awardcount);
//if (awardpervalue.ToString().Contains("."))
//{
// awardpre = awardpervalue.ToString().Substring(0, awardpervalue.ToString().IndexOf(".") + 3);
//}
//else
//{
// awardpre = awardpervalue.ToString();
//}
//读取模板内容
string text = string.Empty;
text = System.IO.File.ReadAllText(Server.MapPath("Themes/Game/award.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["title"] = "抽奖活动详细信息";
context.TempData["awardmodellist"] = modelList;
context.TempData["sitecode"] = strSiteCode;
context.TempData["openid"] = strOpenID;
context.TempData["awardcount"] = awardcount;
//context.TempData["awardper"] = awardpre+ "%";
context.TempData["footer"] = "奥琦微商易";
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
}
/// <summary>
/// 获取奖项列表
/// </summary>
void GetAwardList()
{
if (strSiteCode.Trim() != null && strSiteCode.Trim() != "" &&
strActID.Trim() != null && strActID.Trim() != "")
{
List <LuckyAward> modelList = new List <LuckyAward>();
DataSet modellistds = AwardDal.GetActAwardList(strActID, 0);
foreach (DataRow row in modellistds.Tables[0].Rows)
{
LuckyAward Awardmodel = DataConvert.DataRowToModel <LuckyAward>(row);
modelList.Add(Awardmodel);
}
int awardcount = modellistds.Tables[0].Rows.Count;
string awardtitle = string.Empty;
string script = string.Empty;
string peize = string.Empty;
string peizeid = string.Empty;
int peizenum = 0; int frontpeizenum = 0; int beforpeizenum = 0;
for (int i = 0; i < awardcount; i++)
{
try
{
peizenum = Convert.ToInt32(modellistds.Tables[0].Rows[i]["AwardPro"].ToString());
}
catch (Exception)
{
}
peize = modellistds.Tables[0].Rows[i]["Award"].ToString();
peizeid = modellistds.Tables[0].Rows[i]["ID"].ToString();
if (i == 0)
{
script += "\r\n if(randNum>=1&&randNum<=" + peizenum + ")" +
"\r\n {prize=\"" + peize + "\";zjl = true;peizeid=\"" + peizeid + "\";}";
}
else
{
peizenum = beforpeizenum + peizenum;
script += "\r\n if(randNum>=" + frontpeizenum + "&&randNum<=" + peizenum + ")" +
"\r\n {prize=\"" + peize + "\";zjl = true;peizeid=\"" + peizeid + "\";}";
}
frontpeizenum = peizenum + 1;
beforpeizenum = peizenum;
}
//读取模板内容
string text = string.Empty;
text = System.IO.File.ReadAllText(Server.MapPath("Themes/Game/scratchcard.html"));
JinianNet.JNTemplate.TemplateContext context = new JinianNet.JNTemplate.TemplateContext();
context.TempData["title"] = "刮刮卡活动详细信息";
context.TempData["awardmodellist"] = modelList;
context.TempData["sitecode"] = strSiteCode;
context.TempData["openid"] = strOpenID;
context.TempData["awardcount"] = awardcount;
context.TempData["actid"] = strActID;
context.TempData["script"] = script;
context.TempData["footer"] = "奥琦微商易";
JinianNet.JNTemplate.Template t = new JinianNet.JNTemplate.Template(context, text);
t.Render(Response.Output);
}
}
