/// <summary>
/// 清空YKDataGridView
/// </summary>
/// <param name="dgv">YKDataGridView控件对象</param>
public static void ClearDGV(YKDataGridView dgv)
{
while (dgv.Rows.Count > 0 && !dgv.Rows[0].IsNewRow)
{
dgv.Rows.RemoveAt(0);
}
}
/// <summary>
/// DGV动态列增加checkbox列
/// </summary>
/// <param name="dgvTemp">DGV</param>
/// <param name="colName">列名</param>
/// <param name="colHeaderText">列头</param>
/// <param name="DataPropertyName">属性</param>
/// <param name="Tag">特殊要求</param>
public static void AddGridColumnCheckBox(YKDataGridView dgvTemp, string colName, string colHeaderText, string DataPropertyName, string Tag)
{
DataGridViewCheckBoxColumn tmpCol = new DataGridViewCheckBoxColumn();
tmpCol.HeaderText = colHeaderText;
tmpCol.Name = colName;
tmpCol.DataPropertyName = DataPropertyName;
tmpCol.Tag = Tag;
dgvTemp.Columns.Add(tmpCol);
}
public static void InitDgvColumnVisible(string dgvName, YKDataGridView dgv)
{
string sqlstr = "SELECT * FROM B_ColumnVisibleSetting WHERE cvsFormName='" + dgvName + "'";
DataTable dt = Com.YKDataClass.getDataTable(sqlstr);
if (dt.Rows.Count > 0)
{
foreach (DataRow row in dt.Rows)
{
if (dgv.Columns.Contains(Convert.ToString(row["cvsColName"])))
{
int iVis = Convert.ToInt32(row["cvsVisible"]);
dgv.Columns[Convert.ToString(row["cvsColName"])].Visible = (iVis == 1 ? true : false);
}
}
}
}
