public void AdReleaseAddList(HttpContext context) { int AdReleaseID = 0; int AdPositionID = 0; int ResourceID = 0; if (!string.IsNullOrEmpty(context.Request.Form["AdReleaseID"].ToString())) { AdReleaseID = Convert.ToInt32(context.Request.Form["AdReleaseID"].ToString()); } if (!string.IsNullOrEmpty(context.Request.Form["AdPositionID"].ToString())) { AdPositionID = Convert.ToInt32(context.Request.Form["AdPositionID"].ToString()); } var objOrder = GetParam("AdReleaseModel", context); AdReleaseBackup AdRelease = JsonConvert.DeserializeObject <AdReleaseBackup>(objOrder.ToString()); AdReleaseBLL AdReleasebll = new AdReleaseBLL(); //int result = 0; ////编辑 //if (AdReleaseID > 0) //{ // if (AdRelease.BeginTime.ToString() != "" && AdRelease.EndTime.ToString() != "") // { // //AdRelease.ResourceInfo // //result = AdReleasebll.Update(AdRelease) ? 1 : 0; // } //} //else { if (AdRelease.BeginTime.ToString() != "" && AdRelease.EndTime.ToString() != "") { string TPath = ""; byte[] bytes = null; string fileName = ""; HttpFileCollection hfColl = context.Request.Files; HttpPostedFile postFile = hfColl["FileLoad1"]; if (postFile != null) { int FileLen; fileName = Path.GetFileName(postFile.FileName); string fPath = "/Resources/"; string basePath = HttpContext.Current.Server.MapPath(fPath); // 存储路径规则:基础路径+日期(yyyyMMdd)+主键ID TPath = DateTime.Now.ToString("yyyyMMddHHmmss") + fileName; string fDir = basePath + TPath; // 路径不存在的创建 if (!System.IO.Directory.Exists(basePath)) { System.IO.Directory.CreateDirectory(basePath); } if (System.IO.File.Exists(fDir)) { System.IO.File.Delete(fDir); } postFile.SaveAs(fDir); FileLen = postFile.ContentLength; bytes = new byte[FileLen]; } else { ResourceID = AdRelease.ResourceID; } ResourceBLL ResourceAddbll = new ResourceBLL(); string msg = ""; bool b = false; b = ResourceAddbll.ResourceAdd(ResourceID, AdPositionID, AdRelease, TPath, out msg, bytes, fileName); if (b) { AdReleaseID = 1; } } ////} context.Response.Write(AdReleaseID); }
/// <summary> /// 得到一个对象实体 /// </summary> public AdReleaseBackup GetModelOne(int AdReleaseID) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select a.AdReleaseID,a.AdReleaseName, BeginTime, EndTime, a.ResourceID, a.CreatUserID, a.RecordUpdateUserID, a.RecordIsDelete, a.RecordUpdateTime, a.RecordCreateTime, a.Remark,r.FilePath,r.[FileName] ,ap.AdPositionID from AdRelease a left join [Resource] r on a.ResourceID = r.ResourceID and r.RecordIsDelete = 0 LEFT JOIN dbo.AdPosition ap ON ap.AdReleaseID=a.AdReleaseID AND ap.RecordIsDelete=0 where a.AdReleaseID=@AdReleaseID"); SqlParameter[] parameters = { new SqlParameter("@AdReleaseID", SqlDbType.Int, 4) }; parameters[0].Value = AdReleaseID; AdReleaseBackup model = new AdReleaseBackup(); DataSet ds = BWJSHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["AdReleaseID"].ToString() != "") { model.AdReleaseID = int.Parse(ds.Tables[0].Rows[0]["AdReleaseID"].ToString()); } if (ds.Tables[0].Rows[0]["AdReleaseName"].ToString() != "") { model.AdReleaseName = ds.Tables[0].Rows[0]["AdReleaseName"].ToString(); } if (ds.Tables[0].Rows[0]["BeginTime"].ToString() != "") { model.BeginTime = DateTime.Parse(ds.Tables[0].Rows[0]["BeginTime"].ToString()); } if (ds.Tables[0].Rows[0]["EndTime"].ToString() != "") { model.EndTime = DateTime.Parse(ds.Tables[0].Rows[0]["EndTime"].ToString()); } model.ResourceID = ds.Tables[0].Rows[0]["ResourceID"].ToInt(); if (ds.Tables[0].Rows[0]["CreatUserID"].ToString() != "") { model.CreatUserID = int.Parse(ds.Tables[0].Rows[0]["CreatUserID"].ToString()); } if (ds.Tables[0].Rows[0]["RecordUpdateUserID"].ToString() != "") { model.RecordUpdateUserID = int.Parse(ds.Tables[0].Rows[0]["RecordUpdateUserID"].ToString()); } if (ds.Tables[0].Rows[0]["RecordIsDelete"].ToString() != "") { if ((ds.Tables[0].Rows[0]["RecordIsDelete"].ToString() == "1") || (ds.Tables[0].Rows[0]["RecordIsDelete"].ToString().ToLower() == "true")) { model.RecordIsDelete = true; } else { model.RecordIsDelete = false; } } if (ds.Tables[0].Rows[0]["RecordUpdateTime"].ToString() != "") { model.RecordUpdateTime = DateTime.Parse(ds.Tables[0].Rows[0]["RecordUpdateTime"].ToString()); } if (ds.Tables[0].Rows[0]["RecordCreateTime"].ToString() != "") { model.RecordCreateTime = DateTime.Parse(ds.Tables[0].Rows[0]["RecordCreateTime"].ToString()); } model.Remark = ds.Tables[0].Rows[0]["Remark"].ToString(); model.ResourceInfo = ds.Tables[0].Rows[0]["FilePath"].ToString(); model.FileName = ds.Tables[0].Rows[0]["FileName"].ToString(); model.AdPositionID = ds.Tables[0].Rows[0]["AdPositionID"].ToInt(); return(model); } else { return(null); } }