/// <summary>
/// 得到一个对象实体
/// </summary>
public WeiXinPF.Model.wx_qp_users DataRowToModel(DataRow row)
{
WeiXinPF.Model.wx_qp_users model=new WeiXinPF.Model.wx_qp_users();
if (row != null)
{
if(row["id"]!=null && row["id"].ToString()!="")
{
model.id=int.Parse(row["id"].ToString());
}
if(row["bId"]!=null && row["bId"].ToString()!="")
{
model.bId=int.Parse(row["bId"].ToString());
}
if(row["uTel"]!=null)
{
model.uTel=row["uTel"].ToString();
}
if(row["uName"]!=null)
{
model.uName=row["uName"].ToString();
}
if(row["addr"]!=null)
{
model.addr=row["addr"].ToString();
}
if(row["sn"]!=null)
{
model.sn=row["sn"].ToString();
}
if(row["createDate"]!=null && row["createDate"].ToString()!="")
{
model.createDate=DateTime.Parse(row["createDate"].ToString());
}
if(row["uStatus"]!=null)
{
model.uStatus=row["uStatus"].ToString();
}
if(row["remark"]!=null)
{
model.remark=row["remark"].ToString();
}
if(row["openid"]!=null)
{
model.openid=row["openid"].ToString();
}
if(row["sort_id"]!=null && row["sort_id"].ToString()!="")
{
model.sort_id=int.Parse(row["sort_id"].ToString());
}
}
return model;
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WeiXinPF.Model.wx_qp_users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update wx_qp_users set ");
strSql.Append("bId=@bId,");
strSql.Append("uTel=@uTel,");
strSql.Append("uName=@uName,");
strSql.Append("addr=@addr,");
strSql.Append("sn=@sn,");
strSql.Append("createDate=@createDate,");
strSql.Append("uStatus=@uStatus,");
strSql.Append("remark=@remark,");
strSql.Append("openid=@openid,");
strSql.Append("sort_id=@sort_id");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@bId", SqlDbType.Int,4),
new SqlParameter("@uTel", SqlDbType.VarChar,100),
new SqlParameter("@uName", SqlDbType.VarChar,200),
new SqlParameter("@addr", SqlDbType.VarChar,500),
new SqlParameter("@sn", SqlDbType.VarChar,100),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@uStatus", SqlDbType.VarChar,100),
new SqlParameter("@remark", SqlDbType.VarChar,2000),
new SqlParameter("@openid", SqlDbType.VarChar,800),
new SqlParameter("@sort_id", SqlDbType.Int,4),
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = model.bId;
parameters[1].Value = model.uTel;
parameters[2].Value = model.uName;
parameters[3].Value = model.addr;
parameters[4].Value = model.sn;
parameters[5].Value = model.createDate;
parameters[6].Value = model.uStatus;
parameters[7].Value = model.remark;
parameters[8].Value = model.openid;
parameters[9].Value = model.sort_id;
parameters[10].Value = model.id;
int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WeiXinPF.Model.wx_qp_users model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into wx_qp_users(");
strSql.Append("bId,uTel,uName,addr,sn,createDate,uStatus,remark,openid,sort_id)");
strSql.Append(" values (");
strSql.Append("@bId,@uTel,@uName,@addr,@sn,@createDate,@uStatus,@remark,@openid,@sort_id)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters = {
new SqlParameter("@bId", SqlDbType.Int,4),
new SqlParameter("@uTel", SqlDbType.VarChar,100),
new SqlParameter("@uName", SqlDbType.VarChar,200),
new SqlParameter("@addr", SqlDbType.VarChar,500),
new SqlParameter("@sn", SqlDbType.VarChar,100),
new SqlParameter("@createDate", SqlDbType.DateTime),
new SqlParameter("@uStatus", SqlDbType.VarChar,100),
new SqlParameter("@remark", SqlDbType.VarChar,2000),
new SqlParameter("@openid", SqlDbType.VarChar,800),
new SqlParameter("@sort_id", SqlDbType.Int,4)};
parameters[0].Value = model.bId;
parameters[1].Value = model.uTel;
parameters[2].Value = model.uName;
parameters[3].Value = model.addr;
parameters[4].Value = model.sn;
parameters[5].Value = model.createDate;
parameters[6].Value = model.uStatus;
parameters[7].Value = model.remark;
parameters[8].Value = model.openid;
parameters[9].Value = model.sort_id;
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
if (obj == null)
{
return 0;
}
else
{
return Convert.ToInt32(obj);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WeiXinPF.Model.wx_qp_users GetModel(int id)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 id,bId,uTel,uName,addr,sn,createDate,uStatus,remark,openid,sort_id from wx_qp_users ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)
};
parameters[0].Value = id;
WeiXinPF.Model.wx_qp_users model=new WeiXinPF.Model.wx_qp_users();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
