public int UpdateMHS(Tab_MHSale m)
{
var sql = @"UPDATE [Tab_MHSale]
SET [F_SaleType] = @F_SaleType
,[F_Price] = @F_Price
WHERE [F_Id] = @F_Id
AND [F_SaleType] = @F_SaleType2";
var sql1 = "SELECT COUNT(*) FROM [Tab_MHSale] WHERE [F_Id] = @F_Id AND [F_SaleType] = @F_SaleType";
using (SqlConnection conn = new SqlConnection(MHConncetionString))
{
conn.Open();
if (m.SaleType == m.F_SaleType)
{
return(conn.Execute(sql, new
{
F_SaleType = m.F_SaleType,
F_Price = m.F_Price,
F_Id = m.F_Id,
F_SaleType2 = m.SaleType,
}));
}
else
{
using (SqlTransaction tran = conn.BeginTransaction(IsolationLevel.RepeatableRead))
{
var a = conn.ExecuteScalar(sql1, new { F_Id = m.F_Id, F_SaleType = m.F_SaleType }, tran);
if (0 == Convert.ToInt32(a))
{
int r = conn.Execute(sql, new
{
F_SaleType = m.F_SaleType,
F_Price = m.F_Price,
F_Id = m.F_Id,
F_SaleType2 = m.SaleType,
}, tran);
if (r == 1)
{
tran.Commit();
return(1);
}
}
if (Convert.ToInt32(a) > 0)
{
tran.Rollback();
return(2);
}
}
}
}
return(0);
}
public int DeleteMHS(Tab_MHSale m)
{
var sql = "DELETE FROM [Tab_MHSale] WHERE [F_Id] = @F_Id AND [F_SaleType] = @F_SaleType";
using (SqlConnection conn = new SqlConnection(MHConncetionString))
{
return(conn.Execute(sql, new
{
F_Id = m.F_Id,
F_SaleType = m.F_SaleType,
}));
}
}
public int AddMHSale(Tab_MHSale m)
{
var sql = @"INSERT INTO [Tab_MHSale]
([F_Id]
,[F_SaleType]
,[F_Price]
,[F_CreateDate])
VALUES
(@F_Id
,@F_SaleType
,@F_Price
,@F_CreateDate)";
var sql1 = "SELECT COUNT(*) FROM [Tab_MHSale] WHERE [F_Id] = @F_Id AND [F_SaleType] = @F_SaleType";
using (SqlConnection conn = new SqlConnection(MHConncetionString))
{
conn.Open();
using (SqlTransaction tran = conn.BeginTransaction(IsolationLevel.RepeatableRead))
{
var a = conn.ExecuteScalar(sql1, new { F_Id = m.F_Id, F_SaleType = m.F_SaleType }, tran);
if (0 == Convert.ToInt32(a))
{
int r = conn.Execute(sql, new
{
F_Id = m.F_Id,
F_SaleType = m.F_SaleType,
F_Price = m.F_Price,
F_CreateDate = DateTime.Now,
}, tran);
if (r == 1)
{
tran.Commit();
return(1);
}
}
if (Convert.ToInt32(a) > 0)
{
tran.Rollback();
return(2);
}
}
}
return(0);
}
public ActionResult Delete()
{
var a = Request.QueryString["id"]; // 漫画id
var b = Request.QueryString["sid"]; // 收费方式id
var mhid = 0;
var sid = 0;
if (!int.TryParse(a, out mhid) || mhid == 0)
{
return(Json(new DWZJson()
{
statusCode = (int)DWZStatusCode.ERROR, message = "漫画不存在"
}));
}
if (!int.TryParse(b, out sid) || sid == 0)
{
return(Json(new DWZJson()
{
statusCode = (int)DWZStatusCode.ERROR, message = "收费方式不存在"
}));
}
Tab_MHSale m = new Tab_MHSale();
m.F_Id = mhid;
m.F_SaleType = sid;
int i = _ss.DeleteMHS(m);
if (i == 1)
{
return(Json(new DWZJson {
statusCode = (int)DWZStatusCode.OK, message = "成功"
}));
}
else
{
return(Json(new DWZJson {
statusCode = (int)DWZStatusCode.ERROR, message = "失败"
}));
}
}
public Tab_MHSale GetHMSale(int id, int sid)
{
var sql = "SELECT F_Id, F_SaleType, F_Price FROM dbo.Tab_MHSale WHERE F_Id = @F_Id AND F_SaleType = @F_SaleType";
using (SqlConnection conn = new SqlConnection(MHConncetionString))
{
var list = conn.Query <Tab_MHSale>(sql, new { F_Id = id, F_SaleType = sid }).ToList();
if (list != null && list.Count > 0)
{
Tab_MHSale g = new Tab_MHSale();
g.F_Id = list[0].F_Id;
g.F_SaleType = list[0].F_SaleType;
g.F_Price = list[0].F_Price;
return(g);
}
}
return(null);
}
public int DeleteMHS(Tab_MHSale m)
{
return(sr.DeleteMHS(m));
}
public int UpdateMHS(Tab_MHSale m)
{
return(sr.UpdateMHS(m));
}
public int AddMHSale(Tab_MHSale m)
{
return(sr.AddMHSale(m));
}
public ActionResult Add()
{
var a = Request.Form["gid"]; // 公众号名称
var b = Request.Form["mhid"]; // 漫画名称
var c = Request.Form["st"]; // 收费类型
var d = Request.Form["sid"]; // 收费方式
var e = Request.Form["price"]; // 收费价格
var gid = 0;
var mhid = 0;
var st = 0;
var sid = 0;
var price = 0;
if (!int.TryParse(a, out gid) || gid == 0)
{
return(Json(new DWZJson()
{
statusCode = (int)DWZStatusCode.ERROR, message = "请选择公众号名称"
}));
}
if (!int.TryParse(b, out mhid) || mhid == 0)
{
return(Json(new DWZJson()
{
statusCode = (int)DWZStatusCode.ERROR, message = "请选择漫画"
}));
}
if (!int.TryParse(c, out st) || st == 0)
{
return(Json(new DWZJson()
{
statusCode = (int)DWZStatusCode.ERROR, message = "请选择收费类型"
}));
}
if (!int.TryParse(d, out sid) || sid == 0)
{
return(Json(new DWZJson()
{
statusCode = (int)DWZStatusCode.ERROR, message = "请选择收费方式"
}));
}
if (!int.TryParse(e, out price) || price == 0)
{
return(Json(new DWZJson()
{
statusCode = (int)DWZStatusCode.ERROR, message = "请填写收费价格"
}));
}
Tab_MHSale m = new Tab_MHSale();
m.F_Id = mhid;
m.F_SaleType = sid;
m.F_Price = price;
int i = _ss.AddMHSale(m);
if (i == 1)
{
return(Json(new DWZJson {
statusCode = (int)DWZStatusCode.OK, message = "成功"
}));
}
else if (i == 2)
{
return(Json(new DWZJson {
statusCode = (int)DWZStatusCode.ERROR, message = "漫画和收费方式已经添加过"
}));
}
else
{
return(Json(new DWZJson {
statusCode = (int)DWZStatusCode.ERROR, message = "失败"
}));
}
}
