第八篇

SQL操作数据库的

  #region save dbsql ....

 

public void SaveSheet()

 

private void SaveSheetList()

 

private void SaveSheetListDetails()

 

private void SaveGridListDetails()

 #endregion

 

窗体关闭

 

        protected override void OnFormClosing(FormClosingEventArgs e)
        {
            if (hasDataChange)
            {
                DialogResult result = MessageBox.Show("数据有修改你确定要关闭么", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
                if (result == DialogResult.No)
                {
                    e.Cancel = true;
                    return;
                }
            }
            base.OnFormClosing(e);
        }

 

树删除结点  除自己外都删了 

 

  private void DeleteNodes(TreeListNode aNode, TreeList aList)
        {
            if (aNode == null)
                return;
            if (!aNode.HasChildren)
            {
                if (aNode.Level != 0)
                {
                    // don't remove self
                    aList.DeleteNode(aNode);
                }
            }
            else
            {
                TreeListNodes Nodes = aNode.Nodes;
                for (int i = 0; i < Nodes.Count; )    // remove anode has finish
                {
                    // goto loop
                    DeleteNodes(Nodes[i], aList);
                }
            }
        }

 

 

网格行 自动添加行号

  private int GetMaxLineNo(DataView aView, int ColumnIndex, int maxValue)
        {
            int result = 1;
            if (aView == null || aView.Table.Rows.Count == 0)
                return result;
            foreach (DataRow row in aView.Table.Rows)
            {
                if (row.RowState != DataRowState.Deleted)
                {
                    result = (Convert.ToInt32(row[ColumnIndex]) > result && Convert.ToInt32(row[ColumnIndex]) < maxValue) ? Convert.ToInt32(row[ColumnIndex]) : result;
                }
                else
                {
                    result = (Convert.ToInt32(row[ColumnIndex, DataRowVersion.Original]) > result && Convert.ToInt32(row[ColumnIndex, DataRowVersion.Original]) < maxValue) ? Convert.ToInt32(row[ColumnIndex, DataRowVersion.Original]) : result;
                }
            }
            return result + 1;
        }