public int update(BrandProject po)
{
StringBuilder sql = new StringBuilder();
sql.Append("update BrandProject set ");
sql.Append(String.Format("bp_type={0},", DbAccess.parse(po.bpType)));
sql.Append(String.Format("bp_content={0},", DbAccess.parse(po.bpContent)));
sql.Append("bp_update_time=getdate()");
sql.Append(String.Format(" where bp_id='{0}'", po.bpId));
return DbAccess.executeUpdate(sql.ToString());
}
public int insert(BrandProject po)
{
StringBuilder sql = new StringBuilder();
sql.Append("insert into BrandProject values( ");
if (!String.IsNullOrEmpty(po.bpId))
{
sql.Append(String.Format("{0},", DbAccess.parse(po.bpId)));
}
else
{
sql.Append("newid(), ");
}
sql.Append(String.Format("{0},", DbAccess.parse(po.bpType)));
sql.Append(String.Format("{0},", DbAccess.parse(po.bpContent)));
sql.Append("getdate(), getdate())");
return DbAccess.executeUpdate(sql.ToString());
}
public DataSet select(BrandProject po)
{
StringBuilder sql = new StringBuilder();
sql.Append("select * from BrandProject where 1=1");
if (!String.IsNullOrEmpty(po.bpType))
{
sql.Append(String.Format(" and bp_type={0}", DbAccess.parse(po.bpType)));
}
if (!String.IsNullOrEmpty(po.bpId))
{
sql.Append(String.Format(" and bp_id='{0}'", po.bpId));
}
sql.Append(" order by bp_update_time desc");
return DbAccess.executeQuery(sql.ToString());
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
//context.Response.Write("Hello World");
string method = context.Request.Params["method"];
if ("list".Equals(method))
{
string ajax = context.Request.Params["ajax"];
BrandProjectDAO dao = new BrandProjectDAO();
BrandProject bp = new BrandProject();
bp.bpType = context.Request.Params["bpType"];
DataSet ds = dao.select(bp);
string result = "";
if (String.IsNullOrEmpty(ajax))
{
result = "_list = " + JsonCommon.ds2json(ds);
}
else
{
result = JsonCommon.ds2json(ds);
}
context.Response.Write(result);
}
else if ("detail".Equals(method))
{
BrandProjectDAO dao = new BrandProjectDAO();
BrandProject bp = new BrandProject();
bp.bpId = context.Request.Params["bpId"];
DataSet ds = dao.select(bp);
string json = JsonCommon.ds2json(ds);
PictureDAO picDao = new PictureDAO();
Picture pic = new Picture();
pic.picTableName = "BrandProject";
pic.picTableId = bp.bpId;
DataSet picDs = picDao.select(pic);
string picJson = JsonCommon.ds2json(picDs);
json = String.Format("[{0},{1}]", json, picJson);
context.Response.Write(json);
}
else if ("save".Equals(method))
{
string bpContent = HttpUtility.UrlDecode((context.Request.Params["bpContent"]).Replace("@", "%"));
string bpType = context.Request.Params["bpType"];
string bpId = context.Request.Params["bpId"];
BrandProjectDAO dao = new BrandProjectDAO();
BrandProject bp = new BrandProject();
bp.bpContent = bpContent;
bp.bpType = bpType;
if (!String.IsNullOrEmpty(bpId))
{
bp.bpId = bpId;
dao.update(bp);
}
else
{
bp.bpId = Guid.NewGuid().ToString();
bpId = bp.bpId;
dao.insert(bp);
}
string pics = context.Request.Params["pics"];
string disc = context.Request.Params["disc"];
PictureDAO picDao = new PictureDAO();
//删除要删除的图片
string delPics = context.Request.Params["delPic"];
if (!String.IsNullOrEmpty(delPics))
{
string[] arrDelPics = delPics.Split(',');
for (int i = 0; i < arrDelPics.Length; i++)
{
Picture p = new Picture();
p.picId = arrDelPics[i];
picDao.delete(p);
}
}
if (!String.IsNullOrEmpty(pics))
{
string[] arrPics = pics.Split(',');
string[] arrDisc = disc.Split(',');
for (int i = 0; i < arrPics.Length; i++)
{
string fileName = arrPics[i].Substring(arrPics[i].LastIndexOf("/") + 1);
string fromPath = context.Server.MapPath(arrPics[i]);
string toPath = context.Server.MapPath(FileHelper.Default_Pic_Forder + fileName);
FileHelper.MoveTo(fromPath, toPath);
Picture pic = new Picture();
pic.picTableId = bpId;
pic.picTableName = "BrandProject";
pic.picDescrip = arrDisc[i];
pic.picExtension = fileName.Substring(fileName.LastIndexOf(".") + 1);
pic.picName = fileName;
pic.picPath = FileHelper.Default_Pic_Forder + fileName;
picDao.insert(pic);
}
}
}
else if ("delete".Equals(method))
{
string bpId = context.Request.Params["bpId"];
BrandProjectDAO dao = new BrandProjectDAO();
BrandProject bp = new BrandProject();
bp.bpId = bpId;
dao.delete(bp);
}
}
public int delete(BrandProject po)
{
string sql = String.Format("delete from BrandProject where bp_id='{0}'", po.bpId);
return DbAccess.executeUpdate(sql);
}
