using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; namespace WarM { public partial class Kf_InitStockBill : Form { private int HItemIDCol = 0; private int HNumberCol = 0; private int HWHID; public DBUtility.frm_B_BillQueryCondition_New frmCondition; const string ViewName = "h_v_Kf_InitStockBill"; const string ModName = "物料"; public DBUtility.ClsPub.Enum_InputMode InputMode; //录入状态标志(0-非录入状态 1-增加 2-修改) public long HItemID;//项目ID public string sCondition; //过滤条件 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet Ds = new DataSet(); TreeNode CurNode = new TreeNode(); public Kf_InitStockBill() { InitializeComponent(); } //以下代码基本不需要修改 #region 固定代码 //保存GRID列宽 private void Kf_InitStockBill_FormClosing(object sender, FormClosingEventArgs e) { DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name); } //窗体加载 private void Kf_InitStockBill_Load(object sender, EventArgs e) { frmCondition = new DBUtility.frm_B_BillQueryCondition_New(); LoadTree(); initGrid(); InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View; RefreshTool(); } //加载子结点 private void LoadAllNodes(TreeNode sNode) { if (sNode != null) { try { long sName = Convert.ToInt64(sNode.Name.Substring(1, sNode.Name.Length - 1)); sNode.Nodes.Clear(); DataSet Ds = oCn.RunProcReturn("select hitemid,hnumber,hname from Gy_Warehouse where HParentID='" + sName + "'", "Gy_Warehouse"); for (int i = 0; i < Ds.Tables[0].Rows.Count; i++) { TreeNode oNode = sNode.Nodes.Add("T" + Ds.Tables[0].Rows[i]["HItemID"].ToString(), Ds.Tables[0].Rows[i]["HNumber"].ToString() + "-" + Ds.Tables[0].Rows[i]["HName"].ToString(), 0,1); } sNode.Expand(); } catch (Exception e) { MessageBox.Show("加载子项目失败！" + e.Message, "提示"); } } } //加载树形 private void LoadTree() { try { tv.Nodes.Clear(); tv.ImageList = imageList1; TreeNode sNode = tv.Nodes.Add("T0", this.Text, 0, 1); LoadAllNodes(sNode); } catch (Exception e ) { MessageBox.Show("加载树型失败！" + e.Message, "提示"); } } //退出模块 private void tc_Click(object sender, EventArgs e) { this.Close(); } //刷新 private void xs_Click(object sender, EventArgs e) { if (HWHID != 0) { Display(); } } //得到对应列 private Int32 Fun_GetCol(string sCol) { return DBUtility.Gy_BaseFun.Fun_GetCol(sCol, grdMain); } //刷新TOOLBAR private void RefreshTool() { if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_View) { grdMain.Enabled = true; tc.Enabled = true; yl.Enabled = true; } else { grdMain.Enabled = false; tc.Enabled = true; yl.Enabled = false; } } //树型 单击 private void tv_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { if (CurNode.Text != "" && CurNode.Text != "期初录入") { if (MessageBox.Show("是否要保存记录？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { save(); } } CurNode = e.Node; if (CurNode != null) { if (CurNode.Nodes.Count == 0) LoadAllNodes(CurNode); //找到选中结点 FindRow(CurNode.Text); } } //查找结点 private void FindRow(string sCode) { DBUtility.Gy_BaseFun.FindRow(sCode, ModName, ref sCondition); Display(); } //选中行是否正常 //private bool AllowRow() //{ // if (grdMain.Rows >= grdMain.FixedRows && grdMain.Row <= grdMain.Rows - 1) // return true; // else // return false; //} // 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 timer1_Tick(object sender, EventArgs e) { timer1.Enabled = false; if (HWHID != 0) { Display(); } } //初始化GRID private void initGrid() { grdMain.RowTemplate.Height = 18; grdMain.RowTemplate.MinimumHeight = 18; grdMain.ColumnHeadersHeight = 40; grdMain.RowHeadersVisible = false; grdMain.ColumnHeadersVisible = true; grdMain.ColumnCount = 0; grdMain.RowCount = 0; //格式化 //表格设置 grdMain.RowsDefaultCellStyle.SelectionForeColor = Color.White; grdMain.RowsDefaultCellStyle.SelectionBackColor = Color.DarkCyan; grdMain.DefaultCellStyle.SelectionBackColor = Color.DarkCyan; grdMain.DefaultCellStyle.SelectionForeColor = Color.White; grdMain.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight; grdMain.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter; grdMain.SelectionMode = DataGridViewSelectionMode.FullRowSelect; grdMain.ReadOnly = false; grdMain.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing; //允许用户调整列宽 grdMain.EnableHeadersVisualStyles = false; //网格标题 样式 grdMain.AllowUserToAddRows = false; //是否允许自增--否 grdMain.AllowUserToDeleteRows = false; //是否允许删除--否 grdMain.AllowUserToResizeColumns = true; //允许调整列宽--是 grdMain.AllowUserToResizeRows = false; //允许调整行高--否 grdMain.AllowUserToOrderColumns = true; //允许 拖拽列 grdMain.BackgroundColor = Color.White; grdMain.GridColor = Color.LightGray; //网格线颜色 grdMain.ShowCellToolTips = true; grdMain.CellBorderStyle = DataGridViewCellBorderStyle.Raised; //grdMain.ColumnHeadersDefaultCellStyle.BackColor = Color.AliceBlue; // DBUtility.ClsPub.GetGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath);//设置列宽 } //显示列表 private void Display() { SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); DataSet DSet; string sSql = ""; string sWhere = ""; //刷新树形 //LoadTree(); //过滤条件 //sSql = "Select * from " + ViewName + " order by " + ModName + "代码"; sSql = "exec h_p_Kf_InitStockBill " + HWHID; //执行SQL DSet = SubCn.RunProcReturn(sSql, ViewName); //生成首行标题 // for (int i = 0; i < grdMain.ColumnCount; i++) { grdMain.Columns[i].Frozen = false; } // grdMain.DataSource = DSet.Tables[0].DefaultView; //设置可编辑列和合计列 int HMaterNumberCol = Fun_GetCol("物料代码"); int HMaterNameCol = Fun_GetCol("物料名称"); int HMaterModelCol = Fun_GetCol("规格型号"); int HUnitNameCol = Fun_GetCol("单位"); int HPriceCol = Fun_GetCol("单价"); int HQtyCol = Fun_GetCol("数量"); int HMoneyCol = Fun_GetCol("金额"); grdMain.Columns[HMaterNumberCol].ReadOnly = true; grdMain.Columns[HMaterNameCol].ReadOnly = true; grdMain.Columns[HMaterModelCol].ReadOnly = true; grdMain.Columns[HUnitNameCol].ReadOnly = true; double HQty=0; double HMoney=0; double HPrice = 0; for (int i = 0; i < grdMain.RowCount; i++) { HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value); HMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HMoneyCol].Value); HPrice = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HPriceCol].Value); if (HQty == 0) { grdMain.Rows[i].Cells[HPriceCol].Value = 0; } else { HPrice= HMoney / HQty; grdMain.Rows[i].Cells[HPriceCol].Value = HPrice; } grdMain.Rows[i].Cells[HMoneyCol].Value = HMoney; grdMain.Rows[i].Cells[HQtyCol].Value = HQty; } //加载列宽,隐藏列 DBUtility.Gy_BaseFun.DisplayGrid(grdMain, this.Name); } #endregion private void bc_Click(object sender, EventArgs e) { save(); } private void save() { int HMaterIDCol = Fun_GetCol("hmaterid"); int HUnitIDCol = Fun_GetCol("hunitid"); int HBatchNoCol = Fun_GetCol("批次"); int HQtyCol = Fun_GetCol("数量"); int HMoneyCol = Fun_GetCol("金额"); int HRemarkCol = Fun_GetCol("备注"); int HMaterID = 0; int HUnitID = 0; string HBatchNo = ""; double HQty = 0; double HPrice = 0; double HMoney = 0; string HRemark = ""; int HSpID = 0; double HReceiveQty = 0; double HSendQty = 0; double HEndQty = 0; double HReceiveBal = 0; double HSendBal = 0; double HEndBal = 0; int sYear = 0; int sPeriod = 0; DBUtility.ClsPub.Sub_GetPeriodByDate(DBUtility.ClsPub.isDate(DBUtility.ClsPub.GetServerDate(-1), 0), ref sYear, ref sPeriod); oCn.RunProc("delete Kf_InitStockBill where hwhid=" + HWHID); for (int i = 0; i <= grdMain.RowCount - 1; i++) { if (DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HQtyCol].Value) != 0) { // HMaterID = DBUtility.ClsPub.isInt(grdMain.Rows[i].Cells[HMaterIDCol].Value); HUnitID = DBUtility.ClsPub.isInt(grdMain.Rows[i].Cells[HUnitIDCol].Value); HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HQtyCol].Value); HMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[i].Cells[HMoneyCol].Value); HBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HBatchNoCol].Value); HRemark = DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[HRemarkCol].Value); // HSpID = 0; HReceiveQty = 0; HSendQty = 0; HEndQty = 0; HReceiveBal = 0; HSendBal = 0; HEndBal = 0; oCn.RunProc("Insert into Kf_InitStockBill " + " (HYear,HPeriod,HBillType,HDate,HMaterID,HUnitID,HWHID" + ",HBeginQty,HBeginBal,HMaker,HMakeDate" + ",HSpID,HReceiveQty,HSendQty,HEndQty,HReceiveBal,HSendBal,HEndBal" + ",HRemark,HBatchNo)" + " values(" + sYear + "," + sPeriod + ",'1299','" + DBUtility.ClsPub.GetServerDate(-1) + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HWHID.ToString() + "," + HQty.ToString() + "," + HMoney.ToString() + ",'" + DBUtility.ClsPub.CurUserName + "','" + DBUtility.ClsPub.GetServerDate(-1) + "'," + HSpID.ToString() + "," + HReceiveQty.ToString() + "," + HSendQty.ToString() + "," + HEndQty.ToString() + "," + HReceiveBal.ToString() + "," + HSendBal.ToString() + "," + HEndBal.ToString() + ",'" + HRemark + "','" + HBatchNo + "') "); } } } private void grdMain_CellEndEdit(object sender, DataGridViewCellEventArgs e) { int HPriceCol = Fun_GetCol("单价"); int HQtyCol = Fun_GetCol("数量"); int HMoneyCol = Fun_GetCol("金额"); double HPrice = DBUtility.ClsPub.isDoule(grdMain.Rows[e.RowIndex].Cells[HPriceCol].Value); double HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[e.RowIndex].Cells[HQtyCol].Value); double HMoney = DBUtility.ClsPub.isDoule(grdMain.Rows[e.RowIndex].Cells[HMoneyCol].Value); if (e.ColumnIndex == HPriceCol) { HMoney = HPrice * HQty; grdMain.Rows[e.RowIndex].Cells[HMoneyCol].Value = HMoney.ToString(); } else if (e.ColumnIndex == HMoneyCol) { if (HQty == 0) { grdMain.Rows[e.RowIndex].Cells[HPriceCol].Value = 0; } else { HPrice = HMoney / HQty; grdMain.Rows[e.RowIndex].Cells[HPriceCol].Value = HPrice.ToString(); } } } } }