/// <summary>
/// 增加一条数据
/// </summary>
public int Add(PubinfoEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Pubinfo(");
strSql.Append("pubemail,fansnum,pubtype,enabled,pubname,pubid,wxname,avatarurl,token,dic_prov,dic_city,dic_dist");
strSql.Append(") values (");
strSql.Append("@pubemail,@fansnum,@pubtype,@enabled,@pubname,@pubid,@wxname,@avatarurl,@token,@dic_prov,@dic_city,@dic_dist");
strSql.Append(") ");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters = {
new SqlParameter("@pubemail", SqlDbType.VarChar,50) ,
new SqlParameter("@fansnum", SqlDbType.Int,4) ,
new SqlParameter("@pubtype", SqlDbType.Int,4) ,
new SqlParameter("@enabled", SqlDbType.Bit,1) ,
new SqlParameter("@pubname", SqlDbType.NVarChar,50) ,
new SqlParameter("@pubid", SqlDbType.VarChar,50) ,
new SqlParameter("@wxname", SqlDbType.VarChar,50) ,
new SqlParameter("@avatarurl", SqlDbType.VarChar,200) ,
new SqlParameter("@token", SqlDbType.VarChar,50) ,
new SqlParameter("@dic_prov", SqlDbType.Int,4) ,
new SqlParameter("@dic_city", SqlDbType.Int,4) ,
new SqlParameter("@dic_dist", SqlDbType.Int,4)
};
parameters[0].Value = model.pubemail;
parameters[1].Value = model.fansnum;
parameters[2].Value = model.pubtype;
parameters[3].Value = model.enabled;
parameters[4].Value = model.pubname;
parameters[5].Value = model.pubid;
parameters[6].Value = model.wxname;
parameters[7].Value = model.avatarurl;
parameters[8].Value = model.token;
parameters[9].Value = model.dic_prov;
parameters[10].Value = model.dic_city;
parameters[11].Value = model.dic_dist;
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 List<PubinfoEntity> DataTableToList(DataTable dt)
{
List<PubinfoEntity> modelList = new List<PubinfoEntity>();
int rowsCount = dt.Rows.Count;
int result;
if (rowsCount > 0)
{
PubinfoEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new PubinfoEntity();
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.pubemail = dt.Rows[n]["pubemail"].ToString();
if (dt.Rows[n]["fansnum"].ToString() != "")
{
model.fansnum = int.Parse(dt.Rows[n]["fansnum"].ToString());
}
model.fansnum = int.TryParse(dt.Rows[n]["fansnum"].ToString(), out result) ? result : 0;
if (dt.Rows[n]["pubtype"].ToString() != "")
{
model.pubtype = int.Parse(dt.Rows[n]["pubtype"].ToString());
}
model.pubtype = int.TryParse(dt.Rows[n]["pubtype"].ToString(), out result) ? result : 0;
if (dt.Rows[n]["enabled"].ToString() != "")
{
if ((dt.Rows[n]["enabled"].ToString() == "1") || (dt.Rows[n]["enabled"].ToString().ToLower() == "true"))
{
model.enabled = true;
}
else
{
model.enabled = false;
}
}
model.pubname = dt.Rows[n]["pubname"].ToString();
model.pubid = dt.Rows[n]["pubid"].ToString();
model.wxname = dt.Rows[n]["wxname"].ToString();
model.avatarurl = dt.Rows[n]["avatarurl"].ToString();
model.token = dt.Rows[n]["token"].ToString();
if (dt.Rows[n]["dic_prov"].ToString() != "")
{
model.dic_prov = int.Parse(dt.Rows[n]["dic_prov"].ToString());
}
model.dic_prov = int.TryParse(dt.Rows[n]["dic_prov"].ToString(), out result) ? result : 0;
if (dt.Rows[n]["dic_city"].ToString() != "")
{
model.dic_city = int.Parse(dt.Rows[n]["dic_city"].ToString());
}
model.dic_city = int.TryParse(dt.Rows[n]["dic_city"].ToString(), out result) ? result : 0;
if (dt.Rows[n]["dic_dist"].ToString() != "")
{
model.dic_dist = int.Parse(dt.Rows[n]["dic_dist"].ToString());
}
model.dic_dist = int.TryParse(dt.Rows[n]["dic_dist"].ToString(), out result) ? result : 0;
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(PubinfoEntity model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PubinfoEntity 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, PubinfoEntity model, out int count)
{
return dal.GetPage(pageIndex, pageSize, model, out count);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(PubinfoEntity model)
{
StringBuilder strSql = new StringBuilder();
List<SqlParameter> parameters = new List<SqlParameter>();
strSql.Append("update Pubinfo set ");
if (!string.IsNullOrEmpty(model.pubemail))
{
strSql.Append(" pubemail = @pubemail , ");
parameters.Add(new SqlParameter("@pubemail", model.pubemail));
}
if (true)
{
strSql.Append(" fansnum = @fansnum , ");
parameters.Add(new SqlParameter("@fansnum", model.fansnum));
}
if (true)
{
strSql.Append(" pubtype = @pubtype , ");
parameters.Add(new SqlParameter("@pubtype", model.pubtype));
}
strSql.Append(" enabled = @enabled , ");
parameters.Add(new SqlParameter("@enabled", model.enabled));
if (!string.IsNullOrEmpty(model.pubname))
{
strSql.Append(" pubname = @pubname , ");
parameters.Add(new SqlParameter("@pubname", model.pubname));
}
if (!string.IsNullOrEmpty(model.pubid))
{
strSql.Append(" pubid = @pubid , ");
parameters.Add(new SqlParameter("@pubid", model.pubid));
}
if (!string.IsNullOrEmpty(model.wxname))
{
strSql.Append(" wxname = @wxname , ");
parameters.Add(new SqlParameter("@wxname", model.wxname));
}
if (!string.IsNullOrEmpty(model.avatarurl))
{
strSql.Append(" avatarurl = @avatarurl , ");
parameters.Add(new SqlParameter("@avatarurl", model.avatarurl));
}
if (!string.IsNullOrEmpty(model.token))
{
strSql.Append(" token = @token , ");
parameters.Add(new SqlParameter("@token", model.token));
}
if (true)
{
strSql.Append(" dic_prov = @dic_prov , ");
parameters.Add(new SqlParameter("@dic_prov", model.dic_prov));
}
if (true)
{
strSql.Append(" dic_city = @dic_city , ");
parameters.Add(new SqlParameter("@dic_city", model.dic_city));
}
if (true)
{
strSql.Append(" dic_dist = @dic_dist , ");
parameters.Add(new SqlParameter("@dic_dist", model.dic_dist));
}
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, PubinfoEntity 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_Pubinfo_Pagedata", items);
count = int.Parse(items[2].Value.ToString());
return dt;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public PubinfoEntity GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select id, pubemail, fansnum, pubtype, enabled, pubname, pubid, wxname, avatarurl, token, dic_prov, dic_city, dic_dist ");
strSql.Append(" from Pubinfo ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
PubinfoEntity model = new PubinfoEntity();
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.pubemail = dt.Rows[0]["pubemail"].ToString();
if (dt.Rows[0]["fansnum"].ToString() != "")
{
model.fansnum = int.Parse(dt.Rows[0]["fansnum"].ToString());
}
if (dt.Rows[0]["pubtype"].ToString() != "")
{
model.pubtype = int.Parse(dt.Rows[0]["pubtype"].ToString());
}
if (dt.Rows[0]["enabled"].ToString() != "")
{
if ((dt.Rows[0]["enabled"].ToString() == "1") || (dt.Rows[0]["enabled"].ToString().ToLower() == "true"))
{
model.enabled = true;
}
else
{
model.enabled = false;
}
}
model.pubname = dt.Rows[0]["pubname"].ToString();
model.pubid = dt.Rows[0]["pubid"].ToString();
model.wxname = dt.Rows[0]["wxname"].ToString();
model.avatarurl = dt.Rows[0]["avatarurl"].ToString();
model.token = dt.Rows[0]["token"].ToString();
if (dt.Rows[0]["dic_prov"].ToString() != "")
{
model.dic_prov = int.Parse(dt.Rows[0]["dic_prov"].ToString());
}
if (dt.Rows[0]["dic_city"].ToString() != "")
{
model.dic_city = int.Parse(dt.Rows[0]["dic_city"].ToString());
}
if (dt.Rows[0]["dic_dist"].ToString() != "")
{
model.dic_dist = int.Parse(dt.Rows[0]["dic_dist"].ToString());
}
return model;
}
else
{
return null;
}
}
