/// <summary>
/// 修改記錄詳情
/// </summary>
/// <returns></returns>
public HttpResponseBase VendorChangeDetailList()
{
string json = "{success:false,data:0}";
try
{
TableChangeLogQuery query = new TableChangeLogQuery();
query.change_table = "vendor";
if (!string.IsNullOrEmpty(Request.Params["vendor_id"]))
{
query.pk_id = Convert.ToInt32(Request.Params["vendor_id"]);
}
if (!string.IsNullOrEmpty(Request.Params["muser"]))
{
query.create_user = Convert.ToInt32(Request.Params["muser"]);
}
if (!string.IsNullOrEmpty(Request.Params["mdate"]))
{
query.create_time = Convert.ToDateTime(Request.Params["mdate"]);
}
TableChangeLogMgr _tclMgr = new TableChangeLogMgr(connectionString);
BLL.gigade.Model.Custom.TableChangeLogCustom store = _tclMgr.GetVendorChangeDetail(query);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,data:" + JsonConvert.SerializeObject(store, 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);
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
/// <summary>
/// 異動記錄匯出
/// </summary>
/// <returns></returns>
public HttpResponseBase VendorLogExport()
{
string newCsvName = string.Empty;
string json = string.Empty;
TableChangeLogQuery query = new TableChangeLogQuery();
query.change_table = "vendor";
if (!string.IsNullOrEmpty(Request.Params["ven_type"]))
{
query.key_type = Convert.ToInt32(Request.Params["ven_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["d_type"]))
{
query.d_type = Convert.ToInt32(Request.Params["d_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["search_con"]))
{
query.key = Request.Params["search_con"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["date_one"]))
{
query.date_one = Convert.ToDateTime(Request.Params["date_one"]);
// query.date_one = Convert.ToDateTime(query.date_one.ToString("yyyy-MM-dd 00:00:00"));
}
if (!string.IsNullOrEmpty(Request.Params["date_two"]))
{
query.date_two = Convert.ToDateTime(Request.Params["date_two"]);
// query.date_two = Convert.ToDateTime(query.date_two.ToString("yyyy-MM-dd 23:59:59"));
}
TableChangeLogMgr _tclMgr = new TableChangeLogMgr(connectionString);
DataTable dt = _tclMgr.VendorLogExport(query);
try
{
string filename = "供應商資料異動記錄_" + 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, true);
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 VendorChangeList()
{
string json = "{success:false,data:0}";
try
{
TableChangeLogQuery query = new TableChangeLogQuery();
query.change_table = "vendor";
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");//用於分頁的變量
query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");//用於分頁的變量
if (!string.IsNullOrEmpty(Request.Params["ven_type"]))
{
query.key_type = Convert.ToInt32(Request.Params["ven_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["d_type"]))
{
query.d_type = Convert.ToInt32(Request.Params["d_type"]);
}
if (!string.IsNullOrEmpty(Request.Params["search_con"]))
{
query.key = Request.Params["search_con"].ToString();
}
if (!string.IsNullOrEmpty(Request.Params["date_one"]))
{
query.date_one = Convert.ToDateTime(Request.Params["date_one"]);
// query.date_one = Convert.ToDateTime(query.date_one.ToString("yyyy-MM-dd 00:00:00"));
}
if (!string.IsNullOrEmpty(Request.Params["date_two"]))
{
query.date_two = Convert.ToDateTime(Request.Params["date_two"]);
//query.date_two = Convert.ToDateTime(query.date_two.ToString("yyyy-MM-dd 23:59:59"));
}
// query.IsPage = false;
TableChangeLogMgr _tclMgr = new TableChangeLogMgr(connectionString);
int totalCount = 0;
DataTable store = _tclMgr.GetVendorChangeLog(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(store, 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);
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
