/// <summary>
/// 获得数据列表
/// </summary>
public List<Wgw_listEntity> DataTableToList(DataTable dt)
{
List<Wgw_listEntity> modelList = new List<Wgw_listEntity>();
int rowsCount = dt.Rows.Count;
int result;
if (rowsCount > 0)
{
Wgw_listEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new Wgw_listEntity();
if (dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
model.id = int.TryParse(dt.Rows[n]["id"].ToString(), out result) ? result : 0;
model.typeone = dt.Rows[n]["typeone"].ToString();
model.typetwo = dt.Rows[n]["typetwo"].ToString();
if (dt.Rows[n]["pid"].ToString() != "")
{
model.pid = int.Parse(dt.Rows[n]["pid"].ToString());
}
model.pid = int.TryParse(dt.Rows[n]["pid"].ToString(), out result) ? result : 0;
if (dt.Rows[n]["clientid"].ToString() != "")
{
model.clientid = int.Parse(dt.Rows[n]["clientid"].ToString());
}
model.clientid = int.TryParse(dt.Rows[n]["clientid"].ToString(), out result) ? result : 0;
model.listname = dt.Rows[n]["listname"].ToString();
model.listdesc = dt.Rows[n]["listdesc"].ToString();
if (dt.Rows[n]["listorder"].ToString() != "")
{
model.listorder = int.Parse(dt.Rows[n]["listorder"].ToString());
}
model.listorder = int.TryParse(dt.Rows[n]["listorder"].ToString(), out result) ? result : 0;
model.listcover = dt.Rows[n]["listcover"].ToString();
if (dt.Rows[n]["isshow"].ToString() != "")
{
if ((dt.Rows[n]["isshow"].ToString() == "1") || (dt.Rows[n]["isshow"].ToString().ToLower() == "true"))
{
model.isshow = true;
}
else
{
model.isshow = false;
}
}
model.icon = dt.Rows[n]["icon"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Wgw_listEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Wgw_list(");
strSql.Append("typeone,typetwo,pid,clientid,listname,listdesc,listorder,listcover,isshow,icon");
strSql.Append(") values (");
strSql.Append("@typeone,@typetwo,@pid,@clientid,@listname,@listdesc,@listorder,@listcover,@isshow,@icon");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters = {
new SqlParameter("@typeone", SqlDbType.NVarChar,150) ,
new SqlParameter("@typetwo", SqlDbType.NVarChar,150) ,
new SqlParameter("@pid", SqlDbType.Int,4) ,
new SqlParameter("@clientid", SqlDbType.Int,4) ,
new SqlParameter("@listname", SqlDbType.NVarChar,50) ,
new SqlParameter("@listdesc", SqlDbType.NVarChar,300) ,
new SqlParameter("@listorder", SqlDbType.Int,4) ,
new SqlParameter("@listcover", SqlDbType.VarChar,300) ,
new SqlParameter("@isshow", SqlDbType.Bit,1) ,
new SqlParameter("@icon", SqlDbType.VarChar,100)
};
parameters[0].Value = model.typeone;
parameters[1].Value = model.typetwo;
parameters[2].Value = model.pid;
parameters[3].Value = model.clientid;
parameters[4].Value = model.listname;
parameters[5].Value = model.listdesc;
parameters[6].Value = model.listorder;
parameters[7].Value = model.listcover;
parameters[8].Value = model.isshow;
parameters[9].Value = model.icon;
DataTable dt = DBExecuteUtil.querySqlTable(strSql.ToString(), parameters);
if (dt.Rows.Count == 0)
{
return 0;
}
else
{
return Convert.ToInt32(dt.Rows[0][0].ToString());
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Wgw_listEntity model)
{
StringBuilder strSql = new StringBuilder();
List<SqlParameter> parameters = new List<SqlParameter>();
strSql.Append("update Wgw_list set ");
if (!string.IsNullOrEmpty(model.typeone))
{
strSql.Append(" typeone = @typeone , ");
parameters.Add(new SqlParameter("@typeone", model.typeone));
}
if (!string.IsNullOrEmpty(model.typetwo))
{
strSql.Append(" typetwo = @typetwo , ");
parameters.Add(new SqlParameter("@typetwo", model.typetwo));
}
if (true)
{
strSql.Append(" pid = @pid , ");
parameters.Add(new SqlParameter("@pid", model.pid));
}
if (true)
{
strSql.Append(" clientid = @clientid , ");
parameters.Add(new SqlParameter("@clientid", model.clientid));
}
if (!string.IsNullOrEmpty(model.listname))
{
strSql.Append(" listname = @listname , ");
parameters.Add(new SqlParameter("@listname", model.listname));
}
if (!string.IsNullOrEmpty(model.listdesc))
{
strSql.Append(" listdesc = @listdesc , ");
parameters.Add(new SqlParameter("@listdesc", model.listdesc));
}
if (true)
{
strSql.Append(" listorder = @listorder , ");
parameters.Add(new SqlParameter("@listorder", model.listorder));
}
if (!string.IsNullOrEmpty(model.listcover))
{
strSql.Append(" listcover = @listcover , ");
parameters.Add(new SqlParameter("@listcover", model.listcover));
}
strSql.Append(" isshow = @isshow , ");
parameters.Add(new SqlParameter("@isshow", model.isshow));
if (!string.IsNullOrEmpty(model.icon))
{
strSql.Append(" icon = @icon , ");
parameters.Add(new SqlParameter("@icon", model.icon));
} strSql = strSql.Remove(strSql.Length - 2, 2);
strSql.Append(" where id=@id ");
parameters.Add(new SqlParameter("@id", model.id));
int rows = DBExecuteUtil.ExecuteSqlWithParams(strSql.ToString(), parameters.ToArray());
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 获取分页数据
/// </summary>
/// <returns></returns>
public DataTable GetPage(int pageIndex, int pageSize, Wgw_listEntity model, out int count)
{
count = 0;
SqlParameter[] items = new SqlParameter[]{
new SqlParameter("pageIndex",pageIndex),
new SqlParameter("pageSize",pageSize),
new SqlParameter("count",count)
};
items[2].Direction = ParameterDirection.Output;
var dt = DBStoreProUtil.queryProTable4Params("proc_Wgw_list_Pagedata", items);
count = int.Parse(items[2].Value.ToString());
return dt;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Wgw_listEntity GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, typeone, typetwo, pid, clientid, listname, listdesc, listorder, listcover, isshow, icon ");
strSql.Append(" from Wgw_list ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
Wgw_listEntity model = new Wgw_listEntity();
DataTable dt = DBExecuteUtil.querySqlTable(strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[0]["id"].ToString());
}
model.typeone = dt.Rows[0]["typeone"].ToString();
model.typetwo = dt.Rows[0]["typetwo"].ToString();
if (dt.Rows[0]["pid"].ToString() != "")
{
model.pid = int.Parse(dt.Rows[0]["pid"].ToString());
}
if (dt.Rows[0]["clientid"].ToString() != "")
{
model.clientid = int.Parse(dt.Rows[0]["clientid"].ToString());
}
model.listname = dt.Rows[0]["listname"].ToString();
model.listdesc = dt.Rows[0]["listdesc"].ToString();
if (dt.Rows[0]["listorder"].ToString() != "")
{
model.listorder = int.Parse(dt.Rows[0]["listorder"].ToString());
}
model.listcover = dt.Rows[0]["listcover"].ToString();
if (dt.Rows[0]["isshow"].ToString() != "")
{
if ((dt.Rows[0]["isshow"].ToString() == "1") || (dt.Rows[0]["isshow"].ToString().ToLower() == "true"))
{
model.isshow = true;
}
else
{
model.isshow = false;
}
}
model.icon = dt.Rows[0]["icon"].ToString();
return model;
}
else
{
return null;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Wgw_listEntity model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Wgw_listEntity model)
{
return dal.Update(model);
}
/// <summary>
/// 获得分页数据
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="model"></param>
/// <returns></returns>
public DataTable GetPage(int pageIndex, int pageSize, Wgw_listEntity model, out int count)
{
return dal.GetPage(pageIndex, pageSize, model, out count);
}