/// <summary> /// 得到 wx_users 数据实体 /// </summary> /// <param name="row">row</param> /// <returns>wx_users 数据实体</returns> public ShufflingImgEntity Populate_ShufflingImgEntity_FromDr(DataRow row) { ShufflingImgEntity Obj = new ShufflingImgEntity(); if (row != null) { Obj.ImgUrl = row["ImgUrl"].ToString(); Obj.ClsId = ((row["ClsId"]) == DBNull.Value) ? 0 : Convert.ToInt32(row["ClsId"]); Obj.Addtime = ((row["Addtime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(row["Addtime"]); Obj.Updatetime = ((row["Updatetime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(row["Updatetime"]); Obj.LinkUrl = row["LinkUrl"].ToString(); Obj.LinkUrl2 = row["LinkUrl2"].ToString(); Obj.LinkUrl3 = row["LinkUrl3"].ToString(); Obj.LinkUrl4 = row["LinkUrl4"].ToString(); Obj.LinkUrl5 = row["LinkUrl5"].ToString(); Obj.ImgUrl2 = row["ImgUrl2"].ToString(); Obj.ImgUrl3 = row["ImgUrl3"].ToString(); Obj.ImgUrl4 = row["ImgUrl4"].ToString(); Obj.ImgUrl5 = row["ImgUrl5"].ToString(); } else { return(null); } return(Obj); }
/// <summary> /// 向数据表wx_Users更新一条记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="_ShufflingImgEntity">_ShufflingImgEntity</param> /// <returns>影响的行数</returns> public int Update(SqlTransaction sp, ShufflingImgEntity _ShufflingImgEntity) { string sqlStr = "UPDATE [weifenxiao].[dbo].[ShufflingImg] set [ImgUrl] =@ImgUrl,[ClsId] =@clsid,[Addtime] =@addtime,[Updatetime] =@Updatetime,LinkUrl=@LinkUrl,LinkUrl2=@LinkUrl2,LinkUrl3=@LinkUrl3,LinkUrl4=@LinkUrl4,LinkUrl5=@LinkUrl5,[ImgUrl2] =@ImgUrl2,[ImgUrl3] =@ImgUrl3,[ImgUrl4] =@ImgUrl4,[ImgUrl5] =@ImgUrl5 WHERE [ClsId] =@clsid"; SqlParameter[] _param = { new SqlParameter("@ImgUrl", SqlDbType.VarChar), new SqlParameter("@clsid", SqlDbType.VarChar), new SqlParameter("@addtime", SqlDbType.VarChar), new SqlParameter("@Updatetime", SqlDbType.VarChar), new SqlParameter("@LinkUrl", SqlDbType.VarChar), new SqlParameter("@LinkUrl2", SqlDbType.VarChar), new SqlParameter("@LinkUrl3", SqlDbType.VarChar), new SqlParameter("@LinkUrl4", SqlDbType.VarChar), new SqlParameter("@LinkUrl5", SqlDbType.VarChar), new SqlParameter("@ImgUrl2", SqlDbType.VarChar), new SqlParameter("@ImgUrl3", SqlDbType.VarChar), new SqlParameter("@ImgUrl4", SqlDbType.VarChar), new SqlParameter("@ImgUrl5", SqlDbType.VarChar) }; _param[0].Value = _ShufflingImgEntity.ImgUrl; _param[1].Value = _ShufflingImgEntity.ClsId; _param[2].Value = _ShufflingImgEntity.Addtime; _param[3].Value = _ShufflingImgEntity.Updatetime; _param[4].Value = _ShufflingImgEntity.LinkUrl; _param[5].Value = _ShufflingImgEntity.LinkUrl2; _param[6].Value = _ShufflingImgEntity.LinkUrl3; _param[7].Value = _ShufflingImgEntity.LinkUrl4; _param[8].Value = _ShufflingImgEntity.LinkUrl5; _param[9].Value = _ShufflingImgEntity.ImgUrl2; _param[10].Value = _ShufflingImgEntity.ImgUrl3; _param[11].Value = _ShufflingImgEntity.ImgUrl4; _param[12].Value = _ShufflingImgEntity.ImgUrl5; return(SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param)); }
/// <summary> /// 得到 wx_users 数据实体 /// </summary> /// <param name="dr">dr</param> /// <returns>wx_users 数据实体</returns> public ShufflingImgEntity Populate_ShufflingImgEntity_FromDr(IDataReader dr) { ShufflingImgEntity Obj = new ShufflingImgEntity(); Obj.ImgUrl = dr["ImgUrl"].ToString(); Obj.ClsId = ((dr["ClsId"]) == DBNull.Value) ? 0 : Convert.ToInt32(dr["ClsId"]); Obj.Addtime = ((dr["Addtime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["Addtime"]); Obj.Updatetime = ((dr["Updatetime"]) == DBNull.Value) ? Convert.ToDateTime("1900-1-1") : Convert.ToDateTime(dr["Updatetime"]); Obj.LinkUrl = dr["LinkUrl"].ToString(); Obj.ImgUrl2 = dr["ImgUrl2"].ToString(); Obj.ImgUrl3 = dr["ImgUrl3"].ToString(); Obj.ImgUrl4 = dr["ImgUrl4"].ToString(); Obj.ImgUrl5 = dr["ImgUrl5"].ToString(); Obj.LinkUrl2 = dr["LinkUrl2"].ToString(); Obj.LinkUrl3 = dr["LinkUrl3"].ToString(); Obj.LinkUrl4 = dr["LinkUrl4"].ToString(); Obj.LinkUrl5 = dr["LinkUrl5"].ToString(); return(Obj); }
public ShufflingImgEntity Get_ShufflingImgEntity(int clsId) { ShufflingImgEntity _obj = null; SqlParameter[] _param = { new SqlParameter("@ClsId", SqlDbType.Int) }; _param[0].Value = clsId; string sqlStr = "SELECT * FROM [weifenxiao].[dbo].[ShufflingImg] where ClsId=@ClsId"; using (SqlDataReader dr = SqlHelper.ExecuteReader(WebConfig.weixinRW, CommandType.Text, sqlStr, _param)) { while (dr.Read()) { _obj = Populate_ShufflingImgEntity_FromDr(dr); } } return(_obj); }
/// <summary> /// 向数据库中插入一条新记录。带事务 /// </summary> /// <param name="sp">事务对象</param> /// <param name="_ShufflingImgEntity">wx_Users实体</param> /// <returns>新插入记录的编号</returns> public int Insert(SqlTransaction sp, ShufflingImgEntity _ShufflingImgEntity) { string sqlStr = "insert into [weifenxiao].[dbo].[ShufflingImg](ImgUrl,clsid,addtime,Updatetime,LinkUrl,ImgUrl2,ImgUrl3,ImgUrl4,ImgUrl5,LinkUrl2,LinkUrl3,LinkUrl4,LinkUrl5) VALUES(@ImgUrl,@clsid,@addtime,@Updatetime,@LinkUrl,@ImgUrl2,@ImgUrl3,@ImgUrl4,@ImgUrl5,@LinkUrl2,@LinkUrl3,@LinkUrl4,@LinkUrl5)"; int res; SqlParameter[] _param = { new SqlParameter("@ImgUrl", SqlDbType.VarChar), new SqlParameter("@clsid", SqlDbType.VarChar), new SqlParameter("@addtime", SqlDbType.VarChar), new SqlParameter("@Updatetime", SqlDbType.VarChar), new SqlParameter("@LinkUrl", SqlDbType.VarChar), new SqlParameter("@LinkUrl2", SqlDbType.VarChar), new SqlParameter("@LinkUrl3", SqlDbType.VarChar), new SqlParameter("@LinkUrl4", SqlDbType.VarChar), new SqlParameter("@LinkUrl5", SqlDbType.VarChar), new SqlParameter("@ImgUrl2", SqlDbType.VarChar), new SqlParameter("@ImgUrl3", SqlDbType.VarChar), new SqlParameter("@ImgUrl4", SqlDbType.VarChar), new SqlParameter("@ImgUrl5", SqlDbType.VarChar) }; _param[0].Value = _ShufflingImgEntity.ImgUrl; _param[1].Value = _ShufflingImgEntity.ClsId; _param[2].Value = _ShufflingImgEntity.Addtime; _param[3].Value = _ShufflingImgEntity.Updatetime; _param[4].Value = _ShufflingImgEntity.LinkUrl; _param[5].Value = _ShufflingImgEntity.LinkUrl2; _param[6].Value = _ShufflingImgEntity.LinkUrl3; _param[7].Value = _ShufflingImgEntity.LinkUrl4; _param[8].Value = _ShufflingImgEntity.LinkUrl5; _param[9].Value = _ShufflingImgEntity.ImgUrl2; _param[10].Value = _ShufflingImgEntity.ImgUrl3; _param[11].Value = _ShufflingImgEntity.ImgUrl4; _param[12].Value = _ShufflingImgEntity.ImgUrl5; res = SqlHelper.ExecuteNonQuery(sp, CommandType.Text, sqlStr, _param); return(res); }
public int Update(ShufflingImgEntity _ShufflingImgEntity) { return(_ShufflingImgDataAccessLayerdal.Update(_ShufflingImgEntity)); }
public int Insert(ShufflingImgEntity _ShufflingImgEntity) { return(_ShufflingImgDataAccessLayerdal.Insert(_ShufflingImgEntity)); }