/// <summary>
/// 插入t_ElementProperty_Library
/// </summary>
public virtual bool Insert(t_ElementProperty_Library elementPropertyLibrary)
{
string sql = "insert into t_ElementProperty_Library (ElementID, PropertyNo, PropertyValue, Caption, PropertyName) values (@ElementID, @PropertyNo, @PropertyValue, @Caption, @PropertyName)";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@ElementID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ElementID", DataRowVersion.Default, elementPropertyLibrary.Elementid),
new SqlParameter("@PropertyNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "PropertyNo", DataRowVersion.Default, elementPropertyLibrary.Propertyno),
new SqlParameter("@PropertyValue", SqlDbType.VarChar, 4096, ParameterDirection.Input, false, 0, 0, "PropertyValue", DataRowVersion.Default, elementPropertyLibrary.Propertyvalue),
new SqlParameter("@Caption", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Caption", DataRowVersion.Default, elementPropertyLibrary.Caption),
new SqlParameter("@PropertyName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "PropertyName", DataRowVersion.Default, elementPropertyLibrary.Propertyname)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public List<t_ElementProperty_Library> selectAllDate()
{
string sql = "select * from t_ElementProperty_Library";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
List<t_ElementProperty_Library> _List = new List<t_ElementProperty_Library>();
foreach (DataRow dr in dt.Rows)
{
t_ElementProperty_Library obj = new t_ElementProperty_Library(dr);
_List.Add(obj);
}
return _List;
}
public void Clone(t_ElementProperty_Library obj)
{
//
Elementid = obj.Elementid;
//
Propertyno = obj.Propertyno;
//
Propertyvalue = obj.Propertyvalue;
//
Caption = obj.Caption;
//
Propertyname = obj.Propertyname;
}
public t_ElementProperty_Library selectARowDate(string m_id)
{
string sql = string.Format("select * from t_ElementProperty_Library where Elementid='{0}'",m_id);
DataTable dt = null;
try
{
dt = db.ExecuteQueryDataSet(sql).Tables[0];
}
catch (Exception ex)
{
throw ex;
}
if (dt == null)
return null;
if (dt.Rows.Count == 0)
return null;
DataRow dr = dt.Rows[0];
t_ElementProperty_Library m_Elem=new t_ElementProperty_Library(dr);
return m_Elem;
}
/// <summary>
/// 更新t_ElementProperty_Library
/// </summary>
public virtual bool Update(t_ElementProperty_Library elementPropertyLibrary)
{
string sql = "update t_ElementProperty_Library set PropertyNo = @PropertyNo, PropertyValue = @PropertyValue, Caption = @Caption, PropertyName = @PropertyName where ElementID = @ElementID";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@ElementID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ElementID", DataRowVersion.Default, elementPropertyLibrary.Elementid),
new SqlParameter("@PropertyNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "PropertyNo", DataRowVersion.Default, elementPropertyLibrary.Propertyno),
new SqlParameter("@PropertyValue", SqlDbType.VarChar, 4096, ParameterDirection.Input, false, 0, 0, "PropertyValue", DataRowVersion.Default, elementPropertyLibrary.Propertyvalue),
new SqlParameter("@Caption", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Caption", DataRowVersion.Default, elementPropertyLibrary.Caption),
new SqlParameter("@PropertyName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "PropertyName", DataRowVersion.Default, elementPropertyLibrary.Propertyname)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
