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