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