public static bool IsValidControlName(string TableName, string ControlName, int eFormID, int eFieldID)
{
string tSQL = "FormDesign @Type = 'VerifyColumnName', @eFormID=" + eFormID +", @fieldID=" + eFieldID +", @Table='" + TableName + "', @NewColumnName = '" + ControlName + "'";
DataTable oTb = DesignFormField.LoadDataTableBySQL(tSQL);
FieldConstrol oField = new FieldConstrol();
if (oTb.Rows.Count > 0)
{
if (oTb.Rows[0][0].ToString() == "1")
{
return false;
}
}
return true ;
}
public static FieldConstrol GetLabelName(string TableName, Int32 FormID)
{
string tSQL = "FormDesign @Type = 'GetNewField',@Table='sch.DesignFormField', @eFormID=" + FormID.ToString() ;
DataTable oTb = DesignFormField.LoadDataTableBySQL(tSQL);
FieldConstrol oField = new FieldConstrol();
if (oTb.Rows.Count > 0)
{
oField.ControlName = oTb.Rows[0]["NewControl"].ToString();
oField.LableName = oTb.Rows[0]["NewLabel"].ToString();
}
return oField;
}