企业库DAAB基本用法
public class Category
{
private Database db;
public Category()
{
db = DatabaseFactory.CreateDatabase();
}
private string _ClassID;
private string _ClassName;
private int _Sort;
private string _LogoImage;
private string _ClassDetails;
private byte[] _DateMark;
/// <summary>
/// 类别ID
/// </summary>
public string ClassID
{
set{_ClassID = value;}
get{return _ClassID;}
}
/// <summary>
/// 类别名称
/// </summary>
public string ClassName
{
set{_ClassName = value;}
get{return _ClassName;}
}
/// <summary>
/// 排序值
/// </summary>
public int Sort
{
set{_Sort = value;}
get{return _Sort;}
}
/// <summary>
/// 类别图片
/// </summary>
public string LogoImage
{
set{_LogoImage = value;}
get{return _LogoImage;}
}
/// <summary>
/// 类别说明
/// </summary>
public string ClassDetails
{
set{_ClassDetails = value;}
get{return _ClassDetails;}
}
/// <summary>
/// 最后修改时间
/// </summary>
public byte[] DateMark
{
set{_DateMark = value;}
get{return _DateMark;}
}
/// <summary>
/// 获取Category对象集合
/// </summary>
/// <returns>返回所有对象集合</returns>
public IList GetCategoryList()
{
IList il = new ArrayList();
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryGetList_p");
IDataReader dr = db.ExecuteReader(dw);
while(dr.Read())
{
Category obj = new Category();
obj.ClassID = Convert.ToString(dr["ClassID"]);
obj.ClassName = Convert.ToString(dr["ClassName"]);
obj.Sort = Convert.ToInt32(dr["Sort"]);
obj.LogoImage = Convert.ToString(dr["LogoImage"]);
obj.ClassDetails = Convert.ToString(dr["ClassDetails"]);
obj.DateMark = (byte[])(dr["DateMark"]);
il.Add(obj);
}
return il;
}
/// <summary>
/// 对Category对象的简单查询操作
/// </summary>
/// <param name="ClassID">类别ID</param>
/// <returns>返回Category对象</returns>
public Category GetCategoryByClassID(string ClassID)
{
bool HasData = false;
Category obj = new Category();
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryGet_p");
dw.AddInParameter("@ClassID",DbType.String,ClassID);
IDataReader dr = db.ExecuteReader(dw);
while(dr.Read())
{
obj.ClassID = Convert.ToString(dr["ClassID"]);
obj.ClassName = Convert.ToString(dr["ClassName"]);
obj.Sort = Convert.ToInt32(dr["Sort"]);
obj.LogoImage = Convert.ToString(dr["LogoImage"]);
obj.ClassDetails = Convert.ToString(dr["ClassDetails"]);
obj.DateMark = (byte[])(dr["DateMark"]);
HasData = true;
}
dr.Close();
if(!HasData)
return null;
else
return obj;
}
/// <summary>
/// 对Category对象的插入操作
/// </summary>
/// <param name="obj">Category对象</param>
/// <returns>返回影响行数</returns>
public int InsertCategory(Category obj,out string newid)
{
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryInsert_p");
dw.AddInParameter("@ClassID",DbType.String,obj.ClassID);
dw.AddOutParameter("@NewID",DbType.String,6);
dw.AddInParameter("@ClassName",DbType.String,obj.ClassName);
dw.AddInParameter("@Sort",DbType.Int32,obj.Sort);
dw.AddInParameter("@LogoImage",DbType.String,obj.LogoImage);
dw.AddInParameter("@ClassDetails",DbType.String,obj.ClassDetails);
dw.AddOutParameter("@RowCount",DbType.Int32,4);
db.ExecuteNonQuery(dw);
int rlt = Convert.ToInt32(dw.GetParameterValue("@RowCount"));
newid = Convert.ToString(dw.GetParameterValue("@NewID"));
db.ClearParameterCache();
dw.Dispose();
return rlt;
}
/// <summary>
/// 对Category对象的更新操作
/// </summary>
/// <param name="obj">Category对象</param>
/// <returns>返回影响行数</returns>
public int UpdateCategory(Category obj)
{
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryUpdate_p");
dw.AddInParameter("@ClassID",DbType.String,obj.ClassID);
dw.AddInParameter("@ClassName",DbType.String,obj.ClassName);
dw.AddInParameter("@Sort",DbType.Int32,obj.Sort);
dw.AddInParameter("@LogoImage",DbType.String,obj.LogoImage);
dw.AddInParameter("@ClassDetails",DbType.String,obj.ClassDetails);
dw.AddInParameter("@DateMark",DbType.Binary,obj.DateMark);
dw.AddOutParameter("@RowCount",DbType.Int32,4);
db.ExecuteNonQuery(dw);
int rlt = Convert.ToInt32(dw.GetParameterValue("@RowCount"));
db.ClearParameterCache();
dw.Dispose();
return rlt;
}
/// <summary>
/// 对Category对象的删除操作
/// </summary>
/// <param name="obj">Category对象</param>
/// <returns>返回影响行数</returns>
public int DeleteCategory(Category obj)
{
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryDelete_p");
dw.AddInParameter("@ClassID",DbType.String,obj.ClassID);
dw.AddInParameter("@DateMark",DbType.Binary,obj.DateMark);
dw.AddOutParameter("@RowCount",DbType.Int32,4);
db.ExecuteNonQuery(dw);
int rlt = Convert.ToInt32(dw.GetParameterValue("@RowCount"));
db.ClearParameterCache();
dw.Dispose();
return rlt;
}
}
{
private Database db;
public Category()
{
db = DatabaseFactory.CreateDatabase();
}
private string _ClassID;
private string _ClassName;
private int _Sort;
private string _LogoImage;
private string _ClassDetails;
private byte[] _DateMark;
/// <summary>
/// 类别ID
/// </summary>
public string ClassID
{
set{_ClassID = value;}
get{return _ClassID;}
}
/// <summary>
/// 类别名称
/// </summary>
public string ClassName
{
set{_ClassName = value;}
get{return _ClassName;}
}
/// <summary>
/// 排序值
/// </summary>
public int Sort
{
set{_Sort = value;}
get{return _Sort;}
}
/// <summary>
/// 类别图片
/// </summary>
public string LogoImage
{
set{_LogoImage = value;}
get{return _LogoImage;}
}
/// <summary>
/// 类别说明
/// </summary>
public string ClassDetails
{
set{_ClassDetails = value;}
get{return _ClassDetails;}
}
/// <summary>
/// 最后修改时间
/// </summary>
public byte[] DateMark
{
set{_DateMark = value;}
get{return _DateMark;}
}
/// <summary>
/// 获取Category对象集合
/// </summary>
/// <returns>返回所有对象集合</returns>
public IList GetCategoryList()
{
IList il = new ArrayList();
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryGetList_p");
IDataReader dr = db.ExecuteReader(dw);
while(dr.Read())
{
Category obj = new Category();
obj.ClassID = Convert.ToString(dr["ClassID"]);
obj.ClassName = Convert.ToString(dr["ClassName"]);
obj.Sort = Convert.ToInt32(dr["Sort"]);
obj.LogoImage = Convert.ToString(dr["LogoImage"]);
obj.ClassDetails = Convert.ToString(dr["ClassDetails"]);
obj.DateMark = (byte[])(dr["DateMark"]);
il.Add(obj);
}
return il;
}
/// <summary>
/// 对Category对象的简单查询操作
/// </summary>
/// <param name="ClassID">类别ID</param>
/// <returns>返回Category对象</returns>
public Category GetCategoryByClassID(string ClassID)
{
bool HasData = false;
Category obj = new Category();
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryGet_p");
dw.AddInParameter("@ClassID",DbType.String,ClassID);
IDataReader dr = db.ExecuteReader(dw);
while(dr.Read())
{
obj.ClassID = Convert.ToString(dr["ClassID"]);
obj.ClassName = Convert.ToString(dr["ClassName"]);
obj.Sort = Convert.ToInt32(dr["Sort"]);
obj.LogoImage = Convert.ToString(dr["LogoImage"]);
obj.ClassDetails = Convert.ToString(dr["ClassDetails"]);
obj.DateMark = (byte[])(dr["DateMark"]);
HasData = true;
}
dr.Close();
if(!HasData)
return null;
else
return obj;
}
/// <summary>
/// 对Category对象的插入操作
/// </summary>
/// <param name="obj">Category对象</param>
/// <returns>返回影响行数</returns>
public int InsertCategory(Category obj,out string newid)
{
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryInsert_p");
dw.AddInParameter("@ClassID",DbType.String,obj.ClassID);
dw.AddOutParameter("@NewID",DbType.String,6);
dw.AddInParameter("@ClassName",DbType.String,obj.ClassName);
dw.AddInParameter("@Sort",DbType.Int32,obj.Sort);
dw.AddInParameter("@LogoImage",DbType.String,obj.LogoImage);
dw.AddInParameter("@ClassDetails",DbType.String,obj.ClassDetails);
dw.AddOutParameter("@RowCount",DbType.Int32,4);
db.ExecuteNonQuery(dw);
int rlt = Convert.ToInt32(dw.GetParameterValue("@RowCount"));
newid = Convert.ToString(dw.GetParameterValue("@NewID"));
db.ClearParameterCache();
dw.Dispose();
return rlt;
}
/// <summary>
/// 对Category对象的更新操作
/// </summary>
/// <param name="obj">Category对象</param>
/// <returns>返回影响行数</returns>
public int UpdateCategory(Category obj)
{
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryUpdate_p");
dw.AddInParameter("@ClassID",DbType.String,obj.ClassID);
dw.AddInParameter("@ClassName",DbType.String,obj.ClassName);
dw.AddInParameter("@Sort",DbType.Int32,obj.Sort);
dw.AddInParameter("@LogoImage",DbType.String,obj.LogoImage);
dw.AddInParameter("@ClassDetails",DbType.String,obj.ClassDetails);
dw.AddInParameter("@DateMark",DbType.Binary,obj.DateMark);
dw.AddOutParameter("@RowCount",DbType.Int32,4);
db.ExecuteNonQuery(dw);
int rlt = Convert.ToInt32(dw.GetParameterValue("@RowCount"));
db.ClearParameterCache();
dw.Dispose();
return rlt;
}
/// <summary>
/// 对Category对象的删除操作
/// </summary>
/// <param name="obj">Category对象</param>
/// <returns>返回影响行数</returns>
public int DeleteCategory(Category obj)
{
DBCommandWrapper dw = db.GetStoredProcCommandWrapper("CategoryDelete_p");
dw.AddInParameter("@ClassID",DbType.String,obj.ClassID);
dw.AddInParameter("@DateMark",DbType.Binary,obj.DateMark);
dw.AddOutParameter("@RowCount",DbType.Int32,4);
db.ExecuteNonQuery(dw);
int rlt = Convert.ToInt32(dw.GetParameterValue("@RowCount"));
db.ClearParameterCache();
dw.Dispose();
return rlt;
}
}