/// <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); } }