public List <DictionaryEntry> GetDataMapDistinct(string valuefield, string textfield, string condition)
{
if (valuefield.CompareTo(textfield) == 0)
{
TableManager.SetOrder(TableManager.GetParameterName(valuefield));
DataTable table = TableManager.Select(this.GetTableName(), "distinct " + valuefield, condition);
List <DictionaryEntry> maplist = new List <DictionaryEntry>();
foreach (DataRow row in table.Rows)
{
if (Utils.NvStr(row[0]) != "")
{
maplist.Add(new DictionaryEntry(Utils.NvStr(row[0]), Utils.NvStr(row[0])));
}
}
return(maplist);
}
else
{
TableManager.SetOrder(TableManager.GetParameterName(valuefield) + "," + TableManager.GetParameterName(textfield));
DataTable table = TableManager.Select(this.GetTableName(), "distinct " + valuefield + "," + textfield, condition);
List <DictionaryEntry> maplist = new List <DictionaryEntry>();
foreach (DataRow row in table.Rows)
{
maplist.Add(new DictionaryEntry(Utils.NvStr(row[0]), Utils.NvStr(row[1])));
}
return(maplist);
}
}
/// <summary>
/// 生成列表下拉框数据
/// </summary>
/// <param name="tablename"></param>
/// <param name="fieldname"></param>
/// <param name="condition"></param>
/// <param name="allowedit"></param>
/// <returns></returns>
public static string ColComboList(string tablename, string fieldname, string condition, params bool[] allowedit)
{
string strlist = "";
//设置下拉列表是否可以手动修改值
if (allowedit != null && allowedit[0] == true)
{
strlist += "| ";
}
else
{
strlist += " ";
}
TableManager.SetOrder(fieldname);
DataTable table = TableManager.Select(tablename, "distinct " + fieldname, condition);
foreach (DataRow row in table.Rows)
{
if (!string.IsNullOrEmpty(Utils.NvStr(row[0])))
{
strlist += "|" + Utils.NvStr(row[0]);
}
}
return(strlist);
}
/// <summary>
/// 生成列表下拉框数据（含全部选项）
/// </summary>
/// <param name="tablename"></param>
/// <param name="fieldname"></param>
/// <param name="condition"></param>
/// <param name="alltext">默认：全部，可自定义</param>
/// <param name="allowedit"></param>
/// <returns></returns>
public string ColComboList(string fieldname, string condition, string alltext, params bool[] allowedit)
{
string strlist = "";
//设置下拉列表是否可以手动修改值
if (allowedit.Length > 0 && allowedit[0] == true)
{
strlist += "| ";
}
else
{
strlist += " ";
}
//全部
strlist += "|" + (string.IsNullOrEmpty(alltext) ? "全部" : alltext);
TableManager.SetOrder(fieldname);
DataTable table = TableManager.Select(this.GetTableName(), "distinct " + fieldname, condition);
foreach (DataRow row in table.Rows)
{
if (!string.IsNullOrEmpty(Utils.NvStr(row[0])))
{
strlist += "|" + Utils.NvStr(row[0]);
}
}
return(strlist);
}
