public HttpResponseBase Import() { string json = string.Empty; try { EdmGroupEmailQuery query = new EdmGroupEmailQuery(); if (!string.IsNullOrEmpty(Request.Params["ImportCsv"])) { query.group_id = Convert.ToUInt32(Request.Params["group_id"]); HttpPostedFileBase file = Request.Files["ImportCsv"]; FileManagement fileManagement = new FileManagement(); string fileName = fileManagement.NewFileName(file.FileName); string newFileName = Server.MapPath(excelPath_export) + fileName; file.SaveAs(newFileName); DataTable _dt = CsvHelper.ReadCsvToDataTable_CN(newFileName, true); _edmGroup = new EdmGroupMgr(mySqlConnectionString); json = _edmGroup.Import(_dt, query); } } 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 Export() { string json = string.Empty; try { EdmGroup query = new EdmGroup(); if (!string.IsNullOrEmpty(Request.Params["group_id"])) { query.group_id = Convert.ToUInt32(Request.Params["group_id"]); } _edmGroup = new EdmGroupMgr(mySqlConnectionString); DataTable _dt = _edmGroup.Export(query); string fileName = DateTime.Now.ToString("yyyyMMdd_HHmmss") + "." + "csv"; DataTable _newdt = new DataTable(); DataRow dr; _newdt.Columns.Add("電子信箱", typeof(string)); _newdt.Columns.Add("訂閱狀態", typeof(string)); _newdt.Columns.Add("姓名", typeof(string)); for (int i = 0; i < _dt.Rows.Count; i++) { dr = _newdt.NewRow(); _newdt.Rows.Add(dr); _newdt.Rows[i]["電子信箱"] = _dt.Rows[i]["email_address"]; _newdt.Rows[i]["姓名"] = _dt.Rows[i]["email_name"]; uint email_status = Convert.ToUInt32(_dt.Rows[i]["email_status"].ToString()); if (email_status == 1) { _newdt.Rows[i]["訂閱狀態"] = "已訂閱"; } else { _newdt.Rows[i]["訂閱狀態"] = "未訂閱"; } } StringWriter sw = ExcelHelperXhf.SetCsvFromData(_newdt, fileName); Response.Clear(); Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName); Response.ContentType = "application/ms-excel"; Response.ContentEncoding = Encoding.Default; Response.Write(sw); Response.End(); } 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 SaveEdmGroup() { EdmGroup query = new EdmGroup(); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Params["group_id"])) { query.group_id = Convert.ToUInt32(Request.Params["group_id"]); } if (!string.IsNullOrEmpty(Request.Params["group_name"])) { query.group_name = (Request.Params["group_name"]); } _edmGroup = new EdmGroupMgr(mySqlConnectionString); json = _edmGroup.SaveEdmGroup(query); } 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 DeleteEdmGroup() { string json = string.Empty; EdmGroup query = null; _edmGroup = new EdmGroupMgr(mySqlConnectionString); List<EdmGroup> list = new List<EdmGroup>(); try { if (!string.IsNullOrEmpty(Request.Form["rowID"])) { string rowIDs = Request.Form["rowID"]; if (rowIDs.IndexOf("|") != -1) { foreach (string id in rowIDs.Split('|')) { if (!string.IsNullOrEmpty(id)) { query = new EdmGroup(); query.group_id = Convert.ToUInt32(id); list.Add(query); } } } json = _edmGroup.DeleteEdmGroup(list); } } 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 GetEdmGroupList() { List<EdmGroup> store = new List<EdmGroup>(); EdmGroup query = new EdmGroup(); int totalCount = 0; string json = string.Empty; query.Start = Convert.ToInt32(Request.Params["start"] ?? "0"); query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25"); if (!string.IsNullOrEmpty(Request.Params["selectType"])) { query.selectType = Request.Params["selectType"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["search_con"])) { query.search_con = Request.Params["search_con"].ToString(); } if (!string.IsNullOrEmpty(Request.Params["dateType"])) { query.dateCondition = Convert.ToInt32(Request.Params["dateType"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["timestart"])) { query.start = (uint)CommonFunction.GetPHPTime(Request.Params["timestart"].ToString()); } if (!string.IsNullOrEmpty(Request.Params["timeend"])) { query.end = (uint)CommonFunction.GetPHPTime(Request.Params["timeend"].ToString()); } try { _edmGroup = new EdmGroupMgr(mySqlConnectionString); store = _edmGroup.GetEdmGroupList(query, out totalCount); IsoDateTimeConverter timeConverter = new IsoDateTimeConverter(); timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss"; json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, Formatting.Indented, timeConverter) + "}"; } 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,totalCount:0,data:[]}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }