// 取得折扣主規則 public static B2dDiscountMst GetDiscountMst(Int64 xid) { List <B2dDiscountMst> mst_list = new List <B2dDiscountMst>(); try { string sqlStmt = @"SELECT * FROM b2b.b2d_discount_mst 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 mst = new B2dDiscountMst() { XID = dr.ToInt64("xid"), DISC_NAME = dr.ToStringEx("disc_name"), DISC_PERCENT = dr.ToDouble("disc_percent"), DISC_TYPE = dr.ToStringEx("disc_type"), S_DATE = dr.ToDateTimeEx("s_date"), E_DATE = dr.ToDateTimeEx("e_date"), STATUS = dr.ToStringEx("status"), RULE_STATUS = dr.ToStringEx("rule_status") }; return(mst); } catch (Exception ex) { Website.Instance.logger.FatalFormat("{0},{1}", ex.Message, ex.StackTrace); throw ex; } }
public static void UpdateDiscountMst(B2dDiscountMst mst, string upd_user) { try { string sqlStmt = @"UPDATE b2b.b2d_discount_mst SET disc_name=:disc_name, disc_type=:disc_type, s_date=:s_date, e_date=:e_date, status=:status, disc_percent=:disc_percent, rule_status=:rule_status, upd_user=:upd_user, upd_datetime=now() WHERE xid=:xid"; NpgsqlParameter[] sqlParams = new NpgsqlParameter[] { new NpgsqlParameter("disc_name", mst.DISC_NAME), new NpgsqlParameter("disc_type", mst.DISC_TYPE), new NpgsqlParameter("s_date", mst.S_DATE), new NpgsqlParameter("e_date", mst.E_DATE), new NpgsqlParameter("status", mst.STATUS), new NpgsqlParameter("disc_percent", mst.DISC_PERCENT), new NpgsqlParameter("rule_status", mst.RULE_STATUS), new NpgsqlParameter("xid", mst.XID), 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 InsertDiscountMst(B2dDiscountMst mst, string crt_user) { try { string sqlStmt = @"INSERT INTO b2b.b2d_discount_mst(disc_name, disc_type, s_date, e_date, status, disc_percent, rule_status, crt_user, crt_datetime) VALUES (:disc_name, :disc_type, :s_date, :e_date, :status, :disc_percent, :rule_status, :crt_user, now()) "; NpgsqlParameter[] sqlParams = new NpgsqlParameter[] { new NpgsqlParameter("disc_name", mst.DISC_NAME), new NpgsqlParameter("disc_type", mst.DISC_TYPE), new NpgsqlParameter("s_date", mst.S_DATE), new NpgsqlParameter("e_date", mst.E_DATE), new NpgsqlParameter("status", mst.STATUS), new NpgsqlParameter("disc_percent", mst.DISC_PERCENT), new NpgsqlParameter("rule_status", mst.RULE_STATUS), 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 IActionResult InsertMst([FromBody] B2dDiscountMst mst) { Dictionary <string, object> jsonData = new Dictionary <string, object>(); try { var crt_user = User.Identities.SelectMany(i => i.Claims.Where(c => c.Type == "Account").Select(c => c.Value)).FirstOrDefault(); var prsetRepos = HttpContext.RequestServices.GetService <PriceSettingRepository>(); // 新增公司與折扣規則對應 prsetRepos.InsertMst(mst, crt_user); jsonData["status"] = "OK"; } catch (Exception ex) { jsonData.Clear(); jsonData.Add("status", "FAIL"); jsonData.Add("msg", ex.Message); } return(Json(jsonData)); }
public void UpdateMst(B2dDiscountMst mst, string upd_user) { DiscountDAL.UpdateDiscountMst(mst, upd_user); }
public void InsertMst(B2dDiscountMst mst, string crt_user) { DiscountDAL.InsertDiscountMst(mst, crt_user); }