public string Update(TicketMaster tm)
{
string json = string.Empty;
try
{
if (_tmDao.Update(tm) > 0)
{
json = "{success:true}";//返回json數據
}
else
{
json = "{success:false}";//返回json數據
}
return json;
}
catch (Exception ex)
{
throw new Exception("TicketMasterMgr-->Update" + ex.Message, ex);
}
}
public int Update(TicketMaster tm)
{
StringBuilder sql = new StringBuilder();
sql.AppendFormat(@"UPDATE ticket_master SET delivery_name='{0}',delivery_mobile='{1}',delivery_phone='{2}',", tm.delivery_name, tm.delivery_mobile, tm.delivery_phone);
sql.AppendFormat(@" delivery_zip='{0}',delivery_address='{1}' ", tm.delivery_zip, tm.delivery_address);
sql.AppendFormat(@" ,order_name='{0}',order_mobile='{1}',order_phone='{2}',", tm.order_name, tm.order_mobile, tm.order_phone);
sql.AppendFormat(@"order_zip='{0}',order_address='{1}' ", tm.order_zip, tm.order_address);
sql.AppendFormat(@" WHERE ticket_master_id='{0}'; ", tm.ticket_master_id);
try
{
return _access.execCommand(sql.ToString());
}
catch (Exception ex)
{
throw new Exception("TicketMasterDao-->Update" + ex.Message + sql.ToString(), ex);
}
}
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"]);
}
json = _ITicketMaster.Update(tm);
}
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;
}
