public static string GetExcelData() { try { SalesDetailBLL sdBLL = new SalesDetailBLL(); DataTable dt; string jsonString = string.Empty; dt = sdBLL.GetSalesDatailData(); // Convert to json string and Dispose if (dt != null) { //jsonString = JsonHelper.JsonSerializer(dt); jsonString = JsonHelper.DataTableToJson(dt); dt.Dispose(); dt = null; } // sdBLL = null; //TextBox1.Text = jsonString; if (!string.Equals(jsonString, string.Empty)) { return(jsonString); } else { return("[]"); } } catch (Exception ex) { throw ex; } }
public static string GetData() { //try //{ SalesDetailBLL sdBLL = new SalesDetailBLL(); DataTable dt; string jsonString = string.Empty; dt = sdBLL.GetSalesDatailData(); // Convert to json string and Dispose //if (dt != null) //{ jsonString = JsonHelper.DataTableToJson(dt); // dt.Dispose(); // dt = null; //} // sdBLL = null; //TextBox1.Text = jsonString; if (!string.Equals(jsonString, string.Empty)) { return(jsonString); } else { return(""); } //} //catch (Exception) //{ // throw; //} }
public static string QueryGrid(string dateFrom, string dateTo, string prodGroup, string cityName, string storeNo) { try { //if (initFlag == "Y") // return "[]"; SalesDetailBLL sdBLL = new SalesDetailBLL(); DataTable dt; string jsonString = string.Empty; dt = sdBLL.GetSalesDatailData(dateFrom, dateTo, prodGroup, cityName, storeNo); // Convert to json string and Dispose if (dt != null) { //jsonString = JsonHelper.JsonSerializer(dt); jsonString = JsonHelper.DataTableToJson(dt); dt.Dispose(); dt = null; } // sdBLL = null; //TextBox1.Text = jsonString; if (!string.Equals(jsonString, string.Empty)) { return(jsonString); } else { return("[]"); } } catch (Exception ex) { LogHelper.Error(ex.Message, ex); throw; } }