using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Linq;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace BLL
|
{
|
public partial class Xt_SystemParameterForOrg : Form
|
{
|
public Xt_SystemParameterForOrg()
|
{
|
InitializeComponent();
|
}
|
|
public const int HInterIDCol = 0;
|
public const int HKeyCol = 1;
|
public const int HOrgIDCol = 2;
|
public const int HOrgNumberCol = 3;
|
public const int HOrgNameCol = 4;
|
public const int HValueCol = 5;
|
public string sHKey;
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
initGrid();
|
Display();
|
}
|
|
private void initGrid()
|
{
|
//
|
grdMain.ColumnCount = 6; //总列数
|
DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
|
//=
|
grdMain.Columns[HOrgNumberCol].HeaderText = "组织代码";
|
grdMain.Columns[HOrgNameCol].HeaderText = "组织名称";
|
grdMain.Columns[HValueCol].HeaderText = "参数值";
|
////固定赋值=====================================================
|
//=============================================================================
|
//格式化
|
|
//设置 手工隐藏
|
DBUtility.ClsPub.HideGridView(grdMain, Name, DBUtility.ClsPub.AppPath);//设置隐藏列
|
////隐藏列
|
grdMain.Columns[HInterIDCol].Visible = false;
|
grdMain.Columns[HKeyCol].Visible = false;
|
grdMain.Columns[HOrgIDCol].Visible = false;
|
//隐藏源单信息
|
//设置可编辑列
|
string sAllowCol = HValueCol.ToString() ;
|
//设置合计列
|
string sTotalCol = "";
|
//格式化网格
|
//DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid);
|
DBUtility.Xt_BaseBillFun.GetGrid(grdMain, this.Name);
|
}
|
|
private void Display()
|
{
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
try
|
{
|
//根据 HKEY 来获取 现有信息
|
DataSet ds = oCn.RunProcReturn("exec h_p_Xt_SystemParameter_GetValue '" + sHKey + "'", "h_p_Xt_SystemParameter_GetValue");
|
if(ds==null)
|
{
|
MessageBox.Show("读取失败1！没有返回任何数据！");
|
return;
|
}
|
if (ds.Tables[0].Rows.Count != 0)
|
{
|
//显示到 表头
|
txtHKey.Text = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HKey"]);
|
txtHCaption.Text = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HCaption"]);
|
txtHValue.Text = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HMainValue"]);
|
txtHExplanation.Text = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HExplanation"]);
|
txtHFarmat.Text = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HFarmat"]);
|
}
|
else
|
{
|
MessageBox.Show("读取失败2！没有返回任何数据！");
|
return;
|
}
|
//显示到 表体
|
grdMain.RowCount = ds.Tables[0].Rows.Count;
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
if (i >= grdMain.RowCount - 1)
|
grdMain.Rows.Add();
|
//单据固定赋值
|
grdMain.Rows[i].Cells[HInterIDCol].Value = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[i]["HInterID"]);
|
grdMain.Rows[i].Cells[HKeyCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HKey"]);
|
grdMain.Rows[i].Cells[HOrgIDCol].Value = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[i]["HOrgID"]);
|
grdMain.Rows[i].Cells[HOrgNumberCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HOrgNumber"]);
|
grdMain.Rows[i].Cells[HOrgNameCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HOrgName"]);
|
grdMain.Rows[i].Cells[HValueCol].Value = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[i]["HValue"]);
|
}
|
}
|
catch(Exception e1)
|
{
|
MessageBox.Show("读取失败！" + e1.Message);
|
|
}
|
|
}
|
|
private void cmdCancel_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
this.Close();
|
}
|
|
private void cmdOK_Click(object sender, EventArgs e)
|
{
|
//保存前判断
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
try
|
{
|
//清除 子表信息
|
oCn.RunProc(" delete from Xt_SystemParameterSub Where HKey= '" + sHKey + "'");
|
//循环写入子表
|
for (int i = 0; i < grdMain.Rows.Count; i++)
|
{
|
if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HValueCol].Value).ToString() !="" &&
|
DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HKeyCol].Value).ToString() !="")
|
{
|
oCn.RunProc(" insert into Xt_SystemParameterSub (HInterID,HValue,HKey,HOrgID) " +
|
" values( " +
|
" " + DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HInterIDCol].Value).ToString() + " " +
|
", '" + DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HValueCol].Value).ToString() + "' " +
|
", '" + DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HKeyCol].Value).ToString() + "' " +
|
", " + DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HOrgIDCol].Value).ToString() + " " +
|
") ");
|
}
|
}
|
MessageBox.Show("保存完毕！");
|
}
|
catch(Exception e1)
|
{
|
MessageBox.Show("保存失败！"+ e1.Message);
|
|
}
|
}
|
|
private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
int i = grdMain.CurrentCell.ColumnIndex;
|
if (i == HKeyCol || i == HOrgNumberCol || i == HOrgNameCol)
|
{
|
e.Cancel = true;
|
}
|
}
|
}
|
}
|
