private string FormBuild_DataDefDetails()
{
StringBuilder myHTML = new StringBuilder();
string buffer2, buffer3;
bool YesNo = false;
ds = EvoDB.GetData(EvoDB.BuildSQL("ID,label,typeid,typepix,type", "EvoDico_xfield", "formID=" + AppID, "ID", 0), _SqlConnectionDico, ref ErrorMsg);
if (ds != null)
{
// ORDER BY positionlist
DataTable t0 = ds.Tables[0];
{
for (int i = 0; i < t0.Rows.Count; i++)
{
myHTML.Append(EvoUI.HTMLInputHidden("f_id" + (i + 1).ToString(), t0.Rows[i]["ID"].ToString()));
}
myHTML.Append(HTMLStepTableHeader(2));
for (int i = 0; i < t0.Rows.Count; i++)
{
buffer3 = ClassEvenOrOdd(YesNo);
myHTML.Append(EvoUI.TRcssEvenOrOdd(YesNo));
myHTML.Append("<tr").Append(buffer3).Append(" valign=\"top\"><td>");
myHTML.Append(EvoUI.HTMLIcon(_PathPix, t0.Rows[i]["typepix"].ToString(), t0.Rows[i]["type"].ToString()));
if (t0.Rows[i][xAttribute.label] != null)
{
myHTML.Append(t0.Rows[i][xAttribute.label].ToString());
}
myHTML.Append("</td><td>");
buffer2 = (i + 1).ToString();
int fieldTypeID = Convert.ToInt32(t0.Rows[i]["typeid"]);
switch (fieldTypeID)
{
case 5: //txt
myHTML.Append("Max.Length ");
myHTML.Append(EvoUI.HTMLInputText("F_len" + buffer2, "100", 3));
break;
case 6: //txt multiline
case 8: //html
myHTML.Append("Max.Length ");
myHTML.Append(EvoUI.HTMLInputText("F_len" + buffer2, "100", 5));
myHTML.Append("Height ");
myHTML.Append(EvoUI.HTMLInputText("f_h" + buffer2, "3", 2));
break;
case 4: //lov
myHTML.Append("List of Values (comma separated) <textarea style=\"width:100%;\" class=\"Field\" rows=\"3\" cols=\"52\" name=\"f_op").Append(buffer2);
myHTML.Append("\" onKeyUp=\"EvoVal.checkMaxLen(this,1000)\"></textarea>");
break;
case 2: //date
case 17: //date-time
case 18: //time
myHTML.Append("Format <select ").Append(buffer3).Append(" name=\"f_ft").Append(buffer2).Append("\">");
myHTML.Append(HTMLOptionsDateFormats(fieldTypeID));
myHTML.Append("</select>");
break;
case 9: //decimal
case 10: //integer
myHTML.Append("Format <input class=\"Field\" ").Append(buffer3).Append(" name=\"f_ft").Append(buffer2).Append("\" value=\"\" maxlength=\"12\">");
break;
case 1: //boolean
myHTML.Append("Picture <select ").Append(buffer3).Append(" name=\"f_ft").Append(buffer2).Append("\">");
myHTML.Append("<option value=\"\" selected>- Default -");
myHTML.Append(EvoUI.HTMLOption("checkr.gif", "Red checkmark"));
myHTML.Append(EvoUI.HTMLOption("checkg.gif", "Green checkmark"));
myHTML.Append(EvoUI.HTMLOption(EvoUI.PixCheck, "Black checkmark"));
myHTML.Append("</select>");
break;
default:
myHTML.Append(lang_NA);
break;
}
if (fieldTypeID == 1)
{
// booleans cannot be required
myHTML.Append("<td></td></tr>");
}
else
{
myHTML.Append("<td><input type=\"checkbox\" name=\"f_rq").Append(buffer2);
if (i < 4)
{
myHTML.Append(EvoUI.qChecked);
}
myHTML.Append("\" value=\"1\"></td></tr>");
}
YesNo = !YesNo;
}
myHTML.Append("</table></span>");
}
}
else
{
myHTML.Append(EvoUI.HTMLMessage("There was an error.", EvoUI.MsgType.Info));
}
return(myHTML.ToString());
}
