public string StartPicEdit(HttpContext context) { string pid = ""; DateTime stime; DateTime etime; bool defalut = false; string url = ""; if (!string.IsNullOrEmpty(context.Request.Form["pid"])) { pid = De(context.Request.Form["pid"]); url = string.IsNullOrEmpty(context.Request.Form["url"]) ? "" : context.Request.Form["url"]; bool.TryParse(context.Request.Form["defalut"], out defalut); BCtrl_StartPicSearch bll = new BCtrl_StartPicSearch(); StartPicEntity item = new StartPicEntity() { PicURL = pid, IsDefault = defalut, IsOutdate = false, URL = url }; if (!string.IsNullOrEmpty(context.Request.Form["stime"])) { DateTime.TryParse(context.Request.Form["stime"], out stime); item.StartTime = stime; } if (!string.IsNullOrEmpty(context.Request.Form["etime"])) { DateTime.TryParse(context.Request.Form["etime"], out etime); item.EndTime = etime; } if (bll.Add(item)) { return(string.Format(G.JSON_OK_STATE_STRING, "添加成功")); } else { return(string.Format(G.JSON_ERROR_STATE_STRING, "添加失败")); } } else { return(string.Format(G.JSON_ERROR_STATE_STRING, "参数获取失败")); } }
public bool Add(StartPicEntity item) { StringBuilder strSql = new StringBuilder(); string sd = item.StartTime == null ? "" : "StartTime,"; string sdd = item.StartTime == null ? "" : "'" + Convert.ToDateTime(item.StartTime).ToString("yyyy-MM-dd") + "',"; string ed = item.EndTime == null ? "" : "EndTime,"; string edd = item.EndTime == null ? "" : "'" + Convert.ToDateTime(item.EndTime).ToString("yyyy-MM-dd") + "',"; strSql.AppendFormat(@" insert into M_StartPictures( PictureID, {4} {5} IsDefault, IsOutdate,Url) SELECT PictureID,{0} {1} {2}, {3},'{7}' FROM M_Pictures WHERE PicturePath LIKE '%{6}%'" , sdd, edd, Convert.ToInt16(item.IsDefault), Convert.ToInt16(item.IsOutdate), sd, ed, item.PicURL.Substring(item.PicURL.LastIndexOf('/')), item.URL); return(SQlHelper.ExecuteNonQuery(SQlHelper.MyConnectStr, CommandType.Text, strSql.ToString(), null) > 0); }
public bool Add(StartPicEntity item) { return(dao.Add(item)); }