/// <summary>
/// 訂單詳情頁面列表核銷功能
/// </summary>
/// <returns></returns>
public HttpResponseBase UpdateTicketStatus()
{
//更改course_ticket表中的flag欄位
string json = string.Empty;
try
{
string Row_id = "";
if (!string.IsNullOrEmpty(Request.Params["rowId"]))
{
Row_id = Request.Params["rowId"];
Row_id = Row_id.TrimEnd(',');
//query.map_id_in = Row_id;
}
_ITicketDetail = new TicketDetailMgr(mySqlConnectionString);
int result = _ITicketDetail.UpdateTicketStatus(Row_id);
if (result > 0)
{
json = "{success:true,msg:\"" + result + "\"}";
}
else
{
json = "{success:false,msg:\"" + result + "\"}";
}
}
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:'0'}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
public HttpResponseBase GetUploadArchives()
{
string json = string.Empty;
try
{
#region 上傳
string ErrorMsg = string.Empty;
string path = Server.MapPath(xmlPath);
SiteConfigMgr _siteConfigMgr = new SiteConfigMgr(path);
SiteConfig extention_config = _siteConfigMgr.GetConfigByName("PIC_Extention_Format");
SiteConfig admin_userName = _siteConfigMgr.GetConfigByName("ADMIN_USERNAME");
SiteConfig admin_passwd = _siteConfigMgr.GetConfigByName("ADMIN_PASSWD");
//擴展名、最小值、最大值
string extention = extention_config.Value == "" ? extention_config.DefaultValue : extention_config.Value;
string fileName = string.Empty;//當前文件名
_ITicketDetail = new TicketDetailMgr(mySqlConnectionString);
FileManagement fileLoad = new FileManagement();
if (Request.Files.Count > 0)
{
HttpPostedFileBase file = Request.Files[0];
string fileExtention = string.Empty;//當前文件的擴展名
string oldFileName = file.FileName.Substring(0, file.FileName.LastIndexOf('.'));
fileName = fileLoad.NewFileName(file.FileName);
if (fileName != "")
{
string filepathday = fileName.Substring(0, fileName.LastIndexOf("."));//每天建立一個文件夾保存村的文件;
fileName = oldFileName + "_" + filepathday;//上傳文檔為以前的名字+年月日時分秒.後綴名
filepathday = filepathday.Substring(0, 8);
fileExtention = file.FileName.Substring(file.FileName.LastIndexOf('.')).ToLower().ToString();
// string NewFileName = string.Empty;
BLL.gigade.Common.HashEncrypt hash = new BLL.gigade.Common.HashEncrypt();
// NewFileName = hash.Md5Encrypt(fileName, "32");
string ServerPath = string.Empty;
FTP f_cf = new FTP();
archives = archives + filepathday + "/";//創建多層路徑
string localPromoPath = imgLocalPath + archives;//圖片存儲地址
f_cf.MakeMultiDirectory(localPromoPath.Substring(0, localPromoPath.Length - archives.Length + 1), archives.Substring(1, archives.Length - 2).Split('/'), ftpuser, ftppwd);
// fileName = NewFileName + fileExtention;
fileName = localPromoPath + fileName + fileExtention;//絕對路徑
ServerPath = Server.MapPath(imgLocalServerPath + archives);
Resource.CoreMessage = new CoreResource("Product");//尋找product.resx中的資源文件
bool result = _ITicketDetail.UpLoadFile(file, ServerPath, fileName, extention, (int.MaxValue / 1024) - 1, 0, ref ErrorMsg, ftpuser, ftppwd);
if (result)
{
json = "{\"success\":\"true\"}";
}
else
{
json = "{\"success\":\"false\",\"msg\":\"上傳失败\"}";
}
}
}
#endregion
}
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\":\"參數出錯\"}";
}
this.Response.Clear();
this.Response.Write(json);
this.Response.End();
return this.Response;
}
//#region 課程訂單列表頁
//public HttpResponseBase GetTicketMasterList()
//{
// string json = string.Empty;
// int tranInt = 0;
// try
// {
// TicketMasterQuery query = new TicketMasterQuery();
// query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
// query.Limit = Convert.ToInt32(Request.Params["limit"] ?? "25");
// int totalCount = 0;
// _ITicketMaster = new TicketMasterMgr(mySqlConnectionString);
// if (!string.IsNullOrEmpty(Request.Params["order_status"]))
// {
// query.order_status = int.Parse(Request.Params["order_status"]);
// }
// else
// {
// query.order_status = -1;
// }
// if (!string.IsNullOrEmpty(Request.Params["order_payment"]))
// {
// query.order_payment = int.Parse(Request.Params["order_payment"]);
// }
// else
// {
// query.order_payment = -1;
// }
// if (!string.IsNullOrEmpty(Request.Params["order_id"]))
// {
// query.ticket_master_id = int.Parse(Request.Params["order_id"]);
// }
// query.order_name = Request.Params["order_name"];
// if (!string.IsNullOrEmpty(Request.Params["ticket_start"]))
// {
// query.order_start = (int)CommonFunction.GetPHPTime(Request.Params["ticket_start"]);
// }
// if (!string.IsNullOrEmpty(Request.Params["ticket_end"]))
// {
// query.order_end = (int)CommonFunction.GetPHPTime(Request.Params["ticket_end"].Substring(0, 10) + " 23:59:59");
// }
// if (!string.IsNullOrEmpty(Request.Params["bill_check"]))
// {
// query.billing_checked = int.Parse(Request.Params["bill_check"]);
// }
// if (!string.IsNullOrEmpty(Request.Params["course_search"]))
// {
// if (int.TryParse(Request.Params["course_search"], out tranInt))
// {
// query.course_id = tranInt;
// }
// else
// {
// query.course_name = Request.Params["course_search"];
// }
// }
// if (!string.IsNullOrEmpty(Request.Params["course_start"]))
// {
// query.start_date = DateTime.Parse(Request.Params["course_start"]);
// }
// if (!string.IsNullOrEmpty(Request.Params["course_end"]))
// {
// query.end_date = DateTime.Parse(Request.Params["course_end"].Substring(0, 10) + " 23:59:59");
// }
// DataTable dtTicketMaster = _ITicketMaster.GetTicketMasterList(query, out totalCount);
// IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
// //这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
// timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
// json = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(dtTicketMaster, 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:false,msg:0}";
// }
// this.Response.Clear();
// this.Response.Write(json);
// this.Response.End();
// return this.Response;
//}
//public HttpResponseBase UpdateTicketMaster()
//{
// string json = string.Empty;
// try
// {
// TicketMaster tm = new TicketMaster();
// _ITicketMaster = new TicketMasterMgr(mySqlConnectionString);
// if (Request.Params["ticket_master_id"] != "0")
// {
// tm.ticket_master_id = int.Parse(Request.Params["ticket_master_id"]);
// }
// tm.delivery_name = Request.Params["delivery_name"];
// tm.delivery_mobile = Request.Params["delivery_mobile"];
// tm.delivery_phone = Request.Params["delivery_phone"];
// tm.delivery_address = Request.Params["delivery_address"];
// if (!string.IsNullOrEmpty(Request.Params["delivery_zip"]))
// {
// tm.delivery_zip = int.Parse(Request.Params["delivery_zip"]);
// }
// tm.order_name = Request.Params["order_name"];
// tm.order_mobile = Request.Params["order_mobile"];
// tm.order_phone = Request.Params["order_phone"];
// tm.order_address = Request.Params["order_address"];
// if (!string.IsNullOrEmpty(Request.Params["order_zip"]))
// {
// tm.order_zip = int.Parse(Request.Params["order_zip"]);
// }
// int i = _ITicketMaster.Update(tm);
// if (i > 0)
// {
// json = "{success:true}";//返回json數據
// }
// else
// {
// json = "{success:false}";//返回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:false,msg:0}";
// }
// this.Response.Clear();
// this.Response.Write(json);
// this.Response.End();
// return this.Response;
//}
//#endregion
#region 課程訂購單明細表
/// <summary>
/// 訂單詳情頁面列表
/// </summary>
/// <returns></returns>
public HttpResponseBase GetTicketDetailList()
{
string jsonStr = string.Empty;
try
{
TicketDetailQuery query = new TicketDetailQuery();
query.Start = Convert.ToInt32(Request.Params["start"] ?? "0");
if (!string.IsNullOrEmpty(Request.Params["limit"]))
{
query.Limit = Convert.ToInt32(Request.Params["limit"]);
}
query.flag = -1;
if (!string.IsNullOrEmpty(Request.Params["Search"]))
{
query.flag = int.Parse(Request.Params["Search"]);
}
if (!string.IsNullOrEmpty(Request.Params["MasterID"]))
{
query.MDID = int.Parse(Request.Params["MasterID"]);
}
if (!string.IsNullOrEmpty(Request.Params["TimeStart"]))
{
query.TimeStart = DateTime.Parse(Request.Params["TimeStart"]).ToString("yyyy/MM/dd 00:00:00");
}
if (!string.IsNullOrEmpty(Request.Params["TimeEnd"]))
{
query.TimeEnd = DateTime.Parse(Request.Params["TimeEnd"]).ToString("yyyy/MM/dd 23:59:59");
}
long a = CommonFunction.GetPHPTime("2014-02-01 00:00:00");
long s = CommonFunction.GetPHPTime("2014-02-28 23:29:59");
int totalCount = 0;
_ITicketDetail = new TicketDetailMgr(mySqlConnectionString);
DataTable _dt = _ITicketDetail.GetTicketDetailTable(query, out totalCount);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter();
//这里使用自定义日期格式，如果不使用的话，默认是ISO8601格式
timeConverter.DateTimeFormat = "yyyy-MM-dd HH:mm:ss";
jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(_dt, 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);
jsonStr = "{success:false,msg:0}";
}
this.Response.Clear();
this.Response.Write(jsonStr.ToString());
this.Response.End();
return this.Response;
}
