using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using SQLHelper;
|
using Pub_Class;
|
|
namespace BLL
|
{
|
public partial class Gy_GridView_HideToBase : Form
|
{
|
private int HSnoCol = 0;
|
private int HCellNameCol = 1;//列名
|
private int HShowCol = 2; //是否隐藏
|
private int HDuiQiCol = 3; //对齐方式
|
private int HDecimalCol = 4; //小数位数
|
const string ViewName = " ";
|
public DBUtility.ClsPub.Enum_InputMode InputMode;
|
const string ModName = "网格设置";
|
public long HItemID;//项目ID
|
public string sCondition; //过滤条件
|
ClsCN oCn = new ClsCN();
|
public Pub_Class.ClsPub.Enum_OKTag OKTag;
|
public DataGridView oGrd;
|
public string KeyItem;
|
|
public Gy_GridView_HideToBase()
|
{
|
InitializeComponent();
|
}
|
|
//以下代码基本不需要修改
|
#region 固定代码
|
//保存GRID列宽
|
private void Gy_GridView_HideToBase_FormClosing(object sender, FormClosingEventArgs e)
|
{
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
}
|
//窗体加载
|
private void Gy_GridView_HideToBase_Load(object sender, EventArgs e)
|
{
|
initGrid();
|
InputMode =DBUtility.ClsPub.Enum_InputMode.InputMode_View;
|
RefreshTool();
|
}
|
|
private bool AllowSave()
|
{
|
return true;
|
}
|
//新增
|
private void AddNew()
|
{
|
InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew;
|
Init();
|
}
|
//退出模块
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
//刷新
|
private void xs_Click(object sender, EventArgs e)
|
{
|
Display();
|
}
|
//查询
|
private void cx_Click(object sender, EventArgs e)
|
{
|
Display();
|
}
|
//得到对应列
|
private Int32 Fun_GetCol(string sCol)//Lock
|
{
|
for (int c = 0; c <grdMain.ColumnCount; c++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Columns[c].HeaderText).ToUpper().Trim() == sCol.Trim().ToUpper())
|
{
|
return c;
|
}
|
}
|
return 0;
|
}
|
//刷新TOOLBAR
|
private void RefreshTool()//Lock
|
{
|
if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_View)
|
{
|
stTab.SelectedIndex = 0;
|
stTab.TabPages.Remove(this.tabPage1);
|
stTab.TabPages.Add(this.tabPage1);
|
grdMain.Enabled = true;
|
tc.Enabled = true;
|
xz.Enabled = true;
|
sc.Enabled = true;
|
}
|
else
|
{
|
stTab.SelectedIndex = 1;
|
stTab.TabPages.Remove(this.tabPage1);
|
stTab.TabPages[0].Hide();
|
grdMain.Enabled = false;
|
tc.Enabled = true;
|
xz.Enabled = false;
|
sc.Enabled = false;
|
}
|
}
|
|
//取消按钮
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View;
|
RefreshTool();
|
}
|
|
//全清
|
private void sc_Click(object sender, EventArgs e)
|
{
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
if (grdMain.Rows[i].Visible == true)
|
{
|
grdMain.Rows[i].Cells[HShowCol].Value = false;
|
}
|
}
|
}
|
//全选
|
private void xz_Click(object sender, EventArgs e)
|
{
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
grdMain.Rows[i].Cells[HShowCol].Value = true;
|
}
|
}
|
//修改
|
private void Modify()
|
{
|
if (AllowRow())
|
{
|
InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_Modify;
|
RefreshTool();
|
Init();
|
}
|
}
|
//修改按钮
|
private void xg_Click(object sender, EventArgs e)
|
{
|
|
}
|
//选中行是否正常
|
private bool AllowRow() //Lock
|
{
|
if (grdMain.CurrentRow!=null)
|
return true;
|
else
|
return false;
|
}
|
|
//
|
|
//初始化界面
|
private bool Init()
|
{
|
long sItemID;
|
Sub_Clear();
|
RefreshTool();
|
return true;
|
}
|
|
//保存
|
private bool Save()
|
{
|
if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew)
|
{
|
Display();
|
}
|
if (InputMode ==DBUtility.ClsPub.Enum_InputMode.InputMode_Modify)
|
{
|
Display();
|
}
|
return true;
|
}
|
|
//保存列宽
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
}
|
//默认列宽
|
private void mrlk_Click(object sender, EventArgs e)//Lock
|
{
|
DBUtility.ClsPub.DefaultGridView(grdMain);
|
//参数解释 开始列 ，结束列，是否以最大列宽为准，最小列宽
|
DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);
|
}
|
//时间控件
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
Display();
|
}
|
|
//初始化GRID
|
private void initGrid()
|
{
|
grdMain.AllowUserToResizeRows = false; //允许调整行高--否
|
grdMain.Columns[HSnoCol].Visible = false;
|
grdMain.ReadOnly = false;
|
//加载下拉框列
|
DataGridViewComboBoxColumn sCol = new DataGridViewComboBoxColumn();
|
sCol.HeaderText = "对齐方式";
|
//sCol.ReadOnly = true;
|
sCol.FlatStyle = FlatStyle.Standard;
|
sCol.Items.Add("左对齐");
|
sCol.Items.Add("居中");
|
sCol.Items.Add("右对齐");
|
grdMain.Columns.Add(sCol);
|
|
}
|
//显示列表
|
private void Display() // 幻心
|
{
|
int Cols = 0;
|
char x = Convert.ToChar(",");
|
char s = Convert.ToChar("|");
|
//
|
string sStr = ClsIni.ReadIni("GridHide", KeyItem, DBUtility.ClsPub.AppPath + @"\" + "grdWidth.wyini");
|
for (int c = 0; c <= oGrd.ColumnCount - 1; c++)
|
{
|
if (oGrd.Columns[c].HeaderText.Trim() != "" && oGrd.Columns[c].HeaderText.Substring(0, 1).ToLower() != "h")
|
{
|
grdMain.RowCount = grdMain.RowCount + 1;
|
grdMain.Rows[Cols].Cells[HSnoCol].Value = c;
|
grdMain.Rows[Cols].Cells[HCellNameCol].Value = oGrd.Columns[c].HeaderText;
|
grdMain.Rows[Cols].Cells[HShowCol].Value = 0;
|
Cols++;
|
}
|
}
|
if (sStr != "没有找到！")
|
{
|
string[] sCell = sStr.Split(x);
|
for (int i = 0; i < sCell.Length; i++)
|
{
|
for (int r = 0; r < grdMain.RowCount; r++)
|
{
|
string[] sCol = sCell[i].Split(s);
|
if (ClsPub.isStrNull(grdMain.Rows[r].Cells[HSnoCol].Value) == sCol[0].ToString())
|
{
|
if (sCol.Length > 2)
|
{
|
if (sCol[1].ToString() == "1")
|
{
|
grdMain.Rows[r].Cells[HShowCol].Value = true;
|
}
|
else
|
{
|
grdMain.Rows[r].Cells[HShowCol].Value = false;
|
}
|
}
|
//对齐方式
|
if (sCol.Length > 2)
|
{
|
if (sCol[2].ToString() == "L")
|
{
|
grdMain.Rows[r].Cells[HDuiQiCol].Value = "左对齐";
|
}
|
else if (sCol[2].ToString() == "R")
|
{
|
grdMain.Rows[r].Cells[HDuiQiCol].Value = "右对齐";
|
}
|
else if (sCol[2].ToString() == "M")
|
{
|
grdMain.Rows[r].Cells[HDuiQiCol].Value = "居中";
|
}
|
else
|
{
|
grdMain.Rows[r].Cells[HDuiQiCol].Value = "右对齐";
|
}
|
}
|
else
|
{
|
grdMain.Rows[r].Cells[HDuiQiCol].Value = "右对齐";
|
}
|
}
|
}
|
}
|
}
|
//从数据库读取
|
ClsCN oCn = new ClsCN();
|
DataSet DSet;
|
string sSql = "";
|
sSql = "select * from h_v_Xt_GridParameterList where 操作员='" + DBUtility.ClsPub.CurUserName + "' and 模块名='" + KeyItem + "' and 网格名='" + oGrd.Name.ToString() + "' ";
|
|
DSet = oCn.RunProcReturn(sSql, "h_v_Xt_GridParameterList", ref DBUtility.ClsPub.sExeReturnInfo);
|
for (int c = 0; c <= oGrd.ColumnCount - 1; c++)
|
{
|
if (oGrd.Columns[c].HeaderText.Trim() != "" && oGrd.Columns[c].HeaderText.Substring(0, 1).ToLower() != "h")
|
{
|
grdMain.RowCount = grdMain.RowCount + 1;
|
grdMain.Rows[Cols].Cells[HSnoCol].Value = c;
|
grdMain.Rows[Cols].Cells[HCellNameCol].Value = oGrd.Columns[c].HeaderText;
|
grdMain.Rows[Cols].Cells[HShowCol].Value = 0;
|
Cols++;
|
}
|
}
|
|
|
}
|
|
#endregion
|
|
|
#region 界面控件处理
|
//新增时清空信息
|
private void Sub_Clear() //Lock
|
{
|
HItemID = 0;
|
}
|
|
private void DataBack()
|
{
|
int i;
|
string SaveStr = "";
|
// 失去焦点
|
stTab.Focus();
|
//存入INI
|
for (i = 0; i <= grdMain.RowCount - 1; i++)
|
{
|
if (i == 0)
|
SaveStr = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HSnoCol].Value) + "|" + DBUtility.ClsPub.BoolToString(DBUtility.ClsPub.isBool(grdMain.Rows[i].Cells[HShowCol].Value)) + "|" + ChangeStr(DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HDuiQiCol].Value));
|
else
|
SaveStr = SaveStr + "," + DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HSnoCol].Value) + "|" + DBUtility.ClsPub.BoolToString(DBUtility.ClsPub.isBool(grdMain.Rows[i].Cells[HShowCol].Value)) + "|" + ChangeStr(DBUtility.ClsPub.isStrNull( grdMain.Rows[i].Cells[HDuiQiCol].Value));
|
}
|
ClsIni oIni = new ClsIni();
|
if (ClsIni.WriteIni("GridHide", KeyItem, SaveStr, DBUtility.ClsPub.AppPath + @"\" + "grdWidth.wyini"))
|
SaveStr = "";
|
//存入数据库
|
|
}
|
|
private string ChangeStr(string s)
|
{
|
if (s == "左对齐")
|
{
|
return "L";
|
}
|
if (s == "右对齐")
|
{
|
return "R";
|
}
|
if (s == "居中")
|
{
|
return "M";
|
}
|
//if (s == "L")
|
//{
|
// return "左对齐";
|
//}
|
//if (s == "R")
|
//{
|
// return "右对齐";
|
//}
|
//if (s == "M")
|
//{
|
// return "居中";
|
//}
|
return "R";
|
}
|
|
|
private void fh_Click(object sender, EventArgs e)
|
{
|
DataBack();
|
this.Close();
|
}
|
|
#endregion
|
|
private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
if (e.ColumnIndex == HCellNameCol)
|
{
|
e.Cancel = true; ;
|
}
|
|
}
|
|
|
|
|
|
|
}
|
}
|
