protected void btnUpdateHuoDong_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request["upid"])) { if (EnshineUnionManager.model.SearchDataClass.IsNumber(Request["upid"]) == true) { using (EnshineUnionDataContext db = new EnshineUnionDataContext()) { HuoDong upNot = db.HuoDong.Single(x => x.huodongId == int.Parse(Request["upid"])); upNot.huodongTitle = txtTitle.Value.Trim(); upNot.huodongPeople = txtPeople.Value; upNot.huodongKeyWord = txtKeyWord.Value; upNot.huodongDate = txtTimeSelect.Value; upNot.huodongContent = txtFckContent.Value.Trim(); upNot.huodongImg = HFurl.Value.Trim(); upNot.huodongsort = int.Parse(drpHuoDongSort.SelectedValue); //upNot.addTime = DateTime.Now; upNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue); db.SubmitChanges(); } } Response.Redirect("HuoDongManager.aspx?mid=" + Request["mid"]); } }
public void BindShowUpInfo(string strUpid) { if (!string.IsNullOrEmpty(strUpid)) { if (EnshineUnionManager.model.SearchDataClass.IsNumber(strUpid) == true) { using (EnshineUnionDataContext db = new EnshineUnionDataContext()) { HuoDong getNot = db.HuoDong.Single(x => x.huodongId == int.Parse(strUpid)); txtTitle.Value = getNot.huodongTitle; txtPeople.Value = getNot.huodongPeople; txtKeyWord.Value = getNot.huodongKeyWord; txtTimeSelect.Value = getNot.huodongDate.ToString(); drpSetIndex.SelectedValue = getNot.setindex.ToString(); txtFckContent.Value = getNot.huodongContent; this.hfDel.Value = getNot.huodongImg; this.HFurl.Value = getNot.huodongImg; if (!string.IsNullOrEmpty(getNot.huodongImg)) { this.iShowPhoto.Src = getNot.huodongImg; } else { this.iShowPhoto.Src = "assets/images/nophoto.gif"; } drpHuoDongSort.SelectedValue = getNot.huodongsort.ToString(); // db.SubmitChanges(); } } } }
public ActionResult AddEyeActivity(HuoDong model) { SQLHelper sqlh = new SQLHelper(); const string AddEyeActivitysql = @"INSERT INTO dbo.TB_HuoDong ( ActMingCheng,FaBuRen,JieShao) VALUES ( @ActMingCheng, @FaBuRen, @JieShao ) "; SqlParameter[] para = new SqlParameter[] { new SqlParameter("ActMingCheng", model.ActMingCheng), new SqlParameter("FaBuRen", model.FaBuRen), new SqlParameter("JieShao", model.JieShao) }; sqlh.ExecData(AddEyeActivitysql, para); return(RedirectToAction("ScanActivityIndex", "EmployeeBenefits")); }
protected void btnAddHuoDong_Click(object sender, EventArgs e) { using (EnshineUnionDataContext db = new EnshineUnionDataContext()) { HuoDong addNot = new HuoDong(); addNot.huodongTitle = txtTitle.Value.Trim(); addNot.huodongContent = txtFckContent.Value.Trim(); addNot.huodongPeople = txtPeople.Value; addNot.huodongKeyWord = txtKeyWord.Value; addNot.huodongDate = txtTimeSelect.Value; if (!string.IsNullOrEmpty(HFurl.Value)) { addNot.huodongImg = HFurl.Value.Trim(); } addNot.huodongActive = 'N'; addNot.addTime = DateTime.Now; addNot.setindex = Convert.ToChar(drpSetIndex.SelectedValue); addNot.huodongsort = int.Parse(drpHuoDongSort.SelectedValue); db.HuoDong.InsertOnSubmit(addNot); db.SubmitChanges(); } Response.Redirect("HuoDongManager.aspx?mid=" + Request["mid"]); }