/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(HXD.Model.mZhuBo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_U_zhubo(");
strSql.Append("ClassId,IsTop,IsStatus,IsElite,IsHot,Sort,CreateUsers,CreateTimes,CreateIp,EditUsers,EditTimes,EditIp,name,dianhua,shouji,sy_sun,zj_sun,dz_sun,bf_sun,add_time,photo_tx)");
strSql.Append(" values (");
strSql.Append("@ClassId,@IsTop,@IsStatus,@IsElite,@IsHot,@Sort,@CreateUsers,@CreateTimes,@CreateIp,@EditUsers,@EditTimes,@EditIp,@name,@dianhua,@shouji,@sy_sun,@zj_sun,@dz_sun,@bf_sun,@add_time,@photo_tx)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ClassId", SqlDbType.Int, 4),
new SqlParameter("@IsTop", SqlDbType.Bit, 1),
new SqlParameter("@IsStatus", SqlDbType.Bit, 1),
new SqlParameter("@IsElite", SqlDbType.Bit, 1),
new SqlParameter("@IsHot", SqlDbType.Bit, 1),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@CreateUsers", SqlDbType.NVarChar, 200),
new SqlParameter("@CreateTimes", SqlDbType.DateTime),
new SqlParameter("@CreateIp", SqlDbType.NVarChar, 200),
new SqlParameter("@EditUsers", SqlDbType.NVarChar, 200),
new SqlParameter("@EditTimes", SqlDbType.DateTime),
new SqlParameter("@EditIp", SqlDbType.NVarChar, 200),
new SqlParameter("@name", SqlDbType.NVarChar, 200),
new SqlParameter("@dianhua", SqlDbType.NVarChar, 200),
new SqlParameter("@shouji", SqlDbType.NVarChar, 200),
new SqlParameter("@sy_sun", SqlDbType.Decimal, 9),
new SqlParameter("@zj_sun", SqlDbType.Decimal, 9),
new SqlParameter("@dz_sun", SqlDbType.Decimal, 9),
new SqlParameter("@bf_sun", SqlDbType.Decimal, 9),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@photo_tx", SqlDbType.NVarChar, 1200)
};
parameters[0].Value = model.ClassId;
parameters[1].Value = model.IsTop;
parameters[2].Value = model.IsStatus;
parameters[3].Value = model.IsElite;
parameters[4].Value = model.IsHot;
parameters[5].Value = model.Sort;
parameters[6].Value = model.CreateUsers;
parameters[7].Value = model.CreateTimes;
parameters[8].Value = model.CreateIp;
parameters[9].Value = model.EditUsers;
parameters[10].Value = model.EditTimes;
parameters[11].Value = model.EditIp;
parameters[12].Value = model.name;
parameters[13].Value = model.dianhua;
parameters[14].Value = model.shouji;
parameters[15].Value = model.sy_sun;
parameters[16].Value = model.zj_sun;
parameters[17].Value = model.dz_sun;
parameters[18].Value = model.bf_sun;
parameters[19].Value = model.add_time;
parameters[20].Value = model.photo_tx;
return(HXD.DBUtility.SQLHelper.ExecuteNonQuery(strSql.ToString(), parameters) == 1);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HXD.Model.mZhuBo GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,ClassId,IsTop,IsStatus,IsElite,IsHot,Sort,CreateUsers,CreateTimes,CreateIp,EditUsers,EditTimes,EditIp,name,dianhua,shouji,sy_sun,zj_sun,dz_sun,bf_sun,add_time,photo_tx from tb_U_zhubo ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
HXD.Model.mZhuBo model = new HXD.Model.mZhuBo();
DataSet ds = HXD.DBUtility.SQLHelper.ExecuteDataset(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public HXD.Model.mZhuBo DataRowToModel(DataRow row)
{
HXD.Model.mZhuBo model = new HXD.Model.mZhuBo();
if (row != null)
{
if (row["Id"] != null && row["Id"].ToString() != "")
{
model.Id = int.Parse(row["Id"].ToString());
}
if (row["ClassId"] != null && row["ClassId"].ToString() != "")
{
model.ClassId = int.Parse(row["ClassId"].ToString());
}
if (row["IsTop"] != null && row["IsTop"].ToString() != "")
{
if ((row["IsTop"].ToString() == "1") || (row["IsTop"].ToString().ToLower() == "true"))
{
model.IsTop = true;
}
else
{
model.IsTop = false;
}
}
if (row["IsStatus"] != null && row["IsStatus"].ToString() != "")
{
if ((row["IsStatus"].ToString() == "1") || (row["IsStatus"].ToString().ToLower() == "true"))
{
model.IsStatus = true;
}
else
{
model.IsStatus = false;
}
}
if (row["IsElite"] != null && row["IsElite"].ToString() != "")
{
if ((row["IsElite"].ToString() == "1") || (row["IsElite"].ToString().ToLower() == "true"))
{
model.IsElite = true;
}
else
{
model.IsElite = false;
}
}
if (row["IsHot"] != null && row["IsHot"].ToString() != "")
{
if ((row["IsHot"].ToString() == "1") || (row["IsHot"].ToString().ToLower() == "true"))
{
model.IsHot = true;
}
else
{
model.IsHot = false;
}
}
if (row["Sort"] != null && row["Sort"].ToString() != "")
{
model.Sort = int.Parse(row["Sort"].ToString());
}
if (row["CreateUsers"] != null)
{
model.CreateUsers = row["CreateUsers"].ToString();
}
if (row["CreateTimes"] != null && row["CreateTimes"].ToString() != "")
{
model.CreateTimes = DateTime.Parse(row["CreateTimes"].ToString());
}
if (row["CreateIp"] != null)
{
model.CreateIp = row["CreateIp"].ToString();
}
if (row["EditUsers"] != null)
{
model.EditUsers = row["EditUsers"].ToString();
}
if (row["EditTimes"] != null && row["EditTimes"].ToString() != "")
{
model.EditTimes = DateTime.Parse(row["EditTimes"].ToString());
}
if (row["EditIp"] != null)
{
model.EditIp = row["EditIp"].ToString();
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
if (row["dianhua"] != null)
{
model.dianhua = row["dianhua"].ToString();
}
if (row["shouji"] != null)
{
model.shouji = row["shouji"].ToString();
}
if (row["sy_sun"] != null && row["sy_sun"].ToString() != "")
{
model.sy_sun = decimal.Parse(row["sy_sun"].ToString());
}
if (row["zj_sun"] != null && row["zj_sun"].ToString() != "")
{
model.zj_sun = decimal.Parse(row["zj_sun"].ToString());
}
if (row["dz_sun"] != null && row["dz_sun"].ToString() != "")
{
model.dz_sun = decimal.Parse(row["dz_sun"].ToString());
}
if (row["bf_sun"] != null && row["bf_sun"].ToString() != "")
{
model.bf_sun = decimal.Parse(row["bf_sun"].ToString());
}
if (row["add_time"] != null && row["add_time"].ToString() != "")
{
model.add_time = DateTime.Parse(row["add_time"].ToString());
}
if (row["photo_tx"] != null)
{
model.photo_tx = row["photo_tx"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HXD.Model.mZhuBo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_U_zhubo set ");
strSql.Append("ClassId=@ClassId,");
strSql.Append("IsTop=@IsTop,");
strSql.Append("IsStatus=@IsStatus,");
strSql.Append("IsElite=@IsElite,");
strSql.Append("IsHot=@IsHot,");
strSql.Append("Sort=@Sort,");
strSql.Append("CreateUsers=@CreateUsers,");
strSql.Append("CreateTimes=@CreateTimes,");
strSql.Append("CreateIp=@CreateIp,");
strSql.Append("EditUsers=@EditUsers,");
strSql.Append("EditTimes=@EditTimes,");
strSql.Append("EditIp=@EditIp,");
strSql.Append("name=@name,");
strSql.Append("dianhua=@dianhua,");
strSql.Append("shouji=@shouji,");
strSql.Append("sy_sun=@sy_sun,");
strSql.Append("zj_sun=@zj_sun,");
strSql.Append("dz_sun=@dz_sun,");
strSql.Append("bf_sun=@bf_sun,");
strSql.Append("add_time=@add_time,");
strSql.Append("photo_tx=@photo_tx");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@ClassId", SqlDbType.Int, 4),
new SqlParameter("@IsTop", SqlDbType.Bit, 1),
new SqlParameter("@IsStatus", SqlDbType.Bit, 1),
new SqlParameter("@IsElite", SqlDbType.Bit, 1),
new SqlParameter("@IsHot", SqlDbType.Bit, 1),
new SqlParameter("@Sort", SqlDbType.Int, 4),
new SqlParameter("@CreateUsers", SqlDbType.NVarChar, 200),
new SqlParameter("@CreateTimes", SqlDbType.DateTime),
new SqlParameter("@CreateIp", SqlDbType.NVarChar, 200),
new SqlParameter("@EditUsers", SqlDbType.NVarChar, 200),
new SqlParameter("@EditTimes", SqlDbType.DateTime),
new SqlParameter("@EditIp", SqlDbType.NVarChar, 200),
new SqlParameter("@name", SqlDbType.NVarChar, 200),
new SqlParameter("@dianhua", SqlDbType.NVarChar, 200),
new SqlParameter("@shouji", SqlDbType.NVarChar, 200),
new SqlParameter("@sy_sun", SqlDbType.Decimal, 9),
new SqlParameter("@zj_sun", SqlDbType.Decimal, 9),
new SqlParameter("@dz_sun", SqlDbType.Decimal, 9),
new SqlParameter("@bf_sun", SqlDbType.Decimal, 9),
new SqlParameter("@add_time", SqlDbType.DateTime),
new SqlParameter("@photo_tx", SqlDbType.NVarChar, 1200),
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = model.ClassId;
parameters[1].Value = model.IsTop;
parameters[2].Value = model.IsStatus;
parameters[3].Value = model.IsElite;
parameters[4].Value = model.IsHot;
parameters[5].Value = model.Sort;
parameters[6].Value = model.CreateUsers;
parameters[7].Value = model.CreateTimes;
parameters[8].Value = model.CreateIp;
parameters[9].Value = model.EditUsers;
parameters[10].Value = model.EditTimes;
parameters[11].Value = model.EditIp;
parameters[12].Value = model.name;
parameters[13].Value = model.dianhua;
parameters[14].Value = model.shouji;
parameters[15].Value = model.sy_sun;
parameters[16].Value = model.zj_sun;
parameters[17].Value = model.dz_sun;
parameters[18].Value = model.bf_sun;
parameters[19].Value = model.add_time;
parameters[20].Value = model.photo_tx;
parameters[21].Value = model.Id;
return(HXD.DBUtility.SQLHelper.ExecuteNonQuery(strSql.ToString(), parameters) == 1);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(HXD.Model.mZhuBo model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(HXD.Model.mZhuBo model)
{
return(dal.Add(model));
}
