public static void UpdateDiscountDtl(B2dDiscountDtl dtl, string upd_user) { try { string sqlStmt = @"UPDATE b2b.b2d_discount_dtl SET disc_type=:disc_type, disc_list=:disc_list, disc_list_name=:disc_list_name, whitelist=:whitelist, upd_user=:upd_user, upd_datetime=now() WHERE xid=:xid"; NpgsqlParameter[] sqlParams = new NpgsqlParameter[] { new NpgsqlParameter("xid", dtl.XID), new NpgsqlParameter("disc_type", dtl.DISC_TYPE), new NpgsqlParameter("disc_list", dtl.DISC_LIST), new NpgsqlParameter("disc_list_name", dtl.DISC_LIST_NAME), new NpgsqlParameter("whitelist", dtl.WHITELIST), new NpgsqlParameter("upd_user", upd_user) }; NpgsqlHelper.ExecuteNonQuery(Website.Instance.SqlConnectionString, CommandType.Text, sqlStmt, sqlParams); } catch (Exception ex) { Website.Instance.logger.FatalFormat("{0},{1}", ex.Message, ex.StackTrace); throw ex; } }
////////////////////////// public static void InsertDiscountDtl(B2dDiscountDtl dtl, string crt_user) { try { string sqlStmt = @"INSERT INTO b2b.b2d_discount_dtl(mst_xid, disc_type, disc_list, disc_list_name, whitelist, crt_user, crt_datetime) VALUES (:mst_xid, :disc_type, :disc_list, :disc_list_name, :whitelist, :crt_user, now())"; NpgsqlParameter[] sqlParams = new NpgsqlParameter[] { new NpgsqlParameter("mst_xid", dtl.MST_XID), new NpgsqlParameter("disc_type", dtl.DISC_TYPE), new NpgsqlParameter("disc_list", dtl.DISC_LIST), new NpgsqlParameter("disc_list_name", dtl.DISC_LIST_NAME), new NpgsqlParameter("whitelist", dtl.WHITELIST), new NpgsqlParameter("crt_user", crt_user) }; NpgsqlHelper.ExecuteNonQuery(Website.Instance.SqlConnectionString, CommandType.Text, sqlStmt, sqlParams); } catch (Exception ex) { Website.Instance.logger.FatalFormat("{0},{1}", ex.Message, ex.StackTrace); throw ex; } }
// 折扣明細清單 public static B2dDiscountDtl GetDiscountDtl(Int64 xid) { try { string sqlStmt = @"SELECT * FROM b2b.b2d_discount_dtl WHERE xid=:xid"; NpgsqlParameter[] sqlParams = new NpgsqlParameter[] { new NpgsqlParameter("xid", xid), }; var ds = NpgsqlHelper.ExecuteDataset(Website.Instance.SqlConnectionString, CommandType.Text, sqlStmt, sqlParams); DataRow dr = ds.Tables[0].Rows[0]; var dtl = new B2dDiscountDtl() { XID = dr.ToInt64("xid"), MST_XID = dr.ToInt64("mst_xid"), DISC_TYPE = dr.ToStringEx("disc_type"), DISC_LIST = dr.ToStringEx("disc_list"), DISC_LIST_NAME = dr.ToStringEx("disc_list_name"), WHITELIST = dr.ToStringEx("whitelist") }; return(dtl); } catch (Exception ex) { Website.Instance.logger.FatalFormat("{0},{1}", ex.Message, ex.StackTrace); throw ex; } }
public IActionResult UpdateDtl([FromBody] B2dDiscountDtl dtl) { Dictionary <string, object> jsonData = new Dictionary <string, object>(); try { var del_user = User.FindFirst("Account").Value; var prsetRepos = HttpContext.RequestServices.GetService <PriceSettingRepository>(); // 新增公司與折扣規則對應 prsetRepos.UpdateDtl(dtl, del_user); jsonData["status"] = "OK"; } catch (Exception ex) { jsonData.Clear(); jsonData.Add("status", "FAIL"); jsonData.Add("msg", ex.Message); } return(Json(jsonData)); }
public void UpdateDtl(B2dDiscountDtl dtl, string upd_user) { DiscountDAL.UpdateDiscountDtl(dtl, upd_user); }
public void InsertDtl(B2dDiscountDtl dtl, string crt_user) { DiscountDAL.InsertDiscountDtl(dtl, crt_user); }