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