using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Windows.Forms;
|
using Pub_Class;
|
|
namespace APSM
|
{
|
public class ClsGridSum
|
{
|
public AxVSFlex7.AxVSFlexGrid ogrdMain=new AxVSFlex7.AxVSFlexGrid();
|
public AxVSFlex7.AxVSFlexGrid oGridsum=new AxVSFlex7.AxVSFlexGrid();
|
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 SetGridsum( )
|
{
|
Int32 i;
|
oGridsum.Enabled = false;
|
oGridsum.Appearance = VSFlex7.AppearanceSettings.flexFlat;
|
oGridsum.BorderStyle = VSFlex7.BorderStyleSettings.flexBorderNone;
|
oGridsum.ScrollBars = VSFlex7.ScrollBarsSettings.flexScrollBarNone;
|
oGridsum.Width = ogrdMain.Width;
|
oGridsum.FixedRows = 0;
|
oGridsum.Rows = 1;
|
oGridsum.Cols = ogrdMain.Cols;
|
oGridsum.LeftCol = ogrdMain.LeftCol;
|
oGridsum.set_RowHeight(0, 300);
|
oGridsum.Height = 30;
|
oGridsum.set_Cell(VSFlex7.CellPropertySettings.flexcpText, 0, 0, 0, oGridsum.Cols - 1, "");
|
oGridsum.set_TextMatrix(0, 0, "合计");
|
oGridsum.set_ColAlignment(-1, VSFlex7.AlignmentSettings.flexAlignCenterCenter);
|
for (i = 0; i < ogrdMain.Cols; i++)
|
{
|
oGridsum.set_ColHidden(i,ogrdMain.get_ColHidden(i));
|
oGridsum.set_ColWidth(i, ogrdMain.get_ColWidth(i));
|
oGridsum.set_ColAlignment(i, ogrdMain.get_ColAlignment(i));
|
oGridsum.set_ColFormat(i, ogrdMain.get_ColFormat(i));
|
}
|
oGridsum.set_ColAlignment(0,VSFlex7.AlignmentSettings.flexAlignCenterTop);
|
for (i = oGridsum.FixedRows; i < oGridsum.Rows - 1; i++)
|
{
|
oGridsum.set_RowHeight(i, oGridsum.Height / oGridsum.Rows);
|
}
|
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.set_TextMatrix(0, ClsPub.isInt(Cols[j]), "");
|
}
|
try
|
{
|
double d = 0;
|
for (j = 0; j < ColsTotal; j++)
|
{
|
d = 0;
|
for (i = ogrdMain.FixedRows; i < ogrdMain.Rows; i++)
|
{
|
//if (ogrdMain.get_TextMatrix(i, 0) == "*")
|
//{
|
if (ogrdMain.get_RowHidden(i) == false)
|
{
|
d = d + ClsPub.isDoule(ogrdMain.get_TextMatrix(i, ClsPub.isInt(Cols[j])));
|
//oGridsum.set_TextMatrix(0, ClsPub.isInt(Cols[j]), Convert.ToString(oGridsum.get_ValueMatrix(0, ClsPub.isInt(Cols[j])) + ogrdMain.get_ValueMatrix(i, ClsPub.isInt(Cols[j]))) );
|
}
|
}
|
//}
|
oGridsum.set_TextMatrix(0, ClsPub.isInt(Cols[j]), d.ToString());
|
}
|
}
|
catch (Exception e)
|
{
|
string s = "";
|
s= e.Message;
|
}
|
}
|
//
|
public void LeaveCell()
|
{
|
if (Changelock)
|
return;
|
OldCell.Col = ogrdMain.Col;
|
OldCell.Row = ogrdMain.Row;
|
}
|
//列是否允许编辑
|
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 (EditStatus == true)
|
//{
|
// return;
|
//}
|
if (ogrdMain.Row < ogrdMain.FixedRows || ogrdMain.Row > ogrdMain.Rows - 1)
|
{
|
return;
|
}
|
if (GetNullRows() < 1)
|
{
|
ogrdMain.AddItem("", ogrdMain.Row);
|
if (ogrdMain.Row != ogrdMain.Rows - 1)
|
{
|
if (ogrdMain.get_TextMatrix(ogrdMain.Row + 1, 0) == "*")
|
{
|
ogrdMain.set_TextMatrix(ogrdMain.Row, 0, "*");
|
}
|
else
|
{
|
ogrdMain.RemoveItem(ogrdMain.Rows - 1);
|
}
|
DisplayCurRow();
|
DisplayCurCol();
|
RefreshNoCol();
|
}
|
}
|
}
|
//删除行
|
public void Sub_DelRow()
|
{
|
int Scqwghz; //原选中行
|
int Scqwglz; //原选中列
|
|
Scqwghz = ogrdMain.Row;
|
Scqwglz = ogrdMain.Col;
|
//if (ClsPub.isStrNull(ogrdMain.get_TextMatrix(Scqwghz, 0))!= "")
|
//{
|
// if (ogrdMain.get_TextMatrix(ogrdMain.Row, 0) == "*")
|
// {
|
|
DisplayCurRow();
|
Changelock = true;
|
ogrdMain.Select(ogrdMain.Row, 0);
|
Changelock = false;
|
ogrdMain.set_Cell(VSFlex7.CellPropertySettings.flexcpBackColor, ogrdMain.Row, 0, ogrdMain.Row, ogrdMain.Cols - 1, 123456);
|
if (MessageBox.Show( "确定要删除当前记录？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
|
{
|
ogrdMain.set_Cell(VSFlex7.CellPropertySettings.flexcpBackColor, ogrdMain.Row, 0, ogrdMain.Row, ogrdMain.Cols - 1, 000000);
|
Changelock = true;
|
ogrdMain.Select(Scqwghz, Scqwglz);
|
Changelock = false;
|
return;
|
}
|
ogrdMain.RemoveItem(ogrdMain.Row);
|
if (ogrdMain.Rows < 50 + ogrdMain.FixedRows + 1)
|
{
|
ogrdMain.AddItem("");
|
}
|
Changelock = true;
|
if (ClsPub.isStrNull(ogrdMain.get_TextMatrix(ogrdMain.Row, 0)) != "*" && ClsPub.isStrNull(ogrdMain.get_TextMatrix(ogrdMain.Row - 1, 0)) == "*")
|
{
|
ogrdMain.Select(ogrdMain.Row-1, Scqwglz);
|
}
|
else
|
{
|
ogrdMain.Select(ogrdMain.Row, Scqwglz);
|
}
|
Changelock = false;
|
RefreshNoCol();
|
// }
|
//}
|
EditStatus = false;
|
}
|
//获得 NULL 行
|
public Int64 GetNullRows()
|
{
|
Int32 r, c;
|
Int32 lngRows;
|
lngRows = 0;
|
for (r = ogrdMain.FixedRows; r < ogrdMain.Rows; r++)
|
{
|
if (ogrdMain.get_TextMatrix(r, 0) == "*")
|
{
|
if (DisplayNoCol== true)
|
{
|
for (c = NoCol + 1; c < ogrdMain.Cols; c++)
|
{
|
if (ogrdMain.get_TextMatrix(r, c) != "" || ogrdMain.get_TextMatrix(r, c) != null)
|
{
|
break;
|
}
|
}
|
}
|
else
|
{
|
for (c =1; c < ogrdMain.Cols; c++)
|
{
|
if (ogrdMain.get_TextMatrix(r, c) != "" || ogrdMain.get_TextMatrix(r, c) != null)
|
{
|
break;
|
}
|
}
|
}
|
if (c == ogrdMain.Cols)
|
lngRows = lngRows + 1;
|
}
|
}
|
return lngRows;
|
}
|
//显示当前行
|
public void DisplayCurRow()
|
{
|
Int64 Toprowte;
|
if (CountNullRows() < 50)
|
ogrdMain.AddItem("");
|
Toprowte = 0;
|
}
|
//计算用户可用行
|
public Int64 CountNullRows()
|
{
|
Int32 r;
|
Int32 lngRows;
|
lngRows = 0;
|
for (r = ogrdMain.FixedRows; r < ogrdMain.Rows; r++)
|
{
|
if (ogrdMain.get_TextMatrix(r, 0) != "*")
|
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;
|
//if (DisplayCurCol==false )
|
//{
|
// return;
|
//}
|
i = 0;
|
m = 0;
|
for (i = ogrdMain.FixedRows; i < ogrdMain.Rows; i++)
|
{
|
m = m + 1;
|
ogrdMain.set_TextMatrix(i, NoCol, m.ToString().Trim());
|
}
|
ogrdMain.set_ColAlignment(NoCol, VSFlex7.AlignmentSettings.flexAlignCenterCenter);
|
}
|
//
|
}
|
}
|
