public bool Add(Activity atvy) { dalBase.sql = "INSERT INTO db_activity VALUES (null,@content,@publishTime,@isactive," + "@preStart,@overEnd,@isVisitApply,@contentDetails);"; dalBase.List_param = new List<MySqlParameter>() { new MySqlParameter("@content",atvy.Content), new MySqlParameter("@publishTime",atvy.PublishTime), new MySqlParameter("@isactive",atvy.IsActive), new MySqlParameter("@isVisitApply",atvy.IsVisitApply), new MySqlParameter("@preStart",atvy.PreStart), new MySqlParameter("@overEnd",atvy.OverEnd), new MySqlParameter("@contentDetails",atvy.ContentDetails) }; return dalBase.Run(Behavious.INSERT_OR_UPDATE_OR_DELETE, true); }
private bool CreateInstance(HttpRequestBase req, ref Activity atvy) { bool flag = true; try { atvy = new Activity() { ID = Convert.ToInt32(req.Form["id"]), Content = req.Form["content"].ToString(), IsActive = Convert.ToByte(req.Form["isactive"]), PreStart = Convert.ToDateTime(req.Form["prestart"]), OverEnd = Convert.ToDateTime(req.Form["overend"]), ContentDetails = req.Form["contentdetails"].ToString(), IsVisitApply =(byte) (req.Form["isvisitapply"]=="on"?1:0), PublishTime = Convert.ToDateTime(req.Form["publish"]), //PreEnd = Convert.ToDateTime(req.Form["preend"]), //MidStart = Convert.ToDateTime(req.Form["midstart"]), //MidEnd = Convert.ToDateTime(req.Form["midend"]), //OverStart = Convert.ToDateTime(req.Form["overstart"]), }; } catch (System.Exception ex) { flag = false; atvy = null; } return flag; }
public ResponseStatus GetActivity(int id,Activity atvy) { activityDal = new ActivityDAL(); ResponseStatus resp = activityDal.GetActivity(id, atvy); activityDal.ReturnUnitToPool(); return resp; }
public ActionResult Update(int? id) { if (Request.Form != null && Request.Form.Count > 0) { ResponseStatus resp = activityService.UpdateActivity(Request); return this.JudgeResult(resp, () => RedirectToAction("Details", new { msg = string.Format("更新了活动:{0}", Request.Form["content"]) })); } else { Activity atvy = new Activity(); ResponseStatus resp = activityService.GetActivity((Int32)id, atvy); return this.JudgeResult(resp, () => View(atvy)); } }
public ResponseStatus GetActivity(int id, Activity atvy) { dalBase.sql = "SELECT * FROM db_activity WHERE id=@id"; dalBase.Param = new MySqlParameter("@id",id); bool isSuccess = dalBase.Run(Behavious.SELECT_WITH_SINGLEPARAM, false); return this.JudgeDBResult(isSuccess, () => { dalBase.DataRead.Read(); atvy.ID = Convert.ToInt32(dalBase.DataRead["id"]); atvy.Content = dalBase.DataRead["Content"].ToString(); atvy.IsActive = Convert.ToByte(dalBase.DataRead["isactive"]); atvy.IsVisitApply = Convert.ToByte(dalBase.DataRead["isVisitApply"]); atvy.PublishTime = dalBase.DataRead["publishTime"] != DBNull.Value ? Convert.ToDateTime(dalBase.DataRead["publishTime"]) : GLB.initTime; atvy.PreStart = dalBase.DataRead["preStart"] != DBNull.Value ? Convert.ToDateTime(dalBase.DataRead["preStart"]) : GLB.initTime; atvy.OverEnd = dalBase.DataRead["overEnd"] != DBNull.Value ? Convert.ToDateTime(dalBase.DataRead["overEnd"]) : GLB.initTime; atvy.ContentDetails = dalBase.DataRead["contentDetails"].ToString(); },null); }
public bool Update(Activity atvy) { dalBase.sql = "UPDATE db_activity SET content=@content,publishTime=@publishTime,isactive= @isactive,isVisitApply=@isVisitApply,preStart=@preStart," + "overEnd=@overEnd,contentDetails=@contentDetails WHERE id =@id"; dalBase.List_param = new List<MySqlParameter>() { new MySqlParameter("@content",atvy.Content), new MySqlParameter("@publishTime",atvy.PublishTime), new MySqlParameter("@isactive",atvy.IsActive), new MySqlParameter("@isVisitApply",atvy.IsVisitApply), new MySqlParameter("@preStart",atvy.PreStart), new MySqlParameter("@overEnd",atvy.OverEnd), new MySqlParameter("@contentDetails",atvy.ContentDetails), new MySqlParameter("@id",atvy.ID) }; return dalBase.Run(Behavious.INSERT_OR_UPDATE_OR_DELETE, true); }