/// <summary>
/// 插入t_ControlProperty
/// </summary>
public virtual bool Insert(t_ControlProperty controlProperty)
{
string sql = "insert into t_ControlProperty (ControlID, PropertyNo, PropertyName, DefaultValue, Caption) values (@ControlID, @PropertyNo, @PropertyName, @DefaultValue, @Caption)";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@ControlID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ControlID", DataRowVersion.Default, controlProperty.ControlID),
new SqlParameter("@PropertyNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "PropertyNo", DataRowVersion.Default, controlProperty.PropertyNo),
new SqlParameter("@PropertyName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "PropertyName", DataRowVersion.Default, controlProperty.PropertyName),
new SqlParameter("@DefaultValue", SqlDbType.VarChar, 128, ParameterDirection.Input, false, 0, 0, "DefaultValue", DataRowVersion.Default, controlProperty.DefaultValue),
new SqlParameter("@Caption", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Caption", DataRowVersion.Default, controlProperty.Caption)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}
public List<t_ControlProperty> selectAllDate()
{
string sql = "select * from t_ControlProperty";
DataTable dt = null;
try
{
dt = db.ExecuteQuery(sql);
}
catch (Exception ex)
{
throw ex;
}
List<t_ControlProperty> _List = new List<t_ControlProperty>();
foreach (DataRow dr in dt.Rows)
{
t_ControlProperty obj = new t_ControlProperty(dr);
_List.Add(obj);
}
return _List;
}
public void Clone(t_ControlProperty obj)
{
//
ControlID = obj.ControlID;
//
PropertyNo = obj.PropertyNo;
//
PropertyName = obj.PropertyName;
//
DefaultValue = obj.DefaultValue;
//
Caption = obj.Caption;
}
public t_ControlProperty selectARowDate(string m_id)
{
string sql = string.Format("select * from t_ControlProperty where Controlid='{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_ControlProperty m_Cont=new t_ControlProperty(dr);
return m_Cont;
}
/// <summary>
/// 更新t_ControlProperty
/// </summary>
public virtual bool Update(t_ControlProperty controlProperty)
{
string sql = "update t_ControlProperty set PropertyNo = @PropertyNo, PropertyName = @PropertyName, DefaultValue = @DefaultValue, Caption = @Caption where ControlID = @ControlID";
SqlParameter [] parameters = new SqlParameter[]
{
new SqlParameter("@ControlID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ControlID", DataRowVersion.Default, controlProperty.ControlID),
new SqlParameter("@PropertyNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "PropertyNo", DataRowVersion.Default, controlProperty.PropertyNo),
new SqlParameter("@PropertyName", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "PropertyName", DataRowVersion.Default, controlProperty.PropertyName),
new SqlParameter("@DefaultValue", SqlDbType.VarChar, 128, ParameterDirection.Input, false, 0, 0, "DefaultValue", DataRowVersion.Default, controlProperty.DefaultValue),
new SqlParameter("@Caption", SqlDbType.VarChar, 50, ParameterDirection.Input, false, 0, 0, "Caption", DataRowVersion.Default, controlProperty.Caption)
};
return db.ExecuteNoQuery(sql, parameters) > -1;
}