// 取得折扣主規則
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);
}
