public int Insert(WebContentType2 model)
{
model.Replace4MySQL();
StringBuilder sb = new StringBuilder();
try
{
if (model.content_status == 1)//啟用
{
WebContentTypeSetupDao _setDao = new WebContentTypeSetupDao(_connStr);
WebContentTypeSetup smodel = new WebContentTypeSetup();
smodel.site_id = model.site_id;
smodel.page_id = model.page_id;
smodel.area_id = model.area_id;
smodel.web_content_type = "web_content_type2";
_setDao.UpdateLimitStatus(smodel);////當前已啟用的個數超過5筆時，使最舊的不啟用，
}
sb.AppendFormat(@"INSERT INTO web_content_type2(site_id,page_id,area_id,content_title,content_image,home_title,home_text,product_id,content_default,content_status,link_url,link_page,link_mode,start_time,end_time,update_on,created_on) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}') ", model.site_id, model.page_id, model.area_id, model.content_title, model.content_image, model.home_title, model.home_text, model.product_id, model.content_default, model.content_status, model.link_url, model.link_page, model.link_mode, CommonFunction.DateTimeToString(model.start_time), CommonFunction.DateTimeToString(model.end_time), CommonFunction.DateTimeToString(model.update_on), CommonFunction.DateTimeToString(model.created_on));
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("WebContentType2Dao.Insert-->" + ex.Message + sb.ToString(), ex);
}
}
public int GetDefault(WebContentType2 model)
{
try
{
return _wctdao.GetDefault(model);
}
catch (Exception ex)
{
throw new Exception("WebContentType2Mgr.GetDefault-->" + ex.Message, ex);
}
}
public WebContentType2 GetModel(WebContentType2 model)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat(@"select * from web_content_type2 where content_id ={0}", model.content_id);
return _access.getSinggleObj<WebContentType2>(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("WebContentType2Dao.GetModel-->" + ex.Message + sb.ToString(), ex);
}
}
public int delete(WebContentType2 model)
{
StringBuilder sb = new StringBuilder();
try
{
sb.AppendFormat(@"update web_content_type2 set content_status=0 where content_id='{0}'", model.content_id);
return _access.execCommand(sb.ToString());
}
catch (Exception ex)
{
throw new Exception("WebContentType2Dao.delete-->" + ex.Message + sb.ToString(), ex);
}
}
/// <summary>
/// 獲取已啟用的個數
/// </summary>
/// <returns></returns>
public int GetDefault(WebContentType2 model)
{
StringBuilder sql = new StringBuilder("");
try
{
sql.AppendFormat(@" select count(*) as countSta from web_content_type2 where content_status=1 and pag_id='{0}';", model.page_id);
return Convert.ToInt32(_access.getDataTable(sql.ToString()).Rows[0]["countSta"].ToString());
}
catch (Exception ex)
{
throw new Exception("WebContentType2Dao.GetDefault-->" + ex.Message + sql.ToString(), ex);
}
}
public HttpResponseBase SaveWebContentType2()
{
WebContentType2 model = new WebContentType2();
WebContentType2 oldModel = new WebContentType2();
int isTranInt = 0;
if (!String.IsNullOrEmpty(Request.Params["rowid"]))//如果不存在該id說明是添加頁面
{
model.content_id = Convert.ToInt32(Request.Params["rowid"].ToString());
oldModel = _wctMgr2.GetModel(model);
}
#region 獲取數據
model.site_id = 7;
try
{
model.page_id = Convert.ToInt32(Request.Params["page_id"].ToString());
}
catch
{
model.page_id = oldModel.page_id;
}
try
{
model.area_id = Convert.ToInt32(Request.Params["area_id"].ToString());
}
catch
{
model.area_id = oldModel.area_id;
}
model.content_title = Request.Params["content_title"].ToString();
model.home_title = Request.Params["home_title"].ToString();
model.home_text = Request.Params["home_text"].ToString();
#region 圖片上傳
try
{
ImagePathConfig();
for (int iFile = 0; iFile < Request.Files.Count; iFile++)
{
HttpPostedFileBase file = Request.Files[iFile];
string fileName = string.Empty;//當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
//獲取圖片名稱
fileName = fileLoad.NewFileName(file.FileName);
if (fileName != "")
{
fileName = fileName.Substring(0, fileName.LastIndexOf("."));
fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString();
string NewFileName = string.Empty;
BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt();
NewFileName = hash.Md5Encrypt(fileName, "32");
string ServerPath = string.Empty;
//判斷目錄是否存在，不存在則創建
FTP f_cf = new FTP();
f_cf.MakeMultiDirectory(localHealthPath.Substring(0, localHealthPath.Length - healthPath.Length + 1), healthPath.Substring(1, healthPath.Length - 2).Split('/'), ftpuser, ftppwd);
// CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - healthPath.Length + 1), healthPath.Substring(1, healthPath.Length - 2).Split('/'));
// returnName += promoPath + NewFileName;
fileName = NewFileName + fileExtention;
NewFileName = localHealthPath + NewFileName + fileExtention;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + healthPath);
string ErrorMsg = string.Empty;
//上傳之前刪除已有的圖片
if (model.content_id != 0)
{
string oldFileName = oldModel.content_image;
CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片
FTP ftp = new FTP(localHealthPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
if (tem.Contains(oldFileName))
{
FTP ftps = new FTP(localHealthPath + oldFileName, ftpuser, ftppwd);
ftps.DeleteFile(localHealthPath + oldFileName);//刪除ftp:71.159上的舊圖片
}
}
try
{
//上傳
Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件
bool result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
model.content_image = fileName;
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
model.content_image = oldModel.content_image;
}
if (!string.IsNullOrEmpty(ErrorMsg))
{
string json = string.Empty;
json = "{success:true,msg:\"" + ErrorMsg + "\"}";
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
}
else
{
model.content_image = oldModel.content_image;
}
}
}
catch (Exception)
{
model.content_image = oldModel.content_image;
}
#endregion
if (!string.IsNullOrEmpty(Request.Params["product_id"].ToString()))
{
if (int.TryParse(Request.Params["product_id"].ToString(), out isTranInt))
{
model.product_id = Convert.ToInt32(Request.Params["product_id"]);
}
else
{
model.product_id = oldModel.product_id;
}
}
else
{
model.product_id = 0;
}
model.content_default = Convert.ToInt32(Request.Params["content_default"]);
model.content_status = Convert.ToInt32(Request.Params["content_status"]);
model.link_url = Request.Params["link_url"].ToString();
if (!string.IsNullOrEmpty(Request.Params["start_time"].ToString()))
{
model.start_time = DateTime.Parse(Request.Params["start_time"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["end_time"].ToString()))
{
model.end_time = DateTime.Parse(Request.Params["end_time"].ToString());
}
//model.link_page = Request.Params["link_page"].ToString();
model.link_mode = Convert.ToInt32(Request.Params["link_mode"]);
#endregion
//判斷是否能夠獲取到rowid
if (String.IsNullOrEmpty(Request.Params["content_id"]))//如果不存在該id說明是添加頁面
{
model.created_on = DateTime.Now;
model.update_on = model.created_on;//這裡加上各種參數
return InsertWebContentType2(model);//如果獲取不到則進行新增
}
else
{
model.update_on = DateTime.Now;//這裡加上各種參數
return updateWebContentType2(model);//如果可以獲取到rowid則進行修改
}
}
/// <summary>
/// 更改活動使用狀態
/// </summary>
/// <returns>數據庫操作結果</returns>
public JsonResult UpdateActive()
{
string storeType = Request.Params["storeType"].ToString();
switch (storeType)
{
case "type1":
WebContentType1 model1 = new WebContentType1();
model1.content_id = Convert.ToInt32(Request.Params["id"]);
model1 = _wctMgr1.GetModel(model1);
model1.content_status = Convert.ToInt32(Request.Params["active"]);
model1.content_default = 1;
if (_wctMgr1.Update(model1) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
case "type2":
WebContentType2 model2 = new WebContentType2();
model2.content_id = Convert.ToInt32(Request.Params["id"]);
model2 = _wctMgr2.GetModel(model2);
model2.content_status = Convert.ToInt32(Request.Params["active"]);
model2.content_default = 1;
if (_wctMgr2.Update(model2) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
case "type3":
WebContentType3 model3 = new WebContentType3();
model3.content_id = Convert.ToInt32(Request.Params["id"]);
model3 = _wctMgr3.GetModel(model3);
model3.content_status = Convert.ToInt32(Request.Params["active"]);
model3.content_default = 1;
if (_wctMgr3.Update(model3) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
case "type4":
WebContentType4 model4 = new WebContentType4();
model4.content_id = Convert.ToInt32(Request.Params["id"]);
model4 = _wctMgr4.GetModel(model4);
model4.content_status = Convert.ToInt32(Request.Params["active"]);
model4.content_default = 1;
if (_wctMgr4.Update(model4) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
case "type5":
WebContentType5 model5 = new WebContentType5();
model5.content_id = Convert.ToInt32(Request.Params["id"]);
model5 = _wctMgr5.GetModel(model5);
model5.content_status = Convert.ToInt32(Request.Params["active"]);
model5.content_default = 1;
if (_wctMgr5.Update(model5) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
case "type6":
WebContentType6 model6 = new WebContentType6();
model6.content_id = Convert.ToInt32(Request.Params["id"]);
model6 = _wctMgr6.GetModel(model6);
model6.content_status = Convert.ToInt32(Request.Params["active"]);
model6.content_default = 1;
if (_wctMgr6.Update(model6) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
case "type7":
WebContentType7 model7 = new WebContentType7();
model7.content_id = Convert.ToInt32(Request.Params["id"]);
model7 = _wctMgr7.GetModel(model7);
model7.content_status = Convert.ToInt32(Request.Params["active"]);
model7.content_default = 1;
if (_wctMgr7.Update(model7) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
case "type8":
WebContentType8 model8 = new WebContentType8();
model8.content_id = Convert.ToInt32(Request.Params["id"]);
model8 = _wctMgr8.GetModel(model8);
model8.content_status = Convert.ToInt32(Request.Params["active"]);
model8.content_default = 1;
if (_wctMgr8.Update(model8) > 0)
{
return Json(new { success = "true", msg = "" });
}
else
{
return Json(new { success = "false", msg = "" });
}
default:
return Json(new { success = "false", msg = "" });
}
}
/// <summary>
/// 獲取參數表中設置的限制值
/// </summary>
/// <returns>數據庫操作結果</returns>
public JsonResult GetDefaultLimit()
{
int statusListNum = 0; int limitNumStatus = 0;
WebContentTypeSetup model = new WebContentTypeSetup();
model.web_content_type = Request.Params["storeType"].ToString();
model.site_id = Convert.ToInt32(Request.Params["site"].ToString());
model.page_id = Convert.ToInt32(Request.Params["page"]);
model.area_id = Convert.ToInt32(Request.Params["area"]);
limitNumStatus = _wctsuMgr.Query(model)[0].content_status_num;
if (limitNumStatus != 0 && !string.IsNullOrEmpty(limitNumStatus.ToString()))
{
switch (model.web_content_type)
{
case "web_content_type1":
WebContentType1 model1 = new WebContentType1();
model1.page_id = model.page_id;
statusListNum = _wctMgr1.GetDefault(model1);//獲取列表中已啟用的數量
break;
case "web_content_type2":
WebContentType2 model2 = new WebContentType2();
model2.page_id = model.page_id;
statusListNum = _wctMgr2.GetDefault(model2);
break;
case "web_content_type3":
WebContentType3 model3 = new WebContentType3();
model3.page_id = model.page_id;
statusListNum = _wctMgr3.GetDefault(model3);
break;
case "web_content_type4":
WebContentType4 model4 = new WebContentType4();
model4.page_id = model.page_id;
statusListNum = _wctMgr4.GetDefault(model4);
break;
case "web_content_type5":
WebContentType5 model5 = new WebContentType5();
model5.page_id = model.page_id;
statusListNum = _wctMgr5.GetDefault(model5);
break;
case "web_content_type6":
WebContentType6 model6 = new WebContentType6();
model6.page_id = model.page_id;
statusListNum = _wctMgr6.GetDefault(model6);
break;
case "web_content_type7":
WebContentType7 model7 = new WebContentType7();
model7.page_id = model.page_id;
statusListNum = _wctMgr7.GetDefault(model7);
break;
case "web_content_type8":
WebContentType8 model8 = new WebContentType8();
model8.page_id = model.page_id;
statusListNum = _wctMgr8.GetDefault(model8);
break;
default:
break;
}
}
return Json(new { success = "true", listNum = statusListNum, limitNum = limitNumStatus });
}
protected HttpResponseBase updateWebContentType2(WebContentType2 model)
{
string json = string.Empty;
try
{
_wctMgr2.Update(model);
json = "{success:true}";//返回json數據
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
json = "{success:false}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}