using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
using Pub_Class;
|
|
namespace PayM
|
{
|
public partial class Pay_OtherMoney_Dlg : Form
|
{
|
public Pay_OtherMoney_Dlg()
|
{
|
InitializeComponent();
|
}
|
//定义
|
public const Int16 HTagCol = 0;
|
public const Int16 HSnoCol = 1;
|
public const Int16 HItemIDCol = 2;
|
public const Int16 HItemNameCol = 3;
|
public const Int16 HMoneyCol = 4;
|
public const Int16 HRemarkCol = 5;
|
public const string ModName = "99999";
|
public const string ModCaption = "其他补扣项目";
|
public const string ModRightName = "Kf_ProductInBill";
|
public const string ModRightNameEdit = ModRightName + "_Edit";
|
public const string ModRightNameCheck = ModRightName + "_Check";
|
public const string ModRightNameClose = ModRightName + "_Close";
|
public const string ModRightNameDelete = ModRightName + "_Delete";
|
public const string ModRightNameHide = ModRightName + "_Hide";
|
public bool BillChange; //
|
public DBUtility.ClsPub.Enum_BillStatus BillStatus;
|
public long HInterID;
|
public string HBillType;
|
public double HMoney;
|
public Int64 KeyID;
|
public bool grdStatus = true;
|
public bool BillRedblue = false;//红蓝单标记
|
DAL.ClsPay_OtherMoney BillNew = new DAL.ClsPay_OtherMoney();
|
public DAL.ClsPay_OtherMoney BillOld = new DAL.ClsPay_OtherMoney();
|
ClsGridViewSum oSumGrid = new ClsGridViewSum();
|
//-------------------------------------------------------------------------
|
#region 固定代码
|
|
private void Total()
|
{
|
oSumGrid.Total();
|
}
|
//清空界面
|
public void Sub_ClearBill()
|
{
|
//清空界面控件 for 控件
|
//foreach (Control ct in P1.Controls)
|
//{
|
// switch (ct.GetType().Name)
|
// {
|
// case "ListBox":
|
// ((ListBox)ct).Items.Clear();
|
// break;
|
// case "CheckBox":
|
// ((CheckBox)ct).Checked = false;
|
// break;
|
// case "RadioButton":
|
|
// break;
|
// case "ComboBox":
|
// ((ComboBox)ct).SelectedIndex = 0;
|
// break;
|
// case "TextBox":
|
// ((TextBox)ct).Text = "";
|
// break;
|
// case "DateTimePicker":
|
// ((DateTimePicker)ct).Value = DateTime.Today;
|
// break;
|
// default:
|
// break;
|
// }
|
//}
|
//
|
initGrid();
|
}
|
|
private void bclk_Click(object sender, EventArgs e)
|
{
|
//保存列宽
|
DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
|
}
|
|
private void mrlk_Click(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
|
}
|
//离开单元格
|
|
private void grdMain_LeaveCell(object sender, EventArgs e)
|
{
|
oSumGrid.LeaveCell();
|
}
|
|
|
private void grdMain_CellValueChanged(object sender, DataGridViewCellEventArgs e)
|
{
|
RowCount(e.RowIndex, 0);
|
}
|
|
//窗体加载
|
private void Pay_OtherMoney_Dlg_Load(object sender, EventArgs e)
|
{
|
//打印初始化
|
oSumGrid.NoCol = HSnoCol;
|
oSumGrid.ogrdMain = grdMain;
|
oSumGrid.oGridsum = grdSum;
|
initGrid();
|
if (this.HBillType == "补贴")
|
{
|
this.Text = "补贴明细";
|
}
|
else
|
{
|
this.Text = "扣款明细";
|
}
|
}
|
|
//退出按钮
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
#endregion
|
|
#region 读写类
|
//显示单据
|
public void Sub_ShowBill()
|
{
|
if (BillOld.ShowBill(HInterID, ref ClsPub.sExeReturnInfo) == false)
|
{
|
MessageBox.Show(ClsPub.sExeReturnInfo, "提示");
|
return;
|
}
|
//
|
//加载表体
|
DAL.ClsGy_DeductItem_View oMater = new DAL.ClsGy_DeductItem_View();
|
DAL.ClsGy_SubsidyItem_View oMater1 = new DAL.ClsGy_SubsidyItem_View();
|
int i = 0;
|
foreach (Model.ClsPay_OtherMoneySub oSub in BillOld.DetailColl)
|
{
|
if (i >= grdMain.RowCount - 1)
|
grdMain.Rows.Add();
|
grdMain.Rows[i].Cells[HSnoCol].Value = i + 1;
|
//
|
grdMain.Rows[i].Cells[HItemIDCol].Value = oSub.HItemID.ToString();
|
if (this.HBillType == "扣款")
|
{
|
if (oMater.GetInfoByID(oSub.HItemID))
|
{
|
grdMain.Rows[i].Cells[HItemNameCol].Value = oMater.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HItemNameCol].Value = "";
|
}
|
}
|
else
|
{
|
if (oMater1.GetInfoByID(oSub.HItemID))
|
{
|
grdMain.Rows[i].Cells[HItemNameCol].Value = oMater1.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HItemNameCol].Value = "";
|
}
|
}
|
//
|
grdMain.Rows[i].Cells[HMoneyCol].Value = oSub.HMoney.ToString();
|
grdMain.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark.ToString();
|
i = i + 1;
|
}
|
}
|
|
//单据完整性判断 未完成
|
private bool Sub_AllowSave()
|
{
|
//明细表是否为零行
|
bool b = false;
|
for (int i = 0; i < grdMain.RowCount; i++)
|
{
|
if (!IsNullRow(i))
|
{
|
b = true;
|
break;
|
}
|
}
|
if (b == false)
|
{
|
MessageBox.Show("明细行不存在！", "提示");
|
return false;
|
}
|
return true;
|
}
|
|
public bool Sub_SaveBill()
|
{
|
if (!Sub_AllowSave())//单据完整性判断
|
return false;
|
this.label1.Focus();
|
this.HMoney = 0;
|
//明细类赋值
|
BillNew.DetailColl = new List<Model.ClsPay_OtherMoneySub>();
|
for (int i = 0; i <= grdMain.RowCount - 1; i++)
|
{
|
if (ClsPub.isLong(grdMain.Rows[i].Cells[HItemIDCol].Value) != 0)
|
{
|
Model.ClsPay_OtherMoneySub oSub = new Model.ClsPay_OtherMoneySub();
|
//
|
oSub.HItemID = ClsPub.isLong(grdMain.Rows[i].Cells[HItemIDCol].Value);
|
oSub.HMoney = ClsPub.isDoule(grdMain.Rows[i].Cells[HMoneyCol].Value);
|
oSub.HRemark = ClsPub.isStrNull(grdMain.Rows[i].Cells[HRemarkCol].Value);
|
oSub.HType = this.HBillType;
|
//
|
this.HMoney = this.HMoney + oSub.HMoney;
|
//
|
BillNew.DetailColl.Add(oSub);
|
}
|
}
|
if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew)
|
{
|
if (BillNew.AddBill(ref ClsPub.sExeReturnInfo))
|
{
|
this.HInterID = BillNew.omodel.HInterID;
|
return true;
|
}
|
else
|
{
|
MessageBox.Show("保存失败!原因:" + ClsPub.sExeReturnInfo, "提示");
|
return false;
|
}
|
}
|
else
|
{
|
if (BillNew.ModifyBill(this.HInterID, ref ClsPub.sExeReturnInfo))
|
{
|
this.HInterID = BillNew.omodel.HInterID;
|
return true;
|
}
|
else
|
{
|
MessageBox.Show("保存失败!原因:" + ClsPub.sExeReturnInfo, "提示");
|
return false;
|
}
|
}
|
}
|
#endregion
|
|
|
#region 窗体处理方法
|
//初始化GRID
|
private void initGrid()
|
{
|
grdMain.ColumnCount = 6; //总列数
|
DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
|
//=
|
grdMain.Columns[HSnoCol].HeaderText = "序号";
|
grdMain.Columns[HItemIDCol].HeaderText = "项目ID"; //标题列 显示名
|
grdMain.Columns[HItemNameCol].HeaderText = "补扣项目";
|
grdMain.Columns[HMoneyCol].HeaderText = "金额";
|
grdMain.Columns[HRemarkCol].HeaderText = "备注";
|
//=============================================================================
|
//格式化
|
////隐藏列
|
grdMain.Columns[HTagCol].Visible = false;
|
grdMain.Columns[HItemIDCol].Visible = false;
|
|
//设置可编辑列
|
string sAllowCol = HMoneyCol.ToString() +
|
"," + HRemarkCol.ToString();
|
//设置合计列
|
string sTotalCol = HMoneyCol.ToString();
|
//格式化网格
|
DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol, oSumGrid);
|
}
|
|
private void RowCount(int sRow, int sTag)
|
{
|
|
}
|
|
//增行按钮 未完成
|
private void AddRow_Click(object sender, EventArgs e)
|
{
|
oSumGrid.Sub_AddRow();
|
}
|
//删行按纽 未完成
|
private void DelRow_Click(object sender, EventArgs e)
|
{
|
}
|
|
//是否是空行
|
private bool IsNullRow(int Row)
|
{
|
if (ClsPub.isLong(grdMain.Rows[Row].Cells[HItemIDCol].Value) == 0)
|
{
|
return true;
|
}
|
return false;
|
}
|
|
#endregion
|
|
private void qr_Click(object sender, EventArgs e)
|
{
|
if (!Sub_SaveBill())
|
{
|
return;
|
}
|
this.Close();
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
if (BillOld.ShowBill(this.HInterID, ref ClsPub.sExeReturnInfo) == false)
|
{
|
this.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_AddNew;
|
Sub_AddBill();
|
}
|
else
|
{
|
this.BillStatus = DBUtility.ClsPub.Enum_BillStatus.BillStatus_Modify;
|
Sub_ShowBill();
|
}
|
}
|
|
private void Sub_AddBill()
|
{
|
DataSet Ds;
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
initGrid();
|
if (this.HBillType == "扣款")
|
{
|
Ds = oCn.RunProcReturn("select * from Gy_DeductItem ", "Gy_DeductItem");
|
}
|
else
|
{
|
Ds = oCn.RunProcReturn("select * from Gy_SubsidyItem ", "Gy_SubsidyItem");
|
}
|
if (Ds.Tables[0].Rows.Count == 0 || Ds == null)
|
{
|
return;
|
}
|
for (int i = 0; i <= Ds.Tables[0].Rows.Count - 1; i++)
|
{
|
grdMain.Rows[i].Cells[HItemIDCol].Value = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HItemID"]);
|
grdMain.Rows[i].Cells[HItemNameCol].Value = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HName"]);
|
}
|
}
|
//帮助函数
|
private void Sub_GridKey(int sKeyCode, int sRow, int sCol, DataGridViewTextBoxEditingControl oEdit)
|
{
|
if (!grdStatus)
|
{
|
return;
|
}
|
oSumGrid.EditStatus = true;
|
switch (sKeyCode)
|
{
|
case 118: //F7
|
{
|
switch (sCol)
|
{
|
default:
|
break;
|
}
|
break;
|
}
|
case 117: //F6
|
{
|
switch (sCol)
|
{
|
default:
|
break;
|
}
|
break;
|
}
|
default:
|
break;
|
}
|
}
|
|
private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
|
{
|
int i = grdMain.CurrentCell.ColumnIndex;
|
if (DBUtility.Xt_BaseBillFun.AllowEdit(grdStatus, oSumGrid, i))
|
{
|
e.Cancel = true;
|
}
|
}
|
|
private void grdMain_CellEndEdit(object sender, DataGridViewCellEventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
RowCount(e.RowIndex, 0); //计算 金额 单价
|
//
|
if (this.EditingControl != null) //释放事件
|
{
|
EditingControl.KeyDown -= new KeyEventHandler(this.EditingControl_KeyDown);
|
this.EditingControl = null;
|
}
|
}
|
|
private void grdMain_CellLeave(object sender, DataGridViewCellEventArgs e)
|
{
|
if (!grdStatus)
|
{
|
return;
|
}
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
//
|
}
|
|
private void grdMain_ColumnWidthChanged(object sender, DataGridViewColumnEventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
}
|
|
private void grdMain_RowHeadersWidthChanged(object sender, EventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
}
|
|
private void grdMain_Scroll(object sender, ScrollEventArgs e)
|
{
|
DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
|
oSumGrid.DisplayCurRow();
|
}
|
|
DataGridViewTextBoxEditingControl EditingControl;
|
private void grdMain_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
|
{
|
if (grdMain.CurrentCell != null)
|
{
|
if (e.Control is DataGridViewTextBoxEditingControl)
|
{
|
this.EditingControl = (DataGridViewTextBoxEditingControl)e.Control;
|
//增加委托处理
|
this.EditingControl.KeyDown += new KeyEventHandler(this.EditingControl_KeyDown);
|
}
|
}
|
}
|
|
private void EditingControl_KeyDown(object sender, KeyEventArgs e)
|
{
|
//业务处理
|
Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, EditingControl);
|
}
|
|
|
|
|
|
|
}
|
}
|
