static internal string IntProp(String Name, String Value)
{
if (EvoTC.isInteger(Value))
{
return(String.Format(propInt, Name, Value));
}
return(String.Empty);
}
static internal string dbFormat(string fieldValue, string fieldType, int fieldMaxLength, string language)
{
switch (fieldType)
{
case t_text:
case t_txtm:
case t_pix:
case t_doc:
case t_email:
case t_url:
case t_html:
if (fieldMaxLength > 0 && fieldValue.Length > fieldMaxLength)
{
return(string.Format("N'{0}'", fieldValue.Substring(0, fieldMaxLength).Replace("'", "''")));
}
else
{
return(string.Format("N'{0}'", fieldValue.Replace("'", "''")));
}
case t_lov:
return(string.IsNullOrEmpty(fieldValue) ? string.Empty : EvoTC.StrVal(fieldValue));
case t_bool:
case t_int:
return(string.IsNullOrEmpty(fieldValue)? SQL_NULL : EvoTC.StrVal(fieldValue));
case t_dec:
string tDecStr;
if (EvoTC.isInteger(fieldValue))
{
//MUST NOT USE FORMATTED NUMBER IN EDIT GRID
tDecStr = fieldValue.TrimStart();
}
else if (!string.IsNullOrEmpty(fieldValue))
{
tDecStr = EvoTC.String2Dec(fieldValue).ToString();
}
else
{
tDecStr = SQL_NULL;
}
if (language == "FR" || language == "DA")
{
tDecStr = tDecStr.Replace(",", ".");
}
return(tDecStr);
case t_date:
case t_datetime:
case t_time:
switch (language)
{
case "EN":
case "ZH":
if (EvoTC.isDate(fieldValue))
{
string df;
switch (fieldType)
{
case t_date:
df = "yyyy-M-d";
break;
case t_datetime:
df = "yyyy-M-d hh:mm:ss tt";
break;
default: //"time"
df = "hh:mm:ss tt";
break;
}
return(string.Format("'{0}'", EvoTC.String2DateTime(fieldValue).ToString(df)));
}
else
{
return(SQL_NULL);
}
case "DA":
if (EvoTC.isDate(fieldValue))
{
string df;
switch (fieldType)
{
case t_date:
df = "yyyy-M-d";
break;
case t_datetime:
df = "yyyy-M-d HH:mm:ss";
break;
default: //"time"
df = "HH:mm:ss";
break;
}
return(string.Format("'{0}'", EvoTC.String2DateTime(fieldValue).ToString(df)));
}
else
{
return(SQL_NULL);
}
default:
return(GetDateDMY(fieldValue));
}
default:
return(SQLescape(fieldValue));
}
}
private string InstallApp(string XMLDefFile)
{
StringBuilder myHTML = new StringBuilder();
bool xmlOK = true;
string sql, dbr = null, errorMsg = null;
string checkMark = EvoUI.HTMLImgCheckMark(IEbrowser, _PathPix);
myHTML.AppendFormat("<h2>{0}</h2>", XMLDefFile.Replace("_", ""));
if (!string.IsNullOrEmpty(XMLDefFile))
{
XmlDocument myDOM2 = new XmlDocument();
try
{
myDOM2.Load(FileNameWithMask(_PathXML + string.Format("Setup\\{0}.xml", XMLDefFile)));
}
catch //(Exception ex)
{
errorMsg = "XML not found or invalid";
xmlOK = false;
}
if (xmlOK)
{
string t = "";
XmlNode aNode = myDOM2.DocumentElement;
if (aNode.Name == "applicationcomponent")
{
sql = aNode["xml"].InnerText;
if (sql.StartsWith("<?xml"))
{
sql = xQuery.XMLHeader + sql;
}
aNode = aNode["sql"];
if (aNode.Attributes[xAttribute.dbTable] != null)
{
t = aNode.Attributes[xAttribute.dbTable].Value;
myHTML.AppendFormat("<p>DB Table: {0}</p>", t);
}
dicoXML2DB(sql, _SqlConnectionDico);
myHTML.Append("<div class=\"indent1\">");
if (string.IsNullOrEmpty(errorMsg))
{
myHTML.Append(checkMark).Append("Metadata<br>");
}
if (aNode.Attributes[xAttribute.dbTable] != null)
{
string tc = EvoDB.GetDataScalar(EvoDB.BuildSQL("count(*)", t), _SqlConnection, ref ErrorMsg);
if (EvoTC.isInteger(tc))
{
errorMsg = "Database table not created because it already exists.";
}
else
{
sql = aNode["create"].InnerText;
dbr = EvoDB.RunSQL(sql, _SqlConnection, false);
if (string.IsNullOrEmpty(dbr))
{
myHTML.Append(checkMark).Append("Database structure<br>");
}
else
{
errorMsg = dbr;
}
}
if (string.IsNullOrEmpty(dbr))
{
int i = EvoTC.String2Int(tc);
if (i == 0)
{
sql = aNode["seed"].InnerText;
dbr = EvoDB.RunSQL(sql, _SqlConnection, false);
if (string.IsNullOrEmpty(dbr))
{
myHTML.Append(checkMark).Append("Seed data<br>");
sql = aNode["sample"].InnerText;
dbr = EvoDB.RunSQL(sql, _SqlConnection, false);
if (string.IsNullOrEmpty(dbr))
{
myHTML.Append(checkMark).Append("Sample data<br>");
}
else
{
errorMsg = dbr;
}
}
}
}
else
{
errorMsg = dbr;
}
}
myHTML.Append("</div>");
}
}
if (!string.IsNullOrEmpty(errorMsg))
{
myHTML.Append(EvoUI.HTMLMessage(errorMsg, EvoUI.MsgType.Error));
}
}
myHTML.Append(HTMLToolsLink(FormID.ToString(), "")).Append("</p>");
return(myHTML.ToString());
}
private string dicoXML2DB(string XML, string sqlConnectionDico)
{
string sqlstart1, sqlstart2;
int FormID = 0, PanelID;
int maxLoopP = 0;
string sqllog = null;
Data def_Data = new Data();
StringBuilder allSQL = new StringBuilder();
try
{
myDOM.LoadXml(XML);
}
catch
{
allSQL = new StringBuilder();
allSQL.Append(EvoUI.HTMLMessage("<p>Invalid XML. Please validate your XML with Evolutility.xsd.</p>", EvoUI.MsgType.Error));
//allSQL.Append(HttpUtility.HtmlEncode(XML));
return(allSQL.ToString());
}
XmlNamespaceManager nsManager = new XmlNamespaceManager(new NameTable());
nsManager.AddNamespace("evo", xQuery.evoNameSpace);
XmlNode aNode = myDOM.DocumentElement;
if (aNode != null && aNode.Name == xElement.form)
{
if (aNode.Attributes[xAttribute.label] != null)
{
def_Data.title = aNode.Attributes[xAttribute.label].InnerXml;
}
try
{
def_Data = Data.Deserialize(aNode[xElement.data]);
}
catch
{
ErrorMsg = "Invalid XML file. The element 'data' must have attributes.";
}
}
StringBuilder sbSQL = new StringBuilder();
StringBuilder sqlFull = new StringBuilder();
if (string.IsNullOrEmpty(ErrorMsg))
{
//######### Form #########
sbSQL.Append("INSERT INTO EvoDico_Form(title,dbtable,dbcolumnpk,dbcolumnlead,dbwhere,dborder,sppaging,splogin,spget,spdelete,entity,entities,icon,description) ");
sbSQL.Append("VALUES('").Append(EvoDB.SQLescape(def_Data.title)).AppendFormat("','{0}','{1}','{2}','{3}','{4}','", def_Data.dbtable, def_Data.dbcolumnpk, def_Data.dbcolumnlead, def_Data.dbwhere, def_Data.dborder);
sbSQL.Append(EvoDB.SQLescape(def_Data.sppaging));
sbSQL.Append("','").Append(EvoDB.SQLescape(def_Data.splogin)).Append("','").Append(EvoDB.SQLescape(def_Data.spget)).Append("','");
sbSQL.Append(EvoDB.SQLescape(def_Data.spdelete)).AppendFormat("','{0}','{1}','{2}','", EvoDB.SQLescape(def_Data.entity), EvoDB.SQLescape(def_Data.entities), EvoDB.SQLescape(def_Data.icon));
sbSQL.AppendFormat("XML import on {0}')", EvoTC.TextNowTime());
sbSQL.Append(EvoDB.SQL_IDENTITY);
FormID = EvoTC.String2Int(EvoDB.GetDataScalar(sbSQL.ToString(), sqlConnectionDico, ref ErrorMessage));
if (FormID > 0 && string.IsNullOrEmpty(ErrorMsg))
{
//######### Panels #########
XmlNodeList aNodeListPanels = myDOM.DocumentElement.SelectNodes(xQuery.panel, nsManager);
maxLoopP = aNodeListPanels.Count - 1;
if (maxLoopP == -1)
{
aNodeListPanels = myDOM.DocumentElement.SelectNodes("//evo:tab/evo:panel", nsManager);
maxLoopP = aNodeListPanels.Count - 1;
}
sqlFull = new StringBuilder();
for (int p = 0; p <= maxLoopP; p++)
{
XmlNode pNode = aNodeListPanels[p];
sbSQL = new StringBuilder();
sbSQL.Append("INSERT INTO EvoDico_Panel (FormID, label, Width, cssclass, cssclasslabel) VALUES(");
sbSQL.AppendFormat("{0},", FormID);
sbSQL.AppendFormat("'{0}',", EvoDB.SQLescape(pNode.Attributes[xAttribute.label].Value));
sbSQL.AppendFormat("{0},", pNode.Attributes[xAttribute.width].Value);
if (pNode.Attributes[xAttribute.cssClass] != null)
{
sbSQL.AppendFormat("'{0}',", EvoDB.SQLescape(pNode.Attributes[xAttribute.cssClass].Value));
}
else
{
sbSQL.Append("'',");
}
if (pNode.Attributes[xAttribute.cssClassLabel] != null)
{
sbSQL.AppendFormat("'{0}')", EvoDB.SQLescape(pNode.Attributes[xAttribute.cssClassLabel].Value));
}
else
{
sbSQL.Append("'')");
}
sbSQL.Append(EvoDB.SQL_IDENTITY);
PanelID = EvoTC.String2Int(EvoDB.GetDataScalar(sbSQL.ToString(), sqlConnectionDico, ref ErrorMessage));
if (PanelID > 0 && string.IsNullOrEmpty(ErrorMsg))
{
//######### Fields #########
sqlstart1 = "INSERT INTO EvoDico_Field (FormID,";
sqlstart2 = string.Format(") VALUES ({0},", FormID);
foreach (XmlNode aNode2 in pNode.ChildNodes)
{
StringBuilder sbSQL1 = new StringBuilder();
StringBuilder sbSQL2 = new StringBuilder();
sbSQL1.Append(sqlstart1);
sbSQL2.Append(sqlstart2);
foreach (XmlAttribute aAttribute2 in aNode2.Attributes)
{
string buffer2 = aAttribute2.Name;
string buffer = aAttribute2.Value;
switch (buffer2)
{
case "panelid":
break;
default:
if (EvoTC.isInteger(buffer))
{
sbSQL1.AppendFormat("[{0}],", buffer2);
sbSQL2.AppendFormat("{0},", buffer);
}
else
{
if (buffer2 == xAttribute.type)
{
sbSQL1.Append("typeid,");
sbSQL2.AppendFormat("{0},", FieldTypeID(buffer));
}
else if (buffer != string.Empty)
{
sbSQL1.AppendFormat("[{0}],", buffer2);
sbSQL2.AppendFormat("'{0}',", EvoDB.SQLescape(buffer));
}
}
break;
}
}
sqlFull.Append(sbSQL1).Append("PanelID").Append(sbSQL2).Append(PanelID).Append(");\n");
}
}
}
string buff = EvoDB.RunSQL(sqlFull.ToString(), sqlConnectionDico, true);
if (!string.IsNullOrEmpty(buff))
{
ErrorMsg += buff;
}
//'######### Panels Details #########
//aNodeListPanels = myDOM.DocumentElement.SelectNodes("//panel-details", nsManager)
//maxLoopP = aNodeListPanels.Count - 1
//sqlstart1 = "INSERT INTO EvoDico_FieldDetails (FormID,"
//For p = 0 To maxLoopP
// With aNodeListPanels[p]
// Sql = "INSERT INTO EvoDico_Panel (TypeID, FormID, label, Width, dbtabledetails, dbcolumndetails) VALUES(2," & CInt(FormID) & ",'"
// Sql += .Attributes(xAttribute.label).Value & "'," & .Attributes(xAttribute.width).Value & ",'" & .Attributes(xAttribute.dbTableDetails).Value & "','" & .Attributes(xAttribute.dbColumnDetails).Value & "')"
// Buffer = EvoDB.RunSQL(Sql, sqlConnectionDico, True)
// If Buffer = "" Then
// PanelID = CInt(GetDataScalar(EvoDB.BuildSQL("max(ID)", "EvoDico_Panel", "TypeID=2 AND FormID=" & CStr(FormID)), sqlConnectionDico))
// '######### Fields Details #########
// sqlstart2 = ") VALUES (" & FormID & coma
// sqlFull = ""
// For Each aNode In .ChildNodes
// Sql = sqlstart1
// sql2 = sqlstart2
// For Each aAttribute In aNode.Attributes
// Buffer = aAttribute.Value
// dbcolumn = aAttribute.Name
// If InStr("-type-panelid-panelindex-label-dbcolumn-dbcolumnread-dbcolumnimg-dbtablelov-dborderlov-dbcolumnreadlov-dblovcolumn-dbwherelov-validationrule-maxlength-readonly-required-optional-format-fpos-link-linklabel-linktarget-searchlist-cssclass-width-", "-" & LCase(dbcolumn) & "-") > 0 Then
// If IsNumeric(Buffer) AndAlso Not dbcolumn = xAttribute.format Then
// Sql += dbcolumn & coma
// sql2 += Buffer & coma
// Else
// If aAttribute.Name = xAttribute.type Then
// Sql += "typeid,"
// sql2 += FieldTypeID(Buffer) & coma
// Else
// If Buffer <> String.Empty Then
// Sql += "[" & dbcolumn & "],"
// sql2 += "'" & EvoDB.SQLescape(Buffer) & "',"
// End If
// End If
// End If
// End If
// Next
// 'If InStr(sql, "panelid") = 0 Then
// ' sql += "PanelID,"
// ' sql2 += CStr(Val(PanelID))
// 'End If
// sqlFull += Sql & "userid" & sql2 & UserID & ");"
// Next
// End If
// End With
// Buffer = EvoDB.RunSQL(sqlFull, sqlConnectionDico, True)
// If Buffer <> String.Empty Then sqllog += Buffer & vbCrLf & Sql & vbCrLf2
//Next
//End If
if (!string.IsNullOrEmpty(sqllog))
{
ErrorMsg = sqllog.Replace("\n\n\n", "");
}
}
}
string retVal = String.Format("{0} {1}", def_Data.title, HTMLToolsLink(FormID.ToString(), ""));
def_Data = null;
nsManager = null;
myDOM = null;
return(retVal);
}
private string HTMLDataset(XmlNodeList aNodeList, string sql, string title, int ListMode, string LinkDetailNew, bool InsidePanel, int PanelDetailsIndex, int PanelDetailsID)
{
// Generates HTML for paging grid, details grid, and edit grid.
//ListMode: 0=list, 1=details, 2 details edit
string ctable, iconEntityDetails;
bool UseComments = false, YesNo = false;
string fieldType, fieldValue;
string endTD = " </td>";
int nbCommentsRow = 0, MaxLoopXML, MaxLoopSQL, MinLoop, TotalNbRecords = 0;
string htmlRecCount = String.Empty, buffer, buffer1, buffer2;
StringBuilder myHTML = new StringBuilder();
StringBuilder myHTML2 = new StringBuilder();
string[,] fieldFormats;
DataSet ds;
DataTable t = null;
string myLabel;
if (!_DBAllowUpdateDetails && ListMode == 2)
{
ListMode = 1;
}
//set record counts values
MaxLoopSQL = -1;
if (string.IsNullOrEmpty(sql))
{
// PanelDetailsID??? bug qqq
if (detailsLoaded && PanelDetailsIndex > -1 && ds2 != null)
{
t = ds2.Tables[PanelDetailsIndex];
MaxLoopSQL = t.Rows.Count - 1;
}
}
else
{
ds = EvoDB.GetData(sql, SqlConnection, ref ErrorMsg);
if (ds != null)
{
t = ds.Tables[0];
MaxLoopSQL = t.Rows.Count - 1;
}
}
if (sql.Length > 0)
{
if (string.IsNullOrEmpty(ErrorMsg))
{
if (ListMode == 0 && !string.IsNullOrEmpty(def_Data.sppaging))
{
int nbRows = 0;
if (MaxLoopSQL == _RowsPerPage - 1)
{
try
{
nbRows = Convert.ToInt32(t.Rows[0]["MoreRecords"]);
}
catch
{ }
}
if (MaxLoopSQL > -1)
{
TotalNbRecords = _RowsPerPage * (pageID - 1) + nbRows + MaxLoopSQL + 1;
}
else
{
TotalNbRecords = 0;
}
}
else
{
TotalNbRecords = MaxLoopSQL + 1;
}
htmlRecCount = HTMLrecordCount(TotalNbRecords, MaxLoopSQL);
}
else
{
MaxLoopSQL = -1;
TotalNbRecords = MaxLoopSQL + 1;
htmlRecCount = string.Empty;
}
}
if (MaxLoopSQL > -1 || ListMode == 2)
{
MaxLoopXML = aNodeList.Count - 1;
//display result
if (InsidePanel)
{
myHTML.Append("<table class=\"Holder\" cellpadding=\"4\"");
if (PanelDetailsID > -1)
{
myHTML.AppendFormat(" ID=\"{0}{1}P\">", UID, PanelDetailsID);
}
else
{
myHTML.Append(">");
}
}
if (ListMode == 0)
{
//If dbcolumnlead <> String.Empty Then myHTML.Append("<tr><td colspan=""2"">").Append(HTMLAlphabetLinks).Append("</td></tr>")
myHTML.Append("<tr valign=\"top\" class=\"RowInfo\"><td><p>").Append(title);
if (_ShowDesigner && _FormID > 0)
{
myHTML.Append(EvoUI.LinkDesigner(EvoUI.DesType.src, _FormID, title, _PathDesign));
}
myHTML.Append("</p></td><td><p class=\"Right\">");
if (TotalNbRecords > 0 && (_DBAllowExport || _DBAllowMassUpdate))
{
if (_DBAllowExport)
{
htmlRecCount += String.Format(" - {0}", EvoUI.HTMLLinkEventRef("70", EvoLang.Export));
}
#if !DB_MySQL
if (_DBAllowMassUpdate)
{
htmlRecCount += String.Format(" - {0}", EvoUI.HTMLLinkEventRef("80", EvoLang.MassUpdate));
}
#endif
myHTML.Append(htmlRecCount);
}
myHTML.Append("</p></td></tr><tr><td colspan=\"2\">");
}
else if (InsidePanel)
{
myHTML.Append("<tr><td>");
}
if (MaxLoopSQL > -1 || (ListMode == 2 && _DBAllowInsertDetails))
{
myHTML.AppendFormat("<span id=\"{0}{1}p\"><table id=\"EvoEditGrid{1}\"", UID, PanelDetailsID);
myHTML.Append(" class=\"EvoEditGrid\" rules=\"all");
if (ListMode == 0 && ColorTranslator.ToHtml(BackColorRowMouseOver) != string.Empty)
{
myHTML.Append("\" style=\"behavior:url(").Append(_PathPixToolbar).Append("tablehl.htc);\" slcolor=\"#FFFFCC\" hlcolor=\"").Append(ColorTranslator.ToHtml(BackColorRowMouseOver));
}
myHTML.Append("\">");
//1 field only
if (MaxLoopXML == 0)
{
if (aNodeList[0].Attributes[xAttribute.labelList] == null)
{
myLabel = aNodeList[0].Attributes[xAttribute.label].Value;
}
else
{
myLabel = aNodeList[0].Attributes[xAttribute.labelList].Value;
}
}
else
{
myLabel = Tilda;
}
//##### table header
#region "header"
MaxLoopXML = aNodeList.Count - 1;
fieldFormats = new string[MaxLoopXML + 1, 3];
myHTML2.Append("<THEAD><tr class=\"RowHeader\">");
//edit details
if (ListMode == 2)
{
myHTML2.Append("<td width=\"1%\">ID</td>");
endTD = "</td>";
}
for (int j = 0; j <= MaxLoopXML; j++)
{
XmlNode cn = aNodeList[j];
if (cn.NodeType == XmlNodeType.Element)
{
//cache field format
ctable = string.Format(".{0}", cn.Attributes[xAttribute.dbColumnRead].Value);
switch (cn.Attributes[xAttribute.type].Value)
{
case EvoDB.t_text:
case EvoDB.t_pix:
if (ListMode < 2)
{
if (cn.Attributes[xAttribute.link] == null)
{
fieldFormats[j, 0] = string.Empty;
}
else
{
fieldFormats[j, 0] = cn.Attributes[xAttribute.link].Value;
}
if (cn.Attributes[xAttribute.linkTarget] == null)
{
fieldFormats[j, 1] = string.Empty;
}
else
{
fieldFormats[j, 1] = cn.Attributes[xAttribute.linkTarget].Value;
}
}
else
{
fieldFormats[j, 0] = string.Empty;
}
break;
case EvoDB.t_lov:
if (ListMode < 2)
{
ctable = string.Format("@{0}", cn.Attributes[xAttribute.dbColumn].Value);
if (cn.Attributes[xAttribute.link] == null)
{
buffer = string.Empty;
}
else
{
buffer = cn.Attributes[xAttribute.link].Value;
if (buffer.Length > 0)
{
if (cn.Attributes[xAttribute.linkTarget] == null)
{
fieldFormats[j, 1] = string.Empty;
}
else
{
fieldFormats[j, 1] = cn.Attributes[xAttribute.linkTarget].Value;
}
if (cn.Attributes[xAttribute.linkLabel] == null)
{
fieldFormats[j, 2] = string.Empty;
}
else
{
fieldFormats[j, 2] = cn.Attributes[xAttribute.linkLabel].Value;
}
}
}
}
else
{
buffer = string.Empty;
}
fieldFormats[j, 0] = buffer;
break;
case EvoDB.t_int:
case EvoDB.t_dec:
if (ListMode == 2)
{
if (cn.Attributes[xAttribute.dbReadOnly] == null)
{
YesNo = false;
}
else
{
YesNo = cn.Attributes[xAttribute.dbReadOnly].Value.Equals(s1);
}
}
else
{
YesNo = true;
}
if (YesNo)
{
if (cn.Attributes[xAttribute.format] == null)
{
fieldFormats[j, 0] = string.Empty;
}
else
{
fieldFormats[j, 0] = cn.Attributes[xAttribute.format].Value;
}
}
else
{
fieldFormats[j, 0] = string.Empty;
}
break;
case EvoDB.t_date:
case EvoDB.t_time:
case EvoDB.t_datetime:
if (cn.Attributes[xAttribute.format] == null)
{
fieldFormats[j, 0] = EvoTC.DefaultDateFormat(cn.Attributes[xAttribute.type].Value);
}
else
{
fieldFormats[j, 0] = cn.Attributes[xAttribute.format].Value;
if (string.IsNullOrEmpty(fieldFormats[j, 0]))
{
fieldFormats[j, 0] = EvoTC.DefaultDateFormat(cn.Attributes[xAttribute.type].Value);
}
else if (fieldFormats[j, 0].IndexOf("{") < 0)
{
fieldFormats[j, 0] = "{0:" + fieldFormats[j, 0] + "}";
}
}
break;
case EvoDB.t_bool:
if (cn.Attributes[xAttribute.imgList] != null)
{
fieldFormats[j, 0] = cn.Attributes[xAttribute.imgList].Value;
}
if (string.IsNullOrEmpty(fieldFormats[j, 0]))
{
if (cn.Attributes[xAttribute.img] == null)
{
fieldFormats[j, 0] = EvoUI.PixCheck;
}
else
{
fieldFormats[j, 0] = cn.Attributes[xAttribute.img].Value;
if (fieldFormats[j, 0].Length == 0)
{
fieldFormats[j, 0] = EvoUI.PixCheck;
}
}
}
break;
case EvoDB.t_url:
buffer = string.Empty;
if (cn.Attributes[xAttribute.imgList] != null)
{
buffer = cn.Attributes[xAttribute.imgList].Value;
}
if (buffer.Length == 0 && (cn.Attributes[xAttribute.img] != null))
{
buffer = cn.Attributes[xAttribute.img].Value;
}
if (buffer.Length > 0)
{
buffer = _PathPixToolbar + buffer;
}
fieldFormats[j, 0] = buffer;
break;
case EvoDB.t_formula:
ctable = Tilda + cn.Attributes[xAttribute.dbColumnRead].Value;
if (cn.Attributes[xAttribute.format] == null)
{
fieldFormats[j, 0] = string.Empty;
}
else
{
fieldFormats[j, 0] = cn.Attributes[xAttribute.format].Value;
}
break;
default:
fieldFormats[j, 0] = string.Empty;
break;
}
// built header
if (cn.Attributes[xAttribute.labelList] == null)
{
myLabel = cn.Attributes[xAttribute.label].Value;
}
else
{
myLabel = cn.Attributes[xAttribute.labelList].Value;
}
myHTML2.Append("<td>");
if (j == 0 && string.IsNullOrEmpty(myLabel))
{
myHTML2.Append(HTMLlov(cn, cn.Attributes[xAttribute.dbColumnRead].Value, s0, LOVFormat.HTML, 0));
}
else
{
// Label + Flag & Actions (required, designer, sorting)
myHTML2.Append(myLabel);
if (ListMode == 2 && cn.Attributes[xAttribute.required] != null && cn.Attributes[xAttribute.required].Value == s1)
{
myHTML2.Append(EvoUI.HTMLFlagRequired);
}
if (_ShowDesigner)
{
myHTML2.Append(EvoUI.LinkDesigner(EvoUI.DesType.fld, Convert.ToInt32(cn.Attributes[xAttribute.id].Value), myLabel, _PathDesign));
}
if (_AllowSorting && ListMode == 0 && TotalNbRecords > 2)
{
myHTML2.Append(HTMLSortingArrows(ctable));
}
}
myHTML2.Append("</td>");
}
}
myHTML2.Append("</tr></THEAD>");
if (MaxLoopSQL == 0 || MaxLoopXML > 0 || !String.IsNullOrEmpty(myLabel))
{
myHTML.Append(myHTML2);
}
#endregion
//##### table body
myHTML.Append("<TBODY>");
if (ListMode == 2 && (_DBAllowInsertDetails || _DBAllowUpdateDetails) && !_DBReadOnly)
{
genJS.Append(JSEditDetails(aNodeList, PanelDetailsID)); //sets nbFieldEditable
}
if (ListMode == 2 && MaxLoopSQL < 0)
{
myHTML.Append(EvoUI.HTMLemptyRowEdit(MaxLoopXML + 2));
}
else
{
UseComments = EvoDB.ColumnExists(t, SQLColNbComments);
}
iconEntityDetails = string.IsNullOrEmpty(icon) ? string.Empty : EvoUI.HTMLIcon(_PathPixToolbar, icon);
for (int i = 0; i <= MaxLoopSQL; i++)
{
myHTML.Append(EvoUI.TRcssEvenOrOdd(YesNo));
YesNo = !YesNo;
DataRow ri = t.Rows[i];
buffer2 = (ri[dbPrimaryKey].ToString());
if (UseComments)
{
if (ri[SQLColNbComments] != null)
{
try
{
nbCommentsRow = Convert.ToInt32(ri[SQLColNbComments]);
}
catch
{
nbCommentsRow = -1;
}
}
else
{
nbCommentsRow = -1;
}
}
switch (ListMode)
{
case 2:
//details edit
myHTML.AppendFormat("<td>{0}</td>", buffer2);
MinLoop = 0;
break;
case 0:
//search result (master)
myHTML.AppendFormat("<td><a href=\"javascript:EvPost('-{0}')\">", buffer2);
//0=ID
fieldValue = Convert.ToString(ri[aNodeList[0].Attributes[xAttribute.dbColumnRead].Value]);
if (string.IsNullOrEmpty(icon))
{
if (!String.IsNullOrEmpty(dbcolumnicon))
{
buffer = Convert.ToString(ri[dbcolumnicon]);
if (!String.IsNullOrEmpty(buffer))
{
myHTML.Append(EvoUI.HTMLIcon(_PathPix, buffer));
}
}
}
else
{
myHTML.Append(icon);
}
if (String.IsNullOrEmpty(fieldValue))
{
myHTML.AppendFormat("({0})</a>", buffer2);
}
else
{
myHTML.Append(HttpUtility.HtmlEncode(fieldValue)).Append("</a>");
}
if (nbCommentsRow > 0)
{
myHTML.Append(EvoUI.HTMLCommentFlag(nbCommentsRow));
}
myHTML.Append(" </td>");
//If EditLink Then .Append(" <small>[<a href=""Javascript:").Append(Page.GetPostBackEventReference(Me, "e" & buffer2)).Append(""">Edit</a>]<small>")
MinLoop = 1;
break;
default:
//details list=1
MinLoop = 0;
if (string.IsNullOrEmpty(icon) && dbcolumnicon.Length > 0)
{
if (object.ReferenceEquals(ri[dbcolumnicon], DBNull.Value))
{
iconEntityDetails = string.Empty;
}
else
{
iconEntityDetails = EvoUI.HTMLIcon(_PathPix, Convert.ToString(ri[dbcolumnicon]));
}
}
break;
}
for (int j = MinLoop; j <= MaxLoopXML; j++)
{
XmlNode cn = aNodeList[j];
if (cn.NodeType == XmlNodeType.Element)
{
myHTML.Append("<td>");
string dbColumnReadName = cn.Attributes[xAttribute.dbColumnRead].Value;
try
{
if (ri[dbColumnReadName] != null)
{
fieldValue = ri[dbColumnReadName].ToString();
}
else
{
fieldValue = string.Empty;
}
}
catch
{
string newError = string.Format(EvoLang.err_NoDBColumn, dbColumnReadName);
AddError(newError);
fieldValue = string.Empty;
}
fieldType = cn.Attributes[xAttribute.type].Value;
if (!String.IsNullOrEmpty(fieldValue))
{
switch (fieldType)
{
case EvoDB.t_text:
fieldValue = HttpUtility.HtmlEncode(fieldValue);
if (j == MinLoop)
{
if (ListMode == 1 && fieldFormats[j, 0].Length > 0)
{
if (!String.IsNullOrEmpty(iconEntityDetails))
{
fieldValue = iconEntityDetails + fieldValue;
}
myHTML.Append(EvoUI.HTMLLink(EvoUI.Link4itemid(fieldFormats[j, 0], ri[dbPrimaryKey].ToString()), fieldValue));
}
else
{
myHTML.Append(fieldValue);
}
if (UseComments && ListMode > 0 && ri[dbColumnReadName] != null)
{
nbCommentsRow = Convert.ToInt32(ri[SQLColNbComments]);
if (nbCommentsRow > 0)
{
myHTML.Append(EvoUI.HTMLCommentFlag(nbCommentsRow));
}
}
}
else if (ListMode == 1 && fieldFormats[j, 0].Length > 0)
{
myHTML.Append(EvoUI.HTMLLink(EvoUI.Link4itemid(fieldFormats[j, 0], ri[dbPrimaryKey].ToString()), fieldValue, fieldFormats[j, 1], null));
}
else
{
myHTML.Append(fieldValue);
}
break;
case EvoDB.t_lov:
if (ListMode != 2)
{
if (fieldFormats[j, 0].Length > 0)
{
if (fieldFormats[j, 2].Length > 0)
{
fieldValue = fieldFormats[j, 2];
}
//linklabel
fieldValue = EvoUI.HTMLLink(EvoUI.Link4itemid(fieldFormats[j, 0], ri[cn.Attributes[xAttribute.dbColumn].Value].ToString()), fieldValue, fieldFormats[j, 1], null);
}
else if (cn.Attributes[xAttribute.dbColumnIcon] != null)
{
buffer1 = cn.Attributes[xAttribute.dbColumnIcon].Value;
if (buffer1.Length > 0)
{
buffer2 = Convert.ToString(ri[buffer1]);
if (!String.IsNullOrEmpty(buffer2))
{
fieldValue = EvoUI.HTMLImg(_PathPix + buffer2) + EvoUI.HTMLSpace + fieldValue;
}
}
}
}
myHTML.Append(fieldValue);
break;
case EvoDB.t_bool: // format is a picture name here
if (fieldValue.Equals(s1) || fieldValue.Equals("True"))
{
if (fieldFormats[j, 0].Length > 0)
{
myHTML.Append(EvoUI.HTMLSpace).Append(EvoUI.HTMLImg(_PathPixToolbar + fieldFormats[j, 0], EvoLang.Checked));
}
else
{
myHTML.Append(EvoUI.HTMLImgCheckMark(IEbrowser, _PathPixToolbar));
}
}
break;
case EvoDB.t_int:
if (fieldFormats[j, 0].Length > 0 && EvoTC.isInteger(fieldValue))
{
myHTML.Append(EvoUI.noBR(EvoTC.String2Int(fieldValue).ToString(fieldFormats[j, 0])));
}
else
{
myHTML.Append(fieldValue);
}
break;
case EvoDB.t_dec:
if (fieldFormats[j, 0].Length > 0 && EvoTC.isDecimal(fieldValue))
{
myHTML.Append(EvoUI.noBR(EvoTC.String2Dec(fieldValue).ToString(fieldFormats[j, 0])));
}
else
{
myHTML.Append(fieldValue);
}
break;
case EvoDB.t_date:
case EvoDB.t_time:
case EvoDB.t_datetime:
if (fieldFormats[j, 0].Length > 0 && EvoTC.isDate(fieldValue))
{
myHTML.Append(EvoUI.noBR(string.Format(fieldFormats[j, 0], EvoTC.String2DateTime(fieldValue))));
}
else
{
myHTML.Append(HttpUtility.HtmlEncode(fieldValue));
}
break;
case EvoDB.t_url:
fieldValue = HttpUtility.HtmlEncode(fieldValue);
if (fieldFormats[j, 0].Length > 0)
{
myHTML.Append(EvoUI.HTMLLink(fieldValue, string.Empty, inNewBrowser, fieldFormats[j, 0]));
}
else
{
myHTML.Append(EvoUI.HTMLLink(fieldValue, fieldValue, inNewBrowser, null));
}
break;
case EvoDB.t_txtm:
myHTML.Append(EvoTC.Text2HTMLwBR(fieldValue));
break;
case EvoDB.t_doc:
myHTML.Append(EvoUI.HTMLLink(_PathPix + fieldValue, fieldValue, inNewBrowser, null));
break;
case EvoDB.t_pix:
if (ListMode < 2 && fieldFormats[j, 0].Length > 0)
{
myHTML.Append(EvoUI.HTMLLink(EvoUI.Link4itemid(fieldFormats[j, 0], ri[dbPrimaryKey].ToString()), String.Empty, fieldFormats[j, 1], _PathPix + fieldValue));
}
else
{
myHTML.Append(EvoUI.HTMLImg(_PathPix + fieldValue));
}
break;
case EvoDB.t_formula:
if (fieldFormats[j, 0].Length > 0 && EvoTC.isDecimal(fieldValue))
{
myHTML.Append(EvoUI.noBR(EvoTC.String2Dec(fieldValue).ToString(fieldFormats[j, 0])));
}
else
{
myHTML.Append(HttpUtility.HtmlEncode(fieldValue));
}
break;
case EvoDB.t_html: // no escaping for html content
// warning: using html fields may expose to cross-site scripting
myHTML.Append(fieldValue);
break;
default:
myHTML.Append(HttpUtility.HtmlEncode(fieldValue));
break;
}
}
myHTML.Append(endTD);
}
}
myHTML.Append("</tr>");
}
myHTML.Append("</TBODY></table></span>");
//--- FOOTER : buttons + summary + paging navigation ---------------------------------
if (ListMode == 2 & nbFieldEditable > 0)
{
myHTML.Append(HTMLAddDeleteRows(PanelDetailsID));
}
if (ListMode == 0)
{
myHTML.Append("</td></tr><tr class=\"RowFoot\"><td colspan=\"2\">");
}
if (!string.IsNullOrEmpty(def_Data.sppaging))
{
if (ListMode == 0)
{
myHTML.Append(HTMLPagingFullNav(MaxLoopSQL, TotalNbRecords, htmlRecCount));
}
}
else if (TotalNbRecords > 0)
{
myHTML.AppendFormat("<div> {0}</div>", htmlRecCount);
}
if (ListMode == 1 && !(string.IsNullOrEmpty(LinkDetailNew) || _DBReadOnly))
{
myHTML.Append("<p>").Append(EvoUI.HTMLLink(LinkDetailNew.Replace(EvoDB.p_itemid, s0) + "&tdLOVE=1N", EvoLang.NewItem)).Append("</p>");
}
}
if (InsidePanel)
{
myHTML.Append(TdTrTableEnd);
}
}
else
{
myHTML.Append(HTMLNoGrid(ListMode, title, LinkDetailNew));
}
ds = null;
return(myHTML.ToString());
}
