/// <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)); }