public List<ElementDetailQuery> QueryPacketProd(ElementDetail model) { model.Replace4MySQL(); StringBuilder sql = new StringBuilder(); try { sql.Append("select bd.element_id,bd.element_name,bd.packet_id,bd.element_content,ap.element_type "); sql.Append(" FROM element_detail bd "); sql.Append(" join area_packet ap on ap.packet_id=bd.packet_id"); sql.AppendFormat(" and bd.packet_id='{0}' ", model.packet_id); sql.AppendFormat(" and bd.element_content='{0}' ", model.element_content); return _access.getDataTableForObj<ElementDetailQuery>(sql.ToString()); } catch (Exception ex) { throw new Exception("ElementDetailDao-->QueryPacketProd-->" + ex.Message + sql.ToString(), ex); } }
public ElementDetail GetModel(ElementDetail query) { query.Replace4MySQL(); StringBuilder sqlStr = new StringBuilder(""); try { query.Replace4MySQL(); sqlStr.Append(@"SELECT element_id,packet_id,category_id,category_name,element_content,element_name,"); sqlStr.Append(@"element_link_url,element_link_mode,element_sort,element_status,element_start,element_end,"); sqlStr.Append(@"element_createdate,element_updatedate,create_userid,update_userid,element_remark,element_img_big "); sqlStr.AppendFormat(@"from element_detail where element_id={0};", query.element_id); return _access.getSinggleObj<ElementDetail>(sqlStr.ToString()); } catch (Exception ex) { throw new Exception("ElementDetailDao-->GetModel-->" + ex.Message + sqlStr.ToString(), ex); } }
public int Update(ElementDetail model) { model.Replace4MySQL(); StringBuilder sqlStr = new StringBuilder(""); try { model.Replace4MySQL(); sqlStr.AppendFormat(@"update element_detail set "); sqlStr.AppendFormat(" `element_content`='{0}',`element_name`='{1}',`element_link_url`='{2}',`element_link_mode`='{3}',", model.element_content, model.element_name, model.element_link_url, model.element_link_mode); sqlStr.AppendFormat(" `element_sort`='{0}',`element_start`='{1}',`element_end`='{2}',`element_updatedate`='{3}',`update_userid`='{4}',`element_remark`='{5}',`packet_id`={6} ,`category_id`='{7}',`category_name`='{8}',element_img_big='{9}' ", model.element_sort, CommonFunction.DateTimeToString(model.element_start), CommonFunction.DateTimeToString(model.element_end), CommonFunction.DateTimeToString(model.element_updatedate), model.update_userid, model.element_remark, model.packet_id, model.category_id, model.category_name,model.element_img_big); sqlStr.AppendFormat(" where element_id='{0}'", model.element_id); return _access.execCommand(sqlStr.ToString()); } catch (Exception ex) { throw new Exception("ElementDetailDao-->Update-->" + ex.Message + sqlStr.ToString(), ex); } }
public int Save(ElementDetail model) { model.Replace4MySQL(); StringBuilder sqlStr = new StringBuilder(""); try { model.Replace4MySQL(); sqlStr.Append(@"insert into element_detail(`element_content`,`element_name`,`element_link_url`,`element_link_mode`,`element_sort`,`element_status`,`element_start`,`element_end`,`element_createdate`,`element_updatedate`,`create_userid`,`update_userid`,`element_remark`,`packet_id`,`category_id`,`category_name`,`element_img_big`) "); sqlStr.AppendFormat(" values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}',{13},'{14}','{15}','{16}') ", model.element_content, model.element_name, model.element_link_url, model.element_link_mode, model.element_sort, model.element_status, CommonFunction.DateTimeToString(model.element_start), CommonFunction.DateTimeToString(model.element_end), CommonFunction.DateTimeToString(model.element_createdate), CommonFunction.DateTimeToString(model.element_updatedate), model.create_userid, model.update_userid, model.element_remark, model.packet_id, model.category_id, model.category_name,model.element_img_big); return _access.execCommand(sqlStr.ToString()); } catch (Exception ex) { throw new Exception("ElementDetailDao-->Save-->" + ex.Message + sqlStr.ToString(), ex); } }
public HttpResponseBase SaveElementDetaiil() { string resultJson = "{success:false}"; ElementDetail model = new ElementDetail(); ElementDetail oldModel = new ElementDetail(); _detailMgr = new ElementDetailMgr(mySqlConnectionString); #region 獲取圖片信息 string path = Server.MapPath(xmlPath); SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path); SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format"); SiteConfig minValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_Min_Element"); SiteConfig maxValue_config = _siteConfigMgr.GetConfigByName("PIC_Length_MaxValue"); SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME"); SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD"); //擴展名、最小值、最大值 string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value; string minValue = minValue_config.Value == "" ? minValue_config.DefaultValue : minValue_config.Value; string maxValue = maxValue_config.Value == "" ? maxValue_config.DefaultValue : maxValue_config.Value; string localBannerPath = imgLocalPath + ElementPath;//圖片存儲地址 #endregion if (!String.IsNullOrEmpty(Request.Params["element_id"]))//如果不存在該id說明是添加頁面 { model.element_id = Convert.ToInt32(Request.Params["element_id"].ToString()); oldModel = _detailMgr.GetModel(model); } #region 獲取數據 int isTranInt = 0; //if (Int32.TryParse(Request.Params["element_area_id"].ToString(), out isTranInt)) //{ // model.element_area_id = Convert.ToInt32(Request.Params["element_area_id"].ToString()); //} //else //{ // model.element_area_id = oldModel.element_area_id; //} if (!string.IsNullOrEmpty(Request.Params["element_name"].ToString())) { model.element_name = Request.Params["element_name"].ToString(); } else { model.element_name = oldModel.element_name; } if (!string.IsNullOrEmpty(Request.Params["packet_id"])) { model.packet_id = Convert.ToInt32(Request.Params["packet_id"]); } if (Int32.TryParse(Request.Params["element_type"].ToString(), out isTranInt)) { model.element_type = Convert.ToInt32(Request.Params["element_type"]); } if (model.element_type == 1) { #region 上傳圖片 try { FileManagement fileLoad = new FileManagement(); //if (Request.Files.Count > 0)//單個圖片上傳 for (int iFile = 0; iFile < Request.Files.Count; iFile++)//多個上傳圖片 { HttpPostedFileBase file = Request.Files[iFile];//單個Request.Files[0] string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.FileName); if (iFile == 0 && fileName == oldModel.element_content) { fileName = ""; } if(iFile == 1 && string.IsNullOrEmpty(Request.Params["element_img_big"].ToString()) ) { fileName = Request.Params["element_img_big"].ToString(); } if (!String.IsNullOrEmpty(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(localBannerPath.Substring(0, localBannerPath.Length - ElementPath.Length + 1), ElementPath.Substring(1, ElementPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + ElementPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (model.element_id != 0) { string oldFileName = oldModel.element_content; if (iFile == 1) { oldFileName = oldModel.element_img_big; } CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localBannerPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + 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)//上傳成功 { if (iFile == 0) { model.element_content = fileName; } else { model.element_img_big = 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.element_content = oldModel.element_content; } if (!string.IsNullOrEmpty(ErrorMsg)) { if (iFile == 0) { ErrorMsg = "元素圖 " + ErrorMsg; } else { ErrorMsg = "元素圖(大) " + ErrorMsg; } string json = string.Empty; json = "{success:true,msg:\""+ ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { if (iFile == 0) { model.element_content = oldModel.element_content; } else { if (Request.Params["element_img_big"].ToString() == "") {//編輯時如果傳過來空值則直接刪除 model.element_img_big = ""; } else { model.element_img_big = oldModel.element_img_big; } //model.element_img_big = oldModel.element_img_big; } } } } 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.element_content = oldModel.element_content; } #endregion } else if (model.element_type == 2) { if (!string.IsNullOrEmpty(Request.Params["element_content"].ToString())) { model.element_content = Request.Params["element_content"].ToString(); } else { model.element_content = oldModel.element_content; } } else if (model.element_type == 3) { if (int.TryParse(Request.Params["element_product_id"].ToString(), out isTranInt)) { model.element_content = Request.Params["element_product_id"].ToString(); } else { model.element_content = oldModel.element_content; } #region 上傳圖片 try { FileManagement fileLoad = new FileManagement(); //if (Request.Files.Count > 0)//單個圖片上傳 for (int iFile = 1; iFile < Request.Files.Count; iFile++)//多個上傳圖片 { HttpPostedFileBase file = Request.Files[iFile];//單個Request.Files[0] string fileName = string.Empty;//當前文件名 string fileExtention = string.Empty;//當前文件的擴展名 //獲取圖片名稱 fileName = fileLoad.NewFileName(file.FileName); if (!String.IsNullOrEmpty(fileName) && !String.IsNullOrEmpty(Request.Params["element_img_big"].ToString())) {//可獲取文件,名稱不為空則變更圖片 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(localBannerPath.Substring(0, localBannerPath.Length - ElementPath.Length + 1), ElementPath.Substring(1, ElementPath.Length - 2).Split('/'), ftpuser, ftppwd); fileName = NewFileName + fileExtention; NewFileName = localBannerPath + NewFileName + fileExtention;//絕對路徑 ServerPath = Server.MapPath(imgLocalServerPath + ElementPath); string ErrorMsg = string.Empty; //上傳之前刪除已有的圖片 if (model.element_id != 0) { string oldFileName = oldModel.element_img_big; CommonFunction.DeletePicFile(ServerPath + oldFileName);//刪除本地圖片 FTP ftp = new FTP(localBannerPath, ftpuser, ftppwd); List<string> tem = ftp.GetFileList(); if (tem.Contains(oldFileName)) { FTP ftps = new FTP(localBannerPath + oldFileName, ftpuser, ftppwd); ftps.DeleteFile(localBannerPath + 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.element_img_big = 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.element_img_big = oldModel.element_img_big; } if (!string.IsNullOrEmpty(ErrorMsg)) { ErrorMsg = "元素圖(大)" + ErrorMsg; string json = string.Empty; json = "{success:true,msg:\"" + ErrorMsg + "\"}"; this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; } } else { if (Request.Params["element_img_big"].ToString() == "") {//編輯時如果傳過來空值則直接刪除 model.element_img_big = ""; } else { model.element_img_big = oldModel.element_img_big; } } } } 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.element_img_big = oldModel.element_img_big; } #endregion } if (int.TryParse(Request.Params["category_id_s"].ToString(), out isTranInt)) { model.category_id = uint.Parse(Request.Params["category_id_s"].ToString()); } else { model.category_id = 0; } model.category_name = Server.HtmlDecode(Request.Params["category_name_s"].ToString()); if (!string.IsNullOrEmpty(Request.Params["element_link_url"].ToString())) { model.element_link_url = Request.Params["element_link_url"].ToString(); } //else //{ // model.element_link_url = oldModel.element_link_url; //} if (int.TryParse(Request.Params["element_link_mode"].ToString(), out isTranInt)) { model.element_link_mode = Convert.ToInt32(Request.Params["element_link_mode"]); } else { model.element_link_mode = oldModel.element_link_mode; } if (!string.IsNullOrEmpty(Request.Params["element_sort"].ToString())) { model.element_sort = Convert.ToInt32(Request.Params["element_sort"].ToString()); } //else //{ // model.element_sort = oldModel.element_sort; //} if (!string.IsNullOrEmpty(Request.Params["element_start"].ToString())) { model.element_start = Convert.ToDateTime(Request.Params["element_start"].ToString()); } else { model.element_start = oldModel.element_start; } if (!string.IsNullOrEmpty(Request.Params["element_end"].ToString())) { model.element_end = Convert.ToDateTime(Request.Params["element_end"].ToString()); } else { model.element_end = oldModel.element_end; } model.element_remark = (Request.Params["element_remark"].ToString()); model.element_status = 0;//默認為不啟用 #endregion try { //判斷是否能夠獲取到rowid if (String.IsNullOrEmpty(Request.Params["element_id"]))//如果不存在該id說明是添加頁面 { model.element_createdate = DateTime.Now; model.element_updatedate = model.element_createdate; model.create_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; model.update_userid = model.create_userid; //這裡加上各種參數 if (_detailMgr.Save(model) > 0) { resultJson = "{success:true}";//返回json數據 } } else { //model.element_createdate = oldModel.element_createdate; model.element_updatedate = DateTime.Now; model.update_userid = (System.Web.HttpContext.Current.Session["caller"] as Caller).user_id; // model.create_userid = oldModel.create_userid; //這裡加上各種參數 if (_detailMgr.Update(model) > 0)//如果可以獲取到rowid則進行修改 { resultJson = "{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); resultJson = "{success:false}"; } this.Response.Clear(); this.Response.Write(resultJson); this.Response.End(); return this.Response; }
public List<ElementDetailQuery> QueryPacketProd(ElementDetail model) { try { return _detaildao.QueryPacketProd(model); } catch (Exception ex) { throw new Exception("ElementDetailMgr-->QueryPacketProd-->" + ex.Message, ex); }; }