/// <summary>
/// 導入Excel數據
/// </summary>
/// <returns></returns>
public HttpResponseBase AppCategoryUpExcel()
{
string json = string.Empty;//json字符串
int successcount = 0;
int failcount = 0;
int typeerror = 0;//要匯入的數據類型錯誤
try
{
if (Request.Files["ImportFileMsg"] != null && Request.Files["ImportFileMsg"].ContentLength > 0)//判斷文件是否為空
{
HttpPostedFileBase excelFile = Request.Files["ImportFileMsg"];//獲取文件流
FileManagement fileManagement = new FileManagement();//實例化 FileManagement
StringBuilder str = new StringBuilder();
string fileLastName = excelFile.FileName;
string newExcelName = Server.MapPath(excelPath) + "App功能管理" + fileManagement.NewFileName(excelFile.FileName);//處理文件名，獲取新的文件名
excelFile.SaveAs(newExcelName);//上傳文件
DataTable dt = new DataTable();
NPOI4ExcelHelper helper = new NPOI4ExcelHelper(newExcelName);
dt = helper.SheetData();//根據這個表,插入到數據庫中
DataRow[] dr = dt.Select(); //定义一个DataRow数组,读取ds里面所有行
_iappcategoryMgr = new AppcategoryMgr(mySqlConnectionString);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
Appcategory appCategory = new Appcategory();
try
{
appCategory.brand_id = Convert.ToInt32(dt.Rows[i]["brand_id"]);
appCategory.brand_name = dt.Rows[i]["brand_name"].ToString();
appCategory.category = dt.Rows[i]["category"].ToString();
appCategory.category1 = dt.Rows[i]["category1"].ToString();
appCategory.category2 = dt.Rows[i]["category2"].ToString();
appCategory.category3 = dt.Rows[i]["category3"].ToString();
appCategory.product_id = Convert.ToInt32(dt.Rows[i]["product_id"]);
appCategory.property = dt.Rows[i]["property"].ToString();
}
catch (Exception ex)
{
str.Append(i + 2 + " ");
failcount++;
continue;
}
int results= _iappcategoryMgr.AppcategorySave(appCategory);
if (results > 0)
{
successcount++;
}
else
{
str.Append(i + 2 + " ");
failcount++;
}
}
if (str.Length > 1)
{
str.Length -= 1;
json = "{success:true,total:" + successcount + ",fail:" + failcount + ",errorRow:\"" + str.ToString() + "\"}";
}
else
{
json = "{success:true,total:" + successcount + ",fail:" + failcount + "}";
}
}
else
{
json = "{success:false,msg:\"" + "此表內沒有數據或數據有誤,請檢查后再次匯入!" + "\"}";
}
}
else
{
json = "{success:false,msg:\"" + "請選擇要匯入的Excel表" + "\"}";
}
}
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,msg:\"" + ex.ToString() + "\"}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 獲取表單的數據
/// </summary>
/// <returns></returns>
public HttpResponseBase GetAppCategoryList()
{
List<Appcategory> stores = new List<Appcategory>();
string json = string.Empty;
try
{
Appcategory query = new Appcategory();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
if (!string.IsNullOrEmpty(Request.Form["category"]))//判斷館別是否為空
{
query.category = Request.Form["category"];
}
if (!string.IsNullOrEmpty(Request.Form["category1"]))//判斷分類一是否為空
{
query.category1 = Request.Form["category1"];
}
if (!string.IsNullOrEmpty(Request.Form["category2"]))
{
query.category2 = Request.Form["category2"];
}
if (!string.IsNullOrEmpty(Request.Form["category3"]))
{
query.category3 = Request.Form["category3"];
}
if (!string.IsNullOrEmpty(Request.Form["product_id"]))//判斷商品ID是否為空
{
query.product_id = int.Parse(Request.Form["product_id"]);
}
_iappcategoryMgr = new AppcategoryMgr(mySqlConnectionString);
int totalCount = 0;
stores = _iappcategoryMgr.GetAppcategoryList(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
//listUser是准备转换的对象
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(stores, Formatting.Indented, timeConverter) + "}";
//返回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:true,totalCount:0,data:[]}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 刪除數據
/// </summary>
/// <returns></returns>
public HttpResponseBase AppCategoryDelete()
{
string jsonStr = String.Empty;
_iappcategoryMgr = new AppcategoryMgr(mySqlConnectionString);
Appcategory query = new Appcategory();
if (!String.IsNullOrEmpty(Request.Params["rowid"]))
{
try
{
foreach (string rid in Request.Params["rowid"].ToString().Split('|'))
{
if (!string.IsNullOrEmpty(rid))
{
query.category_id = Convert.ToInt32(rid);
_iappcategoryMgr.AppcategoryDelete(query);
}
}
jsonStr = "{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);
jsonStr = "{success:false}";
}
}
this.Response.Clear();
this.Response.Write(jsonStr);
this.Response.End();
return this.Response;
}
/// <summary>
/// 查詢下拉框的參數數據
/// </summary>
/// <returns></returns>
public string QueryPara()
{
Appcategory appQuery = new Appcategory();
string json = string.Empty;
try
{
if (!string.IsNullOrEmpty(Request.QueryString["paraType"]))
{
_iappcategoryMgr = new AppcategoryMgr(mySqlConnectionString);
string para = Request.Params["paraType"].ToString();
appQuery.category = Request.Params["selectCondition"];
appQuery.category1 = Request.Params["select1Condition"];
appQuery.category2 = Request.Params["select2Condition"];
json = _iappcategoryMgr.GetParaList(para, appQuery);
}
}
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:true,totalCount:0,data:[]}";
}
return json;
}