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