public static B2dDiscountCurrAmt GetDiscountCurrAmt(Int64 xid)
{
try
{
string sqlStmt = @"SELECT * FROM b2b.b2d_discount_curr_amt 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 currAmt = new B2dDiscountCurrAmt()
{
XID = dr.ToInt64("xid"),
MST_XID = dr.ToInt64("mst_xid"),
CURRENCY = dr.ToStringEx("currency"),
AMOUNT = dr.ToDouble("amount")
};
return(currAmt);
}
catch (Exception ex)
{
Website.Instance.logger.FatalFormat("{0},{1}", ex.Message, ex.StackTrace);
throw ex;
}
}
public IActionResult UpdateCurrAmt([FromBody] B2dDiscountCurrAmt dtl)
{
Dictionary <string, object> jsonData = new Dictionary <string, object>();
try
{
var upd_user = User.FindFirst("Account").Value;
var prsetRepos = HttpContext.RequestServices.GetService <PriceSettingRepository>();
// 新增公司與折扣規則對應
prsetRepos.UpdateCurrAmt(dtl, upd_user);
jsonData["status"] = "OK";
}
catch (Exception ex)
{
jsonData.Clear();
jsonData.Add("status", "FAIL");
jsonData.Add("msg", ex.Message);
}
return(Json(jsonData));
}
//////////////////////////
public static void InsertDiscountCurrAmnt(B2dDiscountCurrAmt cur_amt, string crt_user)
{
try
{
string sqlStmt = @"INSERT INTO b2b.b2d_discount_curr_amt(mst_xid, currency, amount, crt_user, crt_datetime)
VALUES (:mst_xid, :currency, :amount, :crt_user, now())";
NpgsqlParameter[] sqlParams = new NpgsqlParameter[] {
new NpgsqlParameter("mst_xid", cur_amt.MST_XID),
new NpgsqlParameter("currency", cur_amt.CURRENCY),
new NpgsqlParameter("amount", cur_amt.AMOUNT),
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 void UpdateDiscountCurrAmnt(B2dDiscountCurrAmt cur_amt, string upd_user)
{
try
{
string sqlStmt = @"UPDATE b2b.b2d_discount_curr_amt SET currency=:currency,
amount=:amount, upd_user=:upd_user, upd_datetime=now()
WHERE xid=:xid";
NpgsqlParameter[] sqlParams = new NpgsqlParameter[] {
new NpgsqlParameter("xid", cur_amt.XID),
new NpgsqlParameter("currency", cur_amt.CURRENCY),
new NpgsqlParameter("amount", cur_amt.AMOUNT),
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 void UpdateCurrAmt(B2dDiscountCurrAmt curr_amt, string upd_user)
{
DiscountDAL.UpdateDiscountCurrAmnt(curr_amt, upd_user);
}
public void InsertCurrAmt(B2dDiscountCurrAmt curr_amt, string crt_user)
{
DiscountDAL.InsertDiscountCurrAmnt(curr_amt, crt_user);
}
