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