public int GetDefault(WebContentType4 model) { try { return _wctdao.GetDefault(model); } catch (Exception ex) { throw new Exception("WebContentType4Mgr.GetDefault-->" + ex.Message, ex); } }
/// <summary> /// 獲取已啟用的個數 /// </summary> /// <returns></returns> public int GetDefault(WebContentType4 model) { StringBuilder sql = new StringBuilder(""); try { sql.AppendFormat(@" select count(*) as countSta from web_content_type4 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("WebContentType4Dao.GetDefault-->" + ex.Message + sql.ToString(), ex); } }
/// <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 updateWebContentType4(WebContentType4 model) { string json = string.Empty; try { _wctMgr4.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; }
public HttpResponseBase SaveWebContentType4() { WebContentType4 model = new WebContentType4(); WebContentType4 oldModel = new WebContentType4(); if (!String.IsNullOrEmpty(Request.Params["rowid"]))//如果不存在該id說明是添加頁面 { model.content_id = Convert.ToInt32(Request.Params["rowid"].ToString()); oldModel = _wctMgr4.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; } try { model.type_id = Convert.ToInt32(Request.Params["type_id"]); } catch { model.type_id = oldModel.type_id; } #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); // fileName = fileName.Substring(0, fileName.LastIndexOf(".")); // fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')); // 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(localPromoPath.Substring(0, localPromoPath.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 = localPromoPath + 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(localPromoPath, ftpuser, ftppwd); // List<string> tem = ftp.GetFileList(); // if (tem.Contains(oldFileName)) // { // FTP ftps = new FTP(localPromoPath + oldFileName, ftpuser, ftppwd); // ftps.DeleteFile(localPromoPath + oldFileName);//刪除ftp:71.159上的舊圖片 // } // } // try // {//上傳 // 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) // { // model.content_image = oldModel.content_image; // } // } //} //catch (Exception) //{ // model.content_image = oldModel.content_image; //} #endregion try { model.brand_id = Convert.ToInt32(Request.Params["brand_id"].ToString()); } catch { model.brand_id = oldModel.brand_id; } try { model.content_html = Request.Params["home_text"].ToString(); } catch { model.content_html = oldModel.content_html; } try { model.content_default = Convert.ToInt32(Request.Params["content_default"]); } catch { model.content_default = oldModel.content_default; } try { model.content_status = Convert.ToInt32(Request.Params["content_status"]); } catch { model.content_status = oldModel.content_status; } try { model.link_url = Request.Params["link_url"].ToString(); } catch { model.content_status = oldModel.content_status; } try { model.link_mode = Convert.ToInt32(Request.Params["link_mode"]); } catch { model.link_mode = oldModel.link_mode; } #endregion //判斷是否能夠獲取到rowid if (String.IsNullOrEmpty(Request.Params["content_id"]))//如果不存在該id說明是添加頁面 { model.created_on = DateTime.Now; model.update_on = model.created_on; //這裡加上各種參數 return InsertWebContentType4(model);//如果獲取不到則進行新增 } else { model.update_on = DateTime.Now;//這裡加上各種參數 return updateWebContentType4(model);//如果可以獲取到rowid則進行修改 } }