public List <tb_keyvalue_config_model> GetList(DbConn PubConn, string keyword, int pagesize, int pageindex, out int count)
{
int _count = 0;
List <tb_keyvalue_config_model> model = new List <tb_keyvalue_config_model>();
DataSet dsList = SqlHelper.Visit <DataSet>(ps =>
{
string sqlwhere = " where 1=1 ";
StringBuilder sql = new StringBuilder();
sql.Append("select ROW_NUMBER() over(order by id desc) as rownum,* from tb_keyvalue_config ");
if (!string.IsNullOrWhiteSpace(keyword))
{
ps.Add("keyword", keyword);
sqlwhere += " and ( [key] like '%'+@keyword+'%' or remark like '%'+@keyword+'%' )";
}
_count = Convert.ToInt32(PubConn.ExecuteScalar("select count(1) from tb_keyvalue_config " + sqlwhere, ps.ToParameters()));
DataSet ds = new DataSet();
string sqlSel = "select * from (" + sql + sqlwhere + ") A where rownum between " + ((pageindex - 1) * pagesize + 1) + " and " + pagesize * pageindex;
PubConn.SqlToDataSet(ds, sqlSel, ps.ToParameters());
return(ds);
});
foreach (DataRow dr in dsList.Tables[0].Rows)
{
tb_keyvalue_config_model m = CreateModel(dr);
model.Add(m);
}
count = _count;
return(model);
}
public virtual tb_keyvalue_config_model CreateModel(DataRow dr)
{
var o = new tb_keyvalue_config_model();
//
if (dr.Table.Columns.Contains("id"))
{
o.id = dr["id"].Toint();
}
//
if (dr.Table.Columns.Contains("key"))
{
o.key = dr["key"].Tostring();
}
//
if (dr.Table.Columns.Contains("value"))
{
o.value = dr["value"].Tostring();
}
//
if (dr.Table.Columns.Contains("remark"))
{
o.remark = dr["remark"].Tostring();
}
return(o);
}
public virtual bool Add(DbConn PubConn, tb_keyvalue_config_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@key", model.key),
//
new ProcedureParameter("@value", model.value),
//
new ProcedureParameter("@remark", model.remark),
};
int rev = PubConn.ExecuteSql(@"insert into tb_keyvalue_config([key],value,remark)
values(@key,@value,@remark)" , Par);
return(rev == 1);
}
public virtual bool Edit(DbConn PubConn, tb_keyvalue_config_model model)
{
List <ProcedureParameter> Par = new List <ProcedureParameter>()
{
//
new ProcedureParameter("@key", model.key),
//
new ProcedureParameter("@value", model.value),
//
new ProcedureParameter("@remark", model.remark)
};
Par.Add(new ProcedureParameter("@id", model.id));
int rev = PubConn.ExecuteSql("update tb_keyvalue_config set [key]=@key,value=@value,remark=@remark where id=@id", Par);
return(rev == 1);
}
public ActionResult Update(tb_keyvalue_config_model model)
{
tb_keyvalue_config_dal dal = new tb_keyvalue_config_dal();
try
{
using (DbConn PubConn = DbConfig.CreateConn(Config.PlatformManageConnectString))
{
PubConn.Open();
dal.Edit(PubConn, model);
return(RedirectToAction("index"));
}
}
catch (Exception ex)
{
ModelState.AddModelError("Error", ex.Message);
return(View(model));
}
}
