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