/// <summary>
/// 获得数据列表
/// </summary>
public List<Model.VipRank> DataTableToList(DataTable dt)
{
List<Model.VipRank> modelList = new List<Model.VipRank>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Model.VipRank model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.VipRank();
if (dt.Rows[n]["r_ID"] != null && dt.Rows[n]["r_ID"].ToString() != "")
{
model.r_ID = int.Parse(dt.Rows[n]["r_ID"].ToString());
}
if (dt.Rows[n]["r_Name"] != null && dt.Rows[n]["r_Name"].ToString() != "")
{
model.r_Name = dt.Rows[n]["r_Name"].ToString();
}
if (dt.Rows[n]["r_ZheK"] != null && dt.Rows[n]["r_ZheK"].ToString() != "")
{
model.r_ZheK = decimal.Parse(dt.Rows[n]["r_ZheK"].ToString());
}
if (dt.Rows[n]["r_Score"] != null && dt.Rows[n]["r_Score"].ToString() != "")
{
model.r_Score = int.Parse(dt.Rows[n]["r_Score"].ToString());
}
if (dt.Rows[n]["r_Status"] != null && dt.Rows[n]["r_Status"].ToString() != "")
{
model.r_Status = int.Parse(dt.Rows[n]["r_Status"].ToString());
}
if (dt.Rows[n]["r_Rank"] != null && dt.Rows[n]["r_Rank"].ToString() != "")
{
model.r_Rank = int.Parse(dt.Rows[n]["r_Rank"].ToString());
}
if (dt.Rows[n]["r_UpperScore"] != null && dt.Rows[n]["r_UpperScore"].ToString() != "")
{
model.r_UpperScore = int.Parse(dt.Rows[n]["r_UpperScore"].ToString());
}
if (model != null)
{
modelList.Add(model);
}
}
}
return modelList;
}
public ActionResult Add(Model.VipRank model)
{
bool result = false;
bool ischongfu = false;
Model.VipRank mb = new Model.VipRank();
List<Model.VipRank> listvip = viprankbll.GetModelList(" r_Status!=2");
for (int i = 0; i < listvip.Count; i++)
{
if (listvip[i].r_Rank == model.r_Rank)
{
ischongfu = true;
}
}
try
{
if (ischongfu == false)
{
model.r_Status = 0;
result = viprankbll.Add(model) > 0 ? true : false;
if (result)
{
return Content(DWZUtil.GetResultJson("200", "操作成功！！", "w_会员等级管理", "", "closeCurrent"));
}
else
{
return Content(DWZUtil.GetResultJson("300", "保存失败！！", "", "", ""));
}
}
else {
return Content(DWZUtil.GetResultJson("300", "保存失败,会员等级已存在！！", "", "", ""));
}
}
catch
{
return Content(DWZUtil.GetResultJson("300", "保存失败！！", "", "", ""));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.VipRank DataRowToModel(DataRow row)
{
Model.VipRank model = new Model.VipRank();
if (row != null)
{
if (row["r_ID"] != null && row["r_ID"].ToString() != "")
{
model.r_ID = int.Parse(row["r_ID"].ToString());
}
if (row["r_Name"] != null)
{
model.r_Name = row["r_Name"].ToString();
}
if (row["r_ZheK"] != null && row["r_ZheK"].ToString() != "")
{
model.r_ZheK = decimal.Parse(row["r_ZheK"].ToString());
}
if (row["r_Score"] != null && row["r_Score"].ToString() != "")
{
model.r_Score = int.Parse(row["r_Score"].ToString());
}
if (row["r_Status"] != null && row["r_Status"].ToString() != "")
{
model.r_Status = int.Parse(row["r_Status"].ToString());
}
if (row["r_Rank"] != null && row["r_Rank"].ToString() != "")
{
model.r_Rank = int.Parse(row["r_Rank"].ToString());
}
if (row["r_UpperScore"] != null && row["r_UpperScore"].ToString() != "")
{
model.r_UpperScore = int.Parse(row["r_UpperScore"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.VipRank GetModel(int r_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 r_ID,r_Name,r_ZheK,r_Score,r_Status,r_Rank,r_UpperScore from VipRank ");
strSql.Append(" where r_ID=@r_ID");
SqlParameter[] parameters = {
new SqlParameter("@r_ID", SqlDbType.Int,4)
};
parameters[0].Value = r_ID;
Model.VipRank model = new Model.VipRank();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
