/// <summary>
/// 獲取父類別編號
/// </summary>
/// <returns>數據庫操作結果</returns>
public JsonResult GetFatherId()
{
string jsonStr = string.Empty;
try
{
CategoryQuery model = new CategoryQuery();
if (!string.IsNullOrEmpty(Request.Params["fid"]))
{
model.category_id = Convert.ToUInt32(Request.Params["fid"]);
}
_proCategoryImplMgr = new CategoryMgr(mySqlConnectionString);
CategoryQuery cq = _proCategoryImplMgr.GetProductCategoryById(model);
return Json(new { success = "true", result = cq.category_father_id.ToString() });
}
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);
return Json(new { success = "false" });
}
}
/// <summary>
/// 匯出csv
/// </summary>
/// <returns></returns>
public HttpResponseBase ProductCategoryCSV()
{
string newCsvName = string.Empty;
string json = string.Empty;
DataTable dt = new DataTable();
CategoryQuery query = new CategoryQuery();
if (!string.IsNullOrEmpty(Request.Params["Root"]))
{
query.category_father_id = Convert.ToUInt32(Request.Params["Root"]);
}
List<ProductCategory> categoryList = new List<ProductCategory>();
List<ProductCategoryCustom> cateList = new List<ProductCategoryCustom>();
// _procateMgr = new ProductCategoryMgr(connectionString);
_proCategoryImplMgr = new CategoryMgr(mySqlConnectionString);
dt.Columns.Add(new DataColumn("", typeof(string)));
DataRow dr = dt.NewRow();
dr[0] = query.category_father_id.ToString() + " " + _proCategoryImplMgr.GetProductCategoryById(new CategoryQuery { category_id = query.category_father_id }).category_name;//根
dt.Rows.Add(dr);
// categoryList = _procateMgr.GetProductCate(new ProductCategory { });//數據源
categoryList = _proCategoryImplMgr.GetProductCategoryCSV(query);
cateList = getCate(categoryList, query.category_father_id.ToString());//得到第二層分支
// cateList={1,2,3,4};
//調試resultlist是否為空
GetCategoryList(categoryList, ref cateList, ref dt, 1);
try
{
string filename = "ProductCategory_" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".csv";
if (!System.IO.Directory.Exists(Server.MapPath(excelPath)))
{
System.IO.Directory.CreateDirectory(Server.MapPath(excelPath));
}
newCsvName = Server.MapPath(excelPath) + filename;
if (System.IO.File.Exists(newCsvName))
{
//設置文件的屬性，以防刪除文件的時候因為文件的屬性造成無法刪除
System.IO.File.SetAttributes(newCsvName, FileAttributes.Normal);
System.IO.File.Delete(newCsvName);
}
string[] colname = { };
CsvHelper.ExportDataTableToCsv(dt, newCsvName, colname, false);
json = "true," + filename + "," + excelPath;
}
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 = "false, ";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 新增編輯類別信息
/// </summary>
/// <returns></returns>
public HttpResponseBase ProductCategorySave()
{
string json = string.Empty;
string jsonStr = string.Empty;
CategoryQuery cq = new CategoryQuery();
IAreaPactetImplMgr _iareaPacketMgr = new AreaPacketMgr(mySqlConnectionString);
string errorInfo = string.Empty;
try
{
_proCategoryImplMgr = new CategoryMgr(mySqlConnectionString);
if (!string.IsNullOrEmpty(Request.Params["category_id"]))
{
cq.category_id = Convert.ToUInt32(Request.Params["category_id"]);
}
CategoryQuery oldCq = _proCategoryImplMgr.GetProductCategoryById(cq);
if (oldCq != null)
{
cq.banner_image = oldCq.banner_image;
cq.category_image_in = oldCq.category_image_in;
cq.category_image_out = oldCq.category_image_out;
cq.category_image_app = oldCq.category_image_app;
}
#region 上傳圖片
try
{
if (Request.Files.Count != 0)
{
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_MinValue");
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 localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
for (int a = 0; a < Request.Files.Count; a++)
{
string fileName = string.Empty; //當前文件名
string fileExtention = string.Empty;//當前文件的擴展名
HttpPostedFileBase file = Request.Files[a];
fileName = Path.GetFileName(file.FileName);
if (string.IsNullOrEmpty(fileName))
{
continue;
}
bool result = false;
string NewFileName = string.Empty;
string ServerPath = string.Empty;
string ErrorMsg = string.Empty;
string oldFileName = string.Empty; //舊文件名
//生成隨機數，用於圖片的重命名
Random rand = new Random();
int newRand = rand.Next(1000, 9999);
fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
NewFileName = newRand + fileExtention;
//判斷目錄是否存在，不存在則創建
CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'));
fileName = NewFileName;
NewFileName = localPromoPath + NewFileName;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
FTP ftp = new FTP(localPromoPath, ftpuser, ftppwd);
List<string> tem = ftp.GetFileList();
try
{
//上傳
FileManagement fileLoad = new FileManagement();
result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
if (result)//上傳成功
{
switch (a)
{
case 0:
cq.banner_image = fileName;
break;
case 1:
cq.category_image_in = fileName;
break;
case 2:
cq.category_image_out = fileName;
break;
case 3:
cq.category_image_app = fileName;
break;
default:
break;
}
}
else
{
//圖片上傳失敗則圖片名稱為原有圖片名稱
switch (a)
{
case 0:
cq.banner_image = fileName;
break;
case 1:
cq.category_image_in = fileName;
break;
case 2:
cq.category_image_out = fileName;
break;
case 3:
cq.category_image_app = fileName;
break;
default:
break;
}
errorInfo += "第" + (a + 1) + "張" + ErrorMsg + "<br/>";
}
}
catch (Exception ex)
{
Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name + "->fileLoad.UpLoadFile()", ex.Source, ex.Message);
logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
log.Error(logMessage);
jsonStr = "{success:false,msg:'圖片上傳失敗'}";
}
}
}
}
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);
jsonStr = "{success:false,msg:'圖片上傳失敗'}";
}
#endregion
if (!string.IsNullOrEmpty(Request.Params["comboFrontCage"]))
{
cq.category_father_id = Convert.ToUInt32(Request.Params["comboFrontCage"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["category_name"]))
{
cq.category_name = Request.Params["category_name"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["category_sort"]))
{
cq.category_sort = Convert.ToUInt32(Request.Params["category_sort"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["category_display"]))
{
cq.category_display = Convert.ToUInt32(Request.Params["category_display"]);
}
if (!string.IsNullOrEmpty(Request.Params["categorylinkmode"]))
{
cq.category_link_mode = Convert.ToUInt32(Request.Params["categorylinkmode"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["category_link_url"]))
{
cq.category_link_url = Request.Params["category_link_url"].ToString();
}
//if (!string.IsNullOrEmpty(Request.Params["photo"]))
//{
// #region 上傳圖片
// try
// {
// if (Request.Files.Count != 0)
// {
// 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_MinValue");
// 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 localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
// //生成隨機數，用於圖片的重命名
// Random rand = new Random();
// int newRand = rand.Next(1000, 9999);
// //獲取上傳的圖片
// HttpPostedFileBase file = Request.Files[0];
// string fileName = string.Empty;//當前文件名
// string fileExtention = string.Empty;//當前文件的擴展名
// fileName = Path.GetFileName(file.FileName);
// if (!string.IsNullOrEmpty(fileName))
// {
// bool result = false;
// string NewFileName = string.Empty;
// fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
// //NewFileName = pacdModel.event_id + newRand + fileExtention;//圖片重命名為event_id+4位隨機數+擴展名
// NewFileName = newRand + fileExtention;
// string ServerPath = string.Empty;
// //判斷目錄是否存在，不存在則創建
// CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'));
// // returnName += promoPath + NewFileName;
// fileName = NewFileName;
// NewFileName = localPromoPath + NewFileName;//絕對路徑
// ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
// string ErrorMsg = string.Empty;
// //上傳之前刪除已有的圖片
// //string oldFileName = olderpcmodel.banner_image;
// 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上的舊圖片
// // //DeletePicFile(ServerPath + oldFileName);//刪除本地圖片
// //}
// try
// {
// //上傳
// FileManagement fileLoad = new FileManagement();
// result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
// if (result)//上傳成功
// {
// cq.banner_image = fileName;
// }
// }
// catch (Exception ex)
// {
// Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
// logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name + "->fileLoad.UpLoadFile()", ex.Source, ex.Message);
// logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
// log.Error(logMessage);
// jsonStr = "{success:false,msg:'圖片上傳失敗'}";
// //pacdModel.banner_image = olderpcmodel.banner_image;
// }
// }
// else
// {
// //pacdModel.banner_image = olderpcmodel.banner_image;
// }
// }
// }
// 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);
// jsonStr = "{success:false,msg:'圖片上傳失敗'}";
// //pacdModel.banner_image = olderpcmodel.banner_image;
// }
// #endregion
//}
if (!string.IsNullOrEmpty(Request.Params["banner_status"]))
{
cq.banner_status = Convert.ToUInt32(Request.Params["banner_status"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["banner_link_mode"]))
{
cq.banner_link_mode = Convert.ToUInt32(Request.Params["banner_link_mode"].ToString());
}
if (!string.IsNullOrEmpty(Request.Params["banner_link_url"]))
{
cq.banner_link_url = Request.Params["banner_link_url"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["startdate"]))
{
cq.banner_show_start = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["startdate"].ToString()));
}
if (!string.IsNullOrEmpty(Request.Params["enddate"]))
{
cq.banner_show_end = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["enddate"].ToString()));
}
if (!string.IsNullOrEmpty(Request.Params["short_description"]))
{
cq.short_description = Request.Params["short_description"].ToString();
}
if (string.IsNullOrEmpty(Request.Params["category_id"]))
{
cq.category_ipfrom = CommonFunction.GetClientIP();
cq.category_createdate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")));
cq.category_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")));
cq.status = 1;
_proCategoryImplMgr = new CategoryMgr(mySqlConnectionString);
int i = _proCategoryImplMgr.ProductCategorySave(cq);
if (i > 0)
{
json = "{success:true}";
}
}
else
{
//_proCategoryImplMgr = new CategoryMgr(mySqlConnectionString);
//cq.category_id = Convert.ToUInt32(Request.Params["category_id"]);
//CategoryQuery oldCq = _proCategoryImplMgr.GetProductCategoryById(cq);
//if (!string.IsNullOrEmpty(Request.Params["comboFrontCage"]))
//{
// cq.category_father_id = Convert.ToUInt32(Request.Params["comboFrontCage"].ToString());
//}
//else
//{
// cq.category_father_id = oldCq.category_father_id;
//}
//if (!string.IsNullOrEmpty(Request.Params["category_name"]))
//{
// cq.category_name = Request.Params["category_name"].ToString();
//}
//else
//{
// cq.category_name = oldCq.category_name;
//}
//if (!string.IsNullOrEmpty(Request.Params["category_sort"]))
//{
// cq.category_sort = Convert.ToUInt32(Request.Params["category_sort"].ToString());
//}
//else
//{
// cq.category_sort = oldCq.category_sort;
//}
//if (!string.IsNullOrEmpty(Request.Params["category_display"]))
//{
// cq.category_display = Convert.ToUInt32(Request.Params["category_display"]);
//}
//else
//{
// cq.category_display = oldCq.category_display;
//}
//if (!string.IsNullOrEmpty(Request.Params["categorylinkmode"]))
//{
// cq.category_link_mode = Convert.ToUInt32(Request.Params["categorylinkmode"].ToString());
//}
//else
//{
// cq.category_link_mode = oldCq.category_link_mode;
//}
//cq.category_link_url = Request.Params["category_link_url"].ToString();
//if (!string.IsNullOrEmpty(Request.Params["photo"]))
//{
// #region 上傳圖片
// try
// {
// if (Request.Files.Count != 0)
// {
// 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_MinValue");
// 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 localPromoPath = imgLocalPath + promoPath;//圖片存儲地址
// 生成隨機數，用於圖片的重命名
// Random rand = new Random();
// int newRand = rand.Next(1000, 9999);
// 獲取上傳的圖片
// HttpPostedFileBase file = Request.Files[0];
// string fileName = string.Empty;//當前文件名
// string fileExtention = string.Empty;//當前文件的擴展名
// fileName = Path.GetFileName(file.FileName);
// if (!string.IsNullOrEmpty(fileName))
// {
// bool result = false;
// string NewFileName = string.Empty;
// fileExtention = fileName.Substring(fileName.LastIndexOf(".")).ToLower();
// NewFileName = pacdModel.event_id + newRand + fileExtention;//圖片重命名為event_id+4位隨機數+擴展名
// NewFileName = newRand + fileExtention;
// string ServerPath = string.Empty;
// 判斷目錄是否存在，不存在則創建
// CreateFolder(localPromoPath.Substring(0, localPromoPath.Length - promoPath.Length + 1), promoPath.Substring(1, promoPath.Length - 2).Split('/'));
// returnName += promoPath + NewFileName;
// fileName = NewFileName;
// NewFileName = localPromoPath + NewFileName;//絕對路徑
// ServerPath = Server.MapPath(imgLocalServerPath + promoPath);
// string ErrorMsg = string.Empty;
// 上傳之前刪除已有的圖片
// string oldFileName = oldCq.banner_image;
// 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上的舊圖片
// DeletePicFile(ServerPath + oldFileName);//刪除本地圖片
// }
// try
// {
// 上傳
// FileManagement fileLoad = new FileManagement();
// result = fileLoad.UpLoadFile(file, ServerPath, NewFileName, extention, int.Parse(maxValue), int.Parse(minValue), ref ErrorMsg, ftpuser, ftppwd);
// if (result)//上傳成功
// {
// cq.banner_image = fileName;
// }
// }
// catch (Exception ex)
// {
// Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage();
// logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name + "->fileLoad.UpLoadFile()", ex.Source, ex.Message);
// logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name;
// log.Error(logMessage);
// jsonStr = "{success:false,msg:'圖片上傳失敗'}";
// cq.banner_image = oldCq.banner_image;
// }
// }
// else
// {
// cq.banner_image = oldCq.banner_image;
// }
// }
// }
// 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);
// jsonStr = "{success:false,msg:'圖片上傳失敗'}";
// cq.banner_image = oldCq.banner_image;
// }
// #endregion
//}
//else
//{
// cq.banner_image = oldCq.banner_image;
//}
//if (!string.IsNullOrEmpty(Request.Params["banner_status"]))
//{
// cq.banner_status = Convert.ToUInt32(Request.Params["banner_status"].ToString());
//}
//else
//{
// cq.banner_status = oldCq.banner_status;
//}
//if (!string.IsNullOrEmpty(Request.Params["banner_link_mode"]))
//{
// cq.banner_link_mode = Convert.ToUInt32(Request.Params["banner_link_mode"].ToString());
//}
//else
//{
// cq.banner_link_mode = oldCq.banner_link_mode;
//}
//cq.banner_link_url = Request.Params["banner_link_url"].ToString();
//cq.short_description = Request.Params["short_description"].ToString();
//cq.banner_show_start = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["startdate"].ToString()));
//cq.banner_show_end = Convert.ToUInt32(CommonFunction.GetPHPTime(Request.Params["enddate"].ToString()));
cq.category_ipfrom = CommonFunction.GetClientIP();
cq.category_updatedate = Convert.ToUInt32(CommonFunction.GetPHPTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")));
int j = _proCategoryImplMgr.ProductCategorySave(cq);
if (j > 0)
{
json = "{success:true}";
}
}
}
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,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}