public JsonResult Save(Wjtc model)
{
ReturnModel returnModel;
if (model.ID.Equals(0))
{
returnModel = wjtcService.Insert(model);
return(Json(returnModel, JsonRequestBehavior.AllowGet));
}
returnModel = wjtcService.Update(model);
return(Json(returnModel, JsonRequestBehavior.AllowGet));
}
public ActionResult AddOrEdit(int id = 0, string yybh = "")
{
Wjtc tc = new Wjtc();
if (id > 0)
{
tc = wjtcService.GetEntity(id);
}
//套餐选项
var tcxx = wjtcService.GetTcSelect(yybh);
ViewBag.Tcxx = tcxx;
//标签选项
var bqxx = new WjbqService().GetAllList();
ViewBag.Bqxx = bqxx;
ViewBag.Yybh = yybh;
return(View(tc));
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public ReturnModel Update(Wjtc model)
{
try
{
if (string.IsNullOrWhiteSpace(model.TCID))
{
return(new ReturnModel {
Code = 201, Msg = "套餐不能为空"
});
}
StringBuilder sbSql = new StringBuilder();
using (IDbConnection conn = new DapperConnection().DbConnection)
{
var transaction = conn.BeginTransaction();
try
{
//判断存在
sbSql.Append("SELECT * FROM WJ_TC WHERE Id=@Id AND SFQY=1");
Wjbq existModel = conn.QueryFirstOrDefault <Wjbq>(sbSql.ToString(), new { Id = model.ID }, transaction);
if (existModel == null)
{
return(new ReturnModel {
Code = 201, Msg = "标签不存在"
});
}
//判断重名
sbSql.Clear();
sbSql.Append("SELECT * FROM WJ_TC WHERE ID<>@ID AND TCID=@TCID and SFQY=1");
Wjbq sameName = conn.QueryFirstOrDefault <Wjbq>(sbSql.ToString(), model, transaction);
if (sameName != null)
{
return(new ReturnModel {
Code = 201, Msg = "存在相同名称的套餐"
});
}
//保存更新
sbSql.Clear();
model.SFQY = 1;
sbSql.Append("UPDATE WJ_TC SET TCID = @TCID, SYRQ = @SYRQ, TCZY = @TCZY, SFQY = @SFQY WHERE ID = @ID;");
sbSql.Append("DELETE FROM WJ_TCBQ WHERE GLID = @ID;");
conn.Execute(sbSql.ToString(), model, transaction);
if (!string.IsNullOrWhiteSpace(model.BQIDS))
{
//标签列表
List <string> lstBq = model.BQIDS.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList();
//深度列表
List <string> lstSd = model.BQSDS.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList();
foreach (var item in lstBq)
{
var sd = lstSd[lstBq.IndexOf(item)];
sbSql.Clear();
sbSql.Append("INSERT INTO WJ_TCBQ(GLID, BQID, JCSD) VALUES (@GLID, @BQID, @JCSD)");
conn.Execute(sbSql.ToString(), new { GLID = model.ID, BQID = item, JCSD = sd }, transaction);
}
}
transaction.Commit();
return(new ReturnModel {
Code = 200, Msg = "保存成功"
});
}
catch (Exception e)
{
transaction.Rollback();
Log.WriteLog(e.Message);
return(new ReturnModel {
Code = 201, Msg = "保存失败"
});
}
}
}
catch (Exception e)
{
Log.WriteLog(e.Message);
return(new ReturnModel {
Code = 201, Msg = "保存失败"
});
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public ReturnModel Insert(Wjtc model)
{
try
{
//验证参数
if (string.IsNullOrWhiteSpace(model.TCID))
{
return(new ReturnModel {
Code = 201, Msg = "套餐不能为空"
});
}
//保存
StringBuilder sbSql = new StringBuilder();
using (IDbConnection conn = new DapperConnection().DbConnection)
{
var transaction = conn.BeginTransaction();
try
{
//判断重名
sbSql.Append("SELECT * FROM WJ_TC WHERE TCID=@TCID and SFQY=1");
Wjbq sameName = conn.QueryFirstOrDefault <Wjbq>(sbSql.ToString(), model, transaction);
if (sameName != null)
{
return(new ReturnModel {
Code = 201, Msg = "存在相同名称的套餐"
});
}
sbSql.Clear();
model.SFQY = 1;
sbSql.Append("INSERT INTO WJ_TC(TCID, SYRQ, TCZY, SFQY) VALUES (@TCID, @SYRQ, @TCZY, @SFQY);select @@IDENTITY");
int id = Convert.ToInt32(conn.ExecuteScalar(sbSql.ToString(), model, transaction));
if (!string.IsNullOrWhiteSpace(model.BQIDS))
{
//标签列表
List <string> lstBq = model.BQIDS.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList();
//深度列表
List <string> lstSd = model.BQSDS.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToList();
foreach (var item in lstBq)
{
var sd = lstSd[lstBq.IndexOf(item)];
sbSql.Clear();
sbSql.Append("INSERT INTO WJ_TCBQ(GLID, BQID, JCSD) VALUES (@GLID, @BQID, @JCSD)");
conn.Execute(sbSql.ToString(), new { GLID = id, BQID = item, JCSD = sd }, transaction);
}
}
transaction.Commit();
return(new ReturnModel {
Code = 200, Msg = "保存成功"
});
}
catch (Exception e)
{
transaction.Rollback();
Log.WriteLog(e.Message);
return(new ReturnModel {
Code = 201, Msg = "保存失败"
});
}
}
}
catch (Exception e)
{
Log.WriteLog(e.Message);
return(new ReturnModel {
Code = 201, Msg = "保存失败"
});
}
}
