comm.cs 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126
  1. using System;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Text.RegularExpressions;
  8. using Infragistics.Win;
  9. using Infragistics.Win.UltraWinEditors;
  10. using Infragistics.Win.UltraWinGrid;
  11. namespace Pur.order
  12. {
  13. class comm
  14. {
  15. /// <summary>
  16. /// 绑定combobox
  17. /// </summary>
  18. /// <param name="cmbx">控件名</param>
  19. /// <param name="dset">数据源ds</param>
  20. /// <param name="strVal">值</param>
  21. /// <param name="strName">显示名</param>
  22. /// <param name="filCondition">筛选条件</param>
  23. /// <param name="tips">是否新增</param>
  24. /// <param name="addItem">新增itemName</param>
  25. public static void FilComboboxAdd(UltraComboEditor cmbx, DataTable dt, string strVal, string strName, string filCondition, Boolean tips, String addItemName, String addItemValue)
  26. {
  27. if (dt.Columns.Count > 1)
  28. {
  29. SetComboItemHeight(cmbx);
  30. DataView dvw = dt.DefaultView;
  31. dvw.RowFilter = filCondition;
  32. ArrayList aryTmp = new ArrayList();
  33. if (tips == true)
  34. {
  35. aryTmp.Add(new ValueListItem(addItemValue, addItemName));
  36. }
  37. for (int i = 0; i < dvw.Count; i++)
  38. {
  39. aryTmp.Add(new ValueListItem(dvw[i][strVal].ToString(), dvw[i][strName].ToString()));
  40. }
  41. cmbx.DataSource = aryTmp;
  42. cmbx.DisplayMember = "DisplayText";
  43. cmbx.ValueMember = "DataValue";
  44. }
  45. }
  46. /// <summary>
  47. /// 设置包含在指定列中的列可编辑
  48. /// </summary>
  49. /// <param name="band"></param>
  50. /// <param name="columnKeys"></param>
  51. public static void SetColumnsActive(UltraGridBand band, params string[] columnKeys)
  52. {
  53. foreach (UltraGridColumn gridColumn in band.Columns)
  54. {
  55. if (columnKeys.Contains(gridColumn.Key) != true)
  56. {
  57. gridColumn.CellActivation = Activation.ActivateOnly;
  58. }
  59. }
  60. }
  61. /// 设置UltraComboEditor中的中文和非中文统一高度。
  62. /// </summary>
  63. /// <param name="cmb"></param>
  64. public static void SetComboItemHeight(UltraComboEditor cmb)
  65. {
  66. foreach (ValueListItem item in cmb.Items)
  67. {
  68. if (Regex.IsMatch(item.DisplayText, @"[\u4e00-\u9fa5]+"))
  69. {
  70. item.Appearance.FontData.SizeInPoints = 9.0F;
  71. }
  72. else
  73. {
  74. item.Appearance.FontData.SizeInPoints = 10.5F;
  75. }
  76. }
  77. }
  78. //激活输入当前值行数据
  79. /// <summary>
  80. /// 激活输入当前值行数据
  81. /// </summary>
  82. /// <param name="ug">ultragrid</param>
  83. /// <param name="strColumn">列名</param>
  84. /// <param name="strKey">列值</param>
  85. public static string doActiveSelRow(UltraGrid ug, string strColumn, string strKey)
  86. {
  87. try
  88. {
  89. if (strKey != "")
  90. {
  91. foreach (UltraGridRow row in ug.Rows)
  92. {
  93. if (row.Cells[strColumn].Text.ToString() == strKey)
  94. {
  95. row.Activated = true;
  96. if (row.ChildBands != null)
  97. row.Expanded = true;
  98. }
  99. }
  100. }
  101. return "";
  102. }
  103. catch (Exception ex)
  104. {
  105. return ex.ToString();
  106. }
  107. }
  108. //验证税率
  109. public static bool isRightRate(object p)
  110. {
  111. if (p == null)
  112. {
  113. return true;
  114. }
  115. String strP = p.ToString().Trim();
  116. if (!Regex.IsMatch(strP, @"^[1-2]{0,1}[0-9]%$"))
  117. {
  118. return true;
  119. }
  120. return false;
  121. }
  122. }
  123. }