using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Windows.Forms;
|
using System.Drawing;
|
|
namespace Pub_Class
|
{
|
/// <summary>
|
/// 单据 合计网格
|
/// </summary>
|
public class ClsGridViewSum
|
{
|
public DataGridView ogrdMain = new DataGridView();
|
public DataGridView oGridsum = new DataGridView();
|
private string sTotalCols;
|
private string sAllowEdit;
|
public Cell OldCell = new Cell();
|
public bool Changelock;
|
public bool Gdtlock;
|
public bool EditStatus;
|
public bool DisplayNoCol;
|
public Int32 NoCol;
|
public string KeyItem;
|
public bool NotAllowADDRow;
|
public bool NotAllowDELRow;
|
public char chr = Convert.ToChar(",");
|
|
//建立 合计列
|
public void BuildTotalCols(string[] Cols)
|
{
|
Int64 i;
|
string tStr;
|
tStr = "";
|
for (i = 0; i < Cols.Length; i++)
|
{
|
if (i == 0)
|
{
|
tStr = Cols[i];
|
}
|
else
|
{
|
tStr = tStr + "," + Cols[i];
|
}
|
}
|
sTotalCols= tStr;
|
}
|
//建立 可编辑列
|
public void BuildAllowEditCols(string[] Cols)
|
{
|
Int64 i;
|
string tStr;
|
tStr = "";
|
for (i = 0; i < Cols.Length; i++)
|
{
|
if (i == 0)
|
{
|
tStr = Cols[i];
|
}
|
else
|
{
|
tStr = tStr + "," + Cols[i];
|
}
|
}
|
sAllowEdit= tStr;
|
}
|
//设置主网格属性
|
public void SetGridMain()
|
{
|
for(int i=0;i<ogrdMain.Columns.Count;i++)
|
{
|
if (this.FindAllowEditCol(i))
|
{
|
ogrdMain.Columns[i].DefaultCellStyle.BackColor = Color.White;
|
}
|
else
|
{
|
ogrdMain.Columns[i].DefaultCellStyle.BackColor = Color.WhiteSmoke;
|
}
|
}
|
ogrdMain.EnableHeadersVisualStyles = false;
|
ogrdMain.ColumnHeadersHeight = 40; //标题行高
|
ogrdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.LightSteelBlue;
|
ogrdMain.Columns[NoCol].DefaultCellStyle.BackColor = Color.LightSteelBlue;
|
ogrdMain.Columns[NoCol].DefaultCellStyle.SelectionBackColor = Color.LightSteelBlue;
|
ogrdMain.Columns[NoCol].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
|
}
|
|
//设置主网格属性 红字
|
public void SetGridRedMain()
|
{
|
for (int i = 0; i < ogrdMain.Columns.Count; i++)
|
{
|
if (this.FindAllowEditCol(i))
|
{
|
ogrdMain.Columns[i].DefaultCellStyle.BackColor = Color.White;
|
}
|
else
|
{
|
ogrdMain.Columns[i].DefaultCellStyle.BackColor = Color.WhiteSmoke;
|
}
|
}
|
ogrdMain.EnableHeadersVisualStyles = false;
|
ogrdMain.ColumnHeadersHeight = 40; //标题行高
|
ogrdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.LightPink;
|
ogrdMain.Columns[NoCol].DefaultCellStyle.BackColor = Color.LightPink;
|
ogrdMain.Columns[NoCol].DefaultCellStyle.SelectionBackColor = Color.LightPink;
|
ogrdMain.Columns[NoCol].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
|
}
|
|
//设置合计网格属性 幻心
|
public void SetGridsum( )
|
{
|
Int32 i;
|
oGridsum.Enabled = false;
|
oGridsum.Width = ogrdMain.Width;
|
oGridsum.RowHeadersVisible = false;
|
oGridsum.ColumnHeadersVisible = false;
|
oGridsum.RowCount = 1;
|
oGridsum.ColumnCount = ogrdMain.ColumnCount;
|
oGridsum.HorizontalScrollingOffset = ogrdMain.HorizontalScrollingOffset;
|
|
oGridsum.Rows[0].Height = 20;
|
|
oGridsum.Height = 20;
|
for (i = 1; i < oGridsum.ColumnCount; i++)
|
{
|
oGridsum.Rows[0].Cells[i].Value = "";
|
}
|
oGridsum.Rows[0].Cells[0].Value="合计";
|
oGridsum.Rows[0].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
|
oGridsum.Rows[0].DefaultCellStyle.BackColor = Color.Khaki;
|
for (i = 0; i < ogrdMain.ColumnCount; i++)
|
{
|
|
oGridsum.Columns[i].Visible = ogrdMain.Columns[i].Visible;
|
oGridsum.Columns[i].Width = ogrdMain.Columns[i].Width;
|
}
|
oGridsum.Width = ogrdMain.Width ;
|
RefreshNoCol();
|
}
|
//合计函数
|
public void Total()
|
{
|
string[] Cols;
|
Int32 i, j, ColsTotal;
|
if(ClsPub.isStrNull( sTotalCols).ToString().Trim()=="" )
|
return;
|
Cols = sTotalCols.Split(chr);
|
ColsTotal = Cols.Length;
|
for (j = 0; j < ColsTotal; j++) //清空
|
{
|
oGridsum.Rows[0].Cells[j].Value = "";
|
}
|
try
|
{
|
double d = 0;
|
for (j = 0; j < ColsTotal; j++)
|
{
|
d = 0;
|
for (i = 0; i < ogrdMain.RowCount; i++)
|
{
|
d = d + ClsPub.isDoule(ogrdMain.Rows[i].Cells[ClsPub.isInt(Cols[j])].Value);
|
}
|
oGridsum.Rows[0].Cells[ClsPub.isInt(Cols[j])].Value=d.ToString();
|
}
|
}
|
catch (Exception e)
|
{
|
string s = "";
|
s= e.Message;
|
}
|
}
|
//
|
public void LeaveCell()
|
{
|
if (Changelock)
|
return;
|
OldCell.Col = ogrdMain.CurrentCell.ColumnIndex;
|
OldCell.Row = ogrdMain.CurrentRow.Index;
|
}
|
//列是否允许编辑
|
public bool FindAllowEditCol(Int64 Col)
|
{
|
Int64 i;
|
string[] s;
|
if (sAllowEdit.Trim() == "")
|
return false;
|
s=sAllowEdit.Split(chr );
|
for(i=0;i<=s.Length-1;i++)
|
{
|
if(Col==ClsPub.isInt(s[i]))
|
return true;
|
}
|
return false;
|
}
|
//增行
|
public void Sub_AddRow()
|
{
|
if (ogrdMain.CurrentRow==null )
|
{
|
return;
|
}
|
if (GetNullRows() < 1)
|
{
|
ogrdMain.Rows.Insert(ogrdMain.CurrentRow.Index,1);
|
if (ogrdMain.CurrentRow.Index != ogrdMain.RowCount-1)
|
{
|
|
DisplayCurRow();
|
RefreshNoCol();
|
}
|
}
|
}
|
//删除行
|
public void Sub_DelRow()
|
{
|
int Scqwghz; //原选中行
|
int Scqwglz; //原选中列
|
|
Scqwghz = ogrdMain.CurrentRow.Index;
|
Scqwglz = ogrdMain.CurrentCell.ColumnIndex;
|
DisplayCurRow();
|
Changelock = true;
|
Changelock = false;
|
|
ogrdMain.CurrentRow.DefaultCellStyle.BackColor = Color.Red;
|
if (MessageBox.Show( "确定要删除当前记录？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
|
{
|
|
ogrdMain.CurrentRow.DefaultCellStyle.BackColor = Color.White;
|
Changelock = true;
|
Changelock = false;
|
return;
|
}
|
ogrdMain.Rows.RemoveAt(ogrdMain.CurrentRow.Index);
|
ogrdMain.Rows.Add();
|
Changelock = true;
|
Changelock = false;
|
RefreshNoCol();
|
EditStatus = false;
|
}
|
//获得 NULL 行
|
public Int64 GetNullRows()
|
{
|
Int32 r, c;
|
Int32 lngRows;
|
lngRows = 0;
|
for (r = 0; r < ogrdMain.RowCount; r++)
|
{
|
if (ClsPub.isStrNull(ogrdMain.Rows[r].Cells[0].Value) == "*")
|
{
|
if (DisplayNoCol== true)
|
{
|
for (c = NoCol + 1; c < ogrdMain.ColumnCount; c++)
|
{
|
if (ClsPub.isStrNull(ogrdMain.Rows[r].Cells[c].Value )!= "" )
|
{
|
break;
|
}
|
}
|
}
|
else
|
{
|
for (c = 1; c < ogrdMain.ColumnCount; c++)
|
{
|
if (ClsPub.isStrNull(ogrdMain.Rows[r].Cells[c].Value)!= "" )
|
{
|
break;
|
}
|
}
|
}
|
if (c == ogrdMain.ColumnCount)
|
lngRows = lngRows + 1;
|
}
|
}
|
return lngRows;
|
}
|
//显示当前行
|
public void DisplayCurRow()
|
{
|
Int64 Toprowte;
|
if (CountNullRows() < 20)
|
ogrdMain.Rows.Add();
|
Toprowte = 0;
|
}
|
//计算用户可用行
|
public Int64 CountNullRows()
|
{
|
Int32 r;
|
Int32 lngRows;
|
lngRows = 0;
|
for (r = 0; r < ogrdMain.RowCount; r++)
|
{
|
if (ClsPub.isStrNull( ogrdMain.Rows[r].Cells[0].Value)!= "*")
|
lngRows = lngRows + 1;
|
}
|
return lngRows;
|
}
|
|
//显示当前列
|
public void DisplayCurCol()
|
{
|
//Int64 Toprowte;
|
//Toprowte = 0;
|
//while (ogrdMain.CellTop+ogrdMain.get_RowHeight(ogrdMain.Row)+ogrdMain.RowHeightMin>ogrdMain.Size.Height && ogrdMain.TopRow!=Toprowte)
|
//{
|
// Toprowte=ogrdMain.TopRow;
|
// ogrdMain.TopRow=ogrdMain.TopRow+1;
|
//}
|
//Toprowte = 0;
|
//while (ogrdMain.CellTop < ogrdMain.FixedRows * ogrdMain.get_RowHeight(0) && ogrdMain.TopRow != Toprowte)
|
//{
|
|
// Toprowte = ogrdMain.TopRow;
|
// if (ogrdMain.TopRow > 1)
|
// {
|
// ogrdMain.TopRow = ogrdMain.TopRow -1;
|
// }
|
//}
|
}
|
//public void CheckRowData()
|
//{
|
// int r;
|
// if (ogrdMain.Row >= ogrdMain.FixedRows)
|
// {
|
// if (ClsPub.isStrNull(ogrdMain.get_TextMatrix(ogrdMain.Row, 0).ToString()) != "*")
|
// {
|
// for ( r = ogrdMain.FixedRows; r < ogrdMain.Rows; r++)
|
// {
|
// if (ClsPub.isStrNull(ogrdMain.get_TextMatrix(r, 0).ToString()) != "*")
|
// {
|
// if (NotAllowADDRow)
|
// {
|
// Changelock = true;
|
// ogrdMain.Select(r - 1, ogrdMain.Col);
|
// Changelock = false;
|
// return;
|
// }
|
// else
|
// {
|
// break;
|
// }
|
// }
|
// }
|
// //
|
// if (r <= ogrdMain.Rows - 1)
|
// {
|
// Changelock = true;
|
// ogrdMain.Select(r , ogrdMain.Col);
|
// Changelock = false;
|
// }
|
// else
|
// {
|
// Changelock = true;
|
// ogrdMain.Select(ogrdMain.Rows - 1, ogrdMain.Col);
|
// Changelock = false;
|
// }
|
// }
|
// DisplayCurRow();
|
// }
|
//}
|
//刷新行号
|
public void RefreshNoCol()
|
{
|
int i, m;
|
i = 0;
|
m = 0;
|
for (i = 0; i < ogrdMain.RowCount; i++)
|
{
|
m = m + 1;
|
ogrdMain.Rows[i].Cells[NoCol].Value = m.ToString().Trim();
|
}
|
ogrdMain.Columns[NoCol].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
|
}
|
//
|
}
|
}
|
