/// <summary> /// 修改 /// </summary> /// <param name="model">PromoShareMaster對象</param> /// <returns>更新結果</returns> public int Update(PromoShareMaster model) { int result = 0; model.Replace4MySQL(); StringBuilder sbSql = new StringBuilder(); sbSql.Append("set sql_safe_updates=0;"); if (model.eventId) { sbSql.AppendFormat("UPDATE promo_share_master set promo_event_id='{0}' WHERE promo_id='{1}';", model.promo_event_id, model.promo_id); } else { sbSql.AppendFormat("UPDATE promo_share_master set promo_name='{0}',promo_desc='{1}',promo_start='{2}',promo_end='{3}',promo_active='{4}' WHERE promo_id='{5}';", model.promo_name, model.promo_desc, CommonFunction.DateTimeToString(model.promo_start),CommonFunction.DateTimeToString(model.promo_end), model.promo_active, model.promo_id); } sbSql.Append("set sql_safe_updates=1;"); try { result = _access.execCommand(sbSql.ToString()); } catch (Exception ex) { throw new Exception("PromoShareMasterDao-->Update-->" + ex.Message + sbSql.ToString(), ex); } return result; }
public int UpdateActivePromoShareMaster(PromoShareMaster model) { try { return _PshareDao.UpdateActivePromoShareMaster(model); } catch (Exception ex) { throw new Exception("PromoShareMasterDao-->UpdateActivePromoShareMaster-->" + ex.Message, ex); } }
/// <summary> /// 新增 /// </summary> /// <param name="model">PromoShareMaster對象</param> /// <returns>新增后的標識</returns> public int Add(PromoShareMaster model) { try { return _PshareDao.Add(model); } catch (Exception ex) { throw new Exception("PromoShareMasterMgr-->Add-->" + ex.Message, ex); } }
/// <summary> /// 新增 /// </summary> /// <param name="model">PromoShareMaster對象</param> /// <returns>新增后的標識</returns> public int Add(PromoShareMaster model) { StringBuilder sbSql = new StringBuilder(); sbSql.Append("INSERT INTO promo_share_master(promo_name,promo_desc,promo_start,promo_end,promo_active) "); sbSql.AppendFormat(" VALUES('{0}','{1}','{2}','{3}','{4}');SELECT @@IDENTITY;", model.promo_name, model.promo_desc, CommonFunction.DateTimeToString(model.promo_start), CommonFunction.DateTimeToString(model.promo_end), model.promo_active); try { DataTable _dt = _access.getDataTable(sbSql.ToString()); if (_dt.Rows.Count > 0) { return Convert.ToInt32(_dt.Rows[0][0]); } else { return 0; } } catch (Exception ex) { throw new Exception("PromoShareMasterDao-->Add-->" + ex.Message + sbSql.ToString(), ex); } }
public JsonResult UpdateActivePromoShareMaster() { try { int row_id = 0; if (!string.IsNullOrEmpty(Request.Params["row_id"].ToString())) { row_id = Convert.ToInt32(Request.Params["row_id"].ToString()); } int activeValue = Convert.ToInt32(Request.Params["active"] ?? "0"); PshareMgr = new PromoShareMasterMgr(mySqlConnectionString); PromoShareMaster model = new PromoShareMaster(); model.promo_id = row_id; model.promo_active = activeValue; if (PshareMgr.UpdateActivePromoShareMaster(model) > 0) { return Json(new { success = "true" }); } else { return Json(new { success = "false" }); } } 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); return Json(new { success = "false" }); } }
//public HttpResponseBase EditPromoShareMaster() //{ // PromoShareMaster query = new PromoShareMaster(); // string json = string.Empty; // try // { // if (!string.IsNullOrEmpty(Request.Params["Epromo_id"])) // { // query.promo_id = Convert.ToInt32(Request.Params["Epromo_id"]); // } // if (!string.IsNullOrEmpty(Request.Params["Epromo_name"])) // { // query.promo_name = Request.Params["Epromo_name"]; // } // if (!string.IsNullOrEmpty(Request.Params["Epromo_desc"])) // { // query.promo_desc = Request.Params["Epromo_desc"]; // } // if (!string.IsNullOrEmpty(Request.Params["Epromo_start"])) // { // query.promo_start = Convert.ToDateTime(Request.Params["Epromo_start"]); // } // if (!string.IsNullOrEmpty(Request.Params["Epromo_end"])) // { // query.promo_end = Convert.ToDateTime(Request.Params["Epromo_end"]); // } // PshareMgr = new PromoShareMasterMgr(mySqlConnectionString); // if (PshareMgr.Update(query) > 0) // { // json = "{success:true}"; // } // else // { // json = "{success:false}"; // } // } // 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}"; // } // this.Response.Clear(); // this.Response.Write(json); // this.Response.End(); // return this.Response; //} #endregion #region 編輯 public HttpResponseBase updatePromoShareCon() { PromoShareMaster psmQuery = new PromoShareMaster(); PromoShareCondition pscQuery = new PromoShareCondition(); PshareMgr = new PromoShareMasterMgr(mySqlConnectionString); PshareConMgr = new PromoShareConditionMgr(mySqlConnectionString); string json = string.Empty; try { if (!string.IsNullOrEmpty(Request.Params["promo_name"])) { psmQuery.promo_name = Request.Params["promo_name"]; } if (!string.IsNullOrEmpty(Request.Params["promo_desc"])) { psmQuery.promo_desc = Request.Params["promo_desc"]; } if (!string.IsNullOrEmpty(Request.Params["promo_start"])) { psmQuery.promo_start = Convert.ToDateTime(Request.Params["promo_start"]); } if (!string.IsNullOrEmpty(Request.Params["promo_end"])) { psmQuery.promo_end = Convert.ToDateTime(Request.Params["promo_end"]); } if (!string.IsNullOrEmpty(Request.Params["promo_id"])) { psmQuery.promo_id = Convert.ToInt32(Request.Params["promo_id"]); } //判斷如果condition表內無此編號的數據則insert,如果有此編號的數據則update if (PshareMgr.PromoCon(psmQuery) == 0) {//執行新增 InsertIntoPromoShareCon(pscQuery);//插入promo_share_condition;新增入第二個面板 } else {//執行編輯 //編輯第一個面板 PshareMgr.Update(psmQuery); //1編輯第二個面板 promo_share_condition, //2將promo_share_condition表中對應promo_id數據刪除 //3然後再次insert PshareConMgr.Delete(psmQuery.promo_id); InsertIntoPromoShareCon(pscQuery); //PshareConMgr.Update(pscQuery); } json = "{success:true}"; } 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}"; } this.Response.Clear(); this.Response.Write(json); this.Response.End(); return this.Response; }
public int PromoCon(PromoShareMaster query) { try { return _PshareDao.PromoCon(query); } catch (Exception ex) { throw new Exception("PromoShareMasterMgr-->PromoCon-->"+ex.Message,ex); } }
/// <summary> /// 修改 /// </summary> /// <param name="model">PromoShareMaster對象</param> /// <returns>更新結果</returns> public int UpdateActivePromoShareMaster(PromoShareMaster model) { int result = 0; StringBuilder sbSql = new StringBuilder(); sbSql.Append("set sql_safe_updates=0;"); sbSql.AppendFormat("UPDATE promo_share_master set promo_active='{0}' WHERE promo_id='{1}';", model.promo_active, model.promo_id); sbSql.Append("set sql_safe_updates=1;"); try { result = _access.execCommand(sbSql.ToString()); } catch (Exception ex) { throw new Exception("PromoShareMasterDao-->UpdateActivePromoShareMaster-->" + ex.Message + sbSql.ToString(), ex); } return result; }
public int PromoCon(PromoShareMaster query) { StringBuilder sql = new StringBuilder(); try { sql.AppendFormat("select count(*) as totalCount from promo_share_condition where promo_id='{0}';",query.promo_id); DataTable _dt = _access.getDataTable(sql.ToString()); return Convert.ToInt32(_dt.Rows[0]["totalCount"]); } catch (Exception ex) { throw new Exception("PromoCon"); } }
/// <summary> /// 通過id獲取PromoShareMaster對象 /// </summary> /// <param name="promo_id">編號</param> /// <returns>PromoShareMaster對象</returns> public PromoShareMaster Get(int promo_id) { PromoShareMaster model = new PromoShareMaster(); string sql = "SELECT promo_id,promo_name,promo_desc,FROM_UNIXTIME(promo_start) as promo_start,FROM_UNIXTIME(promo_end) as promo_end,promo_active FROM promo_share_master WHERE promo_id=" + promo_id; try { model = _access.getSinggleObj<PromoShareMaster>(sql); } catch (Exception ex) { throw new Exception("PromoShareMasterDao-->Get-->" + ex.Message + sql, ex); } return model; }