jQWidgets Forums
Forum Replies Created
-
Thanks for your help Dimitar.
I have tested and it works but if i dont declare as number the field in the source the grid doesn´t shows the currency number correctly with the ‘€’ character.
My solution works also so i prefer to use mine.Anyway i have solved all the problems but is a bit hard to accomplish the job. It would be better if the data adapter recognize the ‘,’ in function of the language we indicate on it.
For filter purposes i have solved the problem also.
As im using this kind of solution for making paging, filter and sort http://www.jqwidgets.com/jquery-widgets-documentation/documentation/asp.net-integration/asp.net-grid-paging-sorting-filtering.htmI have made some changes to the buildfilters so i can manage now this decimal fields (c# solution) correctly.
public static string BuildFilters3(int filtersCount, System.Collections.Specialized.NameValueCollection query)
{
//Sin en and del principio.
var tmpDataField = “”;
var where = ” “;
var tmpFilterOperator = “”;
for (var i = 0; i < filtersCount; i += 1)
{
var filterValue = query.GetValues(“filtervalue” + i)[0];
var filterCondition = query.GetValues(“filtercondition” + i)[0];
var filterDataField = query.GetValues(“filterdatafield” + i)[0];
var filterOperator = query.GetValues(“filteroperator” + i)[0];//Tratamiento para los campos que son decimales para cambiar la , por el . de manera que no de error.
switch(filterDataField)
{
case “ImporteTotalAutorizado”:
filterValue = filterValue.ToString().Replace(‘,’,’.’);
break;
default:
break;
}
if (tmpDataField == “”)
{
tmpDataField = filterDataField;
where += ” ( “;
}
else if (tmpDataField != filterDataField)
{
where += “) AND (“;
}
else if (tmpDataField == filterDataField)
{
if (tmpFilterOperator == “0”)
{
where += ” AND “;
}
else
{
where += ” OR “;
}
}
// build the “WHERE” clause depending on the filter’s condition, value and datafield.
where += GetFilterCondition(filterCondition, filterDataField, filterValue);
if (i == filtersCount – 1)
{
where += “)”;
}
tmpFilterOperator = filterOperator;
tmpDataField = filterDataField;
}
return where;
}