using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using DBUtility; namespace BaseSet { public partial class Gy_Material : Form { private int HItemIDCol = 0; private int HNumberCol = 0; public DBUtility.frm_B_BillQueryCondition_New frmCondition; public const string ViewName = "h_v_Gy_MaterialList"; public string CheckProcName = "h_p_Gy_Material"; //20141020 public string ModName = "物料"; public const string BillName = "Gy_Material"; public const string ModRightNameEdit = BillName + "_Edit"; public const string ModRightNameDelete = BillName + "_Delete"; public DBUtility.ClsPub.Enum_InputMode InputMode; //录入状态标志(0-非录入状态 1-增加 2-修改) public long HItemID;//项目ID public string sCondition; //过滤条件 SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DAL.ClsGy_Material_Ctl oGroup = new DAL.ClsGy_Material_Ctl(); DAL.ClsGy_Material_View oGroupHlp = new DAL.ClsGy_Material_View(); TreeNode CurNode = new TreeNode(); public Gy_Material() { InitializeComponent(); } //以下代码基本不需要修改 #region 固定代码 //保存GRID列宽 private void Gy_Material_FormClosing(object sender, FormClosingEventArgs e) { DBUtility.ClsPub.SaveGridView(grdMain, this.Name, DBUtility.ClsPub.AppPath); } //窗体加载 private void Gy_Material_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) //Lock { DBUtility.Gy_BaseFun.LoadAllNodes(sNode, BillName); } private void LoadTree()//Lock { DBUtility.Gy_BaseFun.LoadTree(tv, imageList1, this.Text, BillName); } //新增 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) { frmCondition = new DBUtility.frm_B_BillQueryCondition_New(); DBUtility.Gy_BaseFun.SetCondition(frmCondition ,ViewName, this.Name ); frmCondition.ShowDialog(); if (frmCondition.Tag.ToString() == "OK") { Display(); } } private Int32 Fun_GetCol(string sCol)//Lock { return DBUtility.Gy_BaseFun.Fun_GetCol(sCol, grdMain); } //刷新TOOLBAR private void RefreshTool()//Lock { if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_View) { stTab.SelectedIndex = 0; stTab.TabPages.Remove(this.tabPage2); stTab.TabPages.Remove(this.tabPage1); stTab.TabPages.Add(this.tabPage1); grdMain.Enabled = true; tc.Enabled = true; yl.Enabled = true; xz.Enabled = true; xg.Enabled = true; sc.Enabled = true; xs.Enabled = true; cx.Enabled = true; fz.Enabled = false; } else { stTab.SelectedIndex = 1; stTab.TabPages.Remove(this.tabPage1); stTab.TabPages.Remove(this.tabPage2); stTab.TabPages.Add(this.tabPage2); stTab.TabPages[0].Hide(); grdMain.Enabled = false; tc.Enabled = true; yl.Enabled = false; xz.Enabled = false; xg.Enabled = false; sc.Enabled = false; xs.Enabled = false; cx.Enabled = false; fz.Enabled = true; } } //删除项目 public void Delete() { //判断权限 if (!ClsPub.Security_Log(ModRightNameDelete, 1, true, DBUtility.ClsPub.CurUserName)) { return; } // if (DBUtility.Gy_BaseFun.AllowRow(grdMain)) { if (MessageBox.Show("确定要删除当前项目？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { //得到HITEMID long sItemID; sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); //判断存在性 if (oGroupHlp.GetInfoByID(sItemID)) { if (oGroup.HavChildCodes(sItemID)) { MessageBox.Show("此项目存在子项目，不能删除！", "提示"); return; } //删除前判断是否 已使用 20141020 if (oGroupHlp.omodel.HUseFlag != "未使用") { MessageBox.Show("此项目已使用或者未检测，不能删除！请重新检测再删除！", "提示"); return; } // if (oGroup.DeleteByID(sItemID)) { //写入日志 ClsPub.Add_Log("", "删除项目，代码：" + oGroupHlp.omodel.HNumber + ",名称：" + oGroupHlp.omodel.HName, ClsPub.CurUserName); //更新上级为 末级 MessageBox.Show("删除项目成功！", "提示"); Display(); } else MessageBox.Show("删除项目失败！" + DBUtility.ClsPub.sExeReturnInfo, "提示"); } } } } //取消按钮 private void cmdCancel_Click(object sender, EventArgs e) { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View; RefreshTool(); } //保存按钮 private void cmdOK_Click(object sender, EventArgs e) { if (!WriteClass()) return; if (Save()) { MessageBox.Show("保存完毕！", "提示"); } else { MessageBox.Show("保存失败！原因：" + DBUtility.ClsPub.sExeReturnInfo, "提示"); } if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_Modify) { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_View; RefreshTool(); } } //树型 单击 private void tv_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { CurNode = e.Node; if (CurNode != null) { if (CurNode.Nodes.Count == 0) LoadAllNodes(CurNode); //找到选中结点 FindRow(CurNode.Text); } } //过滤资料 private void FindRow(string sCode)//Lock { DBUtility.Gy_BaseFun.FindRow(sCode, ModName, ref sCondition); Display(); } //删除 private void sc_Click(object sender, EventArgs e) { Delete(); } //新增按钮 private void xz_Click(object sender, EventArgs e) { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew; label3.Text ="物料资料-正在新增"; Init(); } //修改 private void Modify() { if (DBUtility.Gy_BaseFun.AllowRow(grdMain)) { InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_Modify; RefreshTool(); Init(); } } //修改按钮 private void xg_Click(object sender, EventArgs e) { Modify(); label3.Text = "物料资料-正在修改"; } // private void Sub_Copy() { txtHNumber.Text = ""; txtHHelpCode.Text = ""; HItemID = 0; InputMode = DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew; } //初始化界面 private bool Init() { long sItemID; if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew) { Sub_Clear(); RefreshTool(); return true; } else { //得到HITEMID sItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.CurrentRow.Index].Cells[HItemIDCol].Value); //检查是否存在 if (oGroupHlp.GetInfoByID(sItemID)) { ShowData(sItemID); //txtHNumber.Focus(); return true; } else { MessageBox.Show("您选择的项目已经不存在！" + DBUtility.ClsPub.sExeReturnInfo, "提示"); return false; } } } //保存 private bool Save() { //判断权限 if (!ClsPub.Security_Log(ModRightNameEdit, 1, true, DBUtility.ClsPub.CurUserName)) { return false; } // if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_AddNew) { if (oGroup.AddNew()) { Init(); } else { return false; } Display(); } if (InputMode == DBUtility.ClsPub.Enum_InputMode.InputMode_Modify) { if (!oGroup.ModifyByID(HItemID)) { return false; } 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 grdMain_DblClick(object sender, EventArgs e) { Modify(); } //初始化GRID private void initGrid() { DBUtility.Gy_BaseFun.initGrid(grdMain); } //显示列表 private void Display() // 幻心 { SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); DataSet DSet; string sSql = ""; string sWhere = ""; //刷新树形 //LoadTree(); //过滤条件 if (DBUtility.ClsPub.isStrNull(sCondition) == "" && frmCondition.SqlStr.Trim().Length != 0) { sSql = frmCondition.SqlStr + sWhere + " order by " + ModName + "代码"; } else if (DBUtility.ClsPub.isStrNull(sCondition) != "") { sSql = "Select * from " + ViewName + sCondition + sWhere + " order by " + ModName + "代码"; } else { sSql = "Select * from " + ViewName + " order by " + ModName + "代码"; } //执行SQL DSet = SubCn.RunProcReturn(sSql, ViewName, ref DBUtility.ClsPub.sExeReturnInfo); // if (DSet == null) { MessageBox.Show("显示失败！原因：" + DBUtility.ClsPub.sExeReturnInfo); return; } grdMain.DataSource = DSet.Tables[0].DefaultView; //禁用 红色显示 20141020 Sub_ShowStopFlag(); //加载列宽 DBUtility.Gy_BaseFun.DisplayGrid(grdMain, this.Name); // HItemIDCol = Fun_GetCol("HItemID"); HNumberCol = Fun_GetCol(ModName + "代码"); sCondition = ""; } //复制按钮 private void fz_Click(object sender, EventArgs e) { Sub_Copy(); } //新增时清空信息 private void Sub_Clear() //Lock { DBUtility.Gy_BaseFun.Sub_Clear(tabPage2,ref HItemID, txtHNumber); } private void grdMain_DoubleClick(object sender, EventArgs e) { Modify(); } private void cmdLoadTree_Click(object sender, EventArgs e) { LoadTree(); } #endregion #region 类的读写 private bool AllowSave() { if (txtHNumber.Text.Trim() == "") { MessageBox.Show("物料代码不能为空!", "提示"); return false; } if (txtHName.Text.Trim() == "") { MessageBox.Show("物料名称不能为空!", "提示"); return false; } if (txtHModel.Text.Trim() == "") { MessageBox.Show("规格型号不能为空!", "提示"); return false; } //审核代码是否合理 if (!DBUtility.ClsPub.AllowNumber(txtHNumber.Text.Trim())) { MessageBox.Show("代码中不能出现连续‘.’并且首位末位不能为‘.’！", "提示"); return false; } //是否重复代码 if (oGroup.HavSameNumber(HItemID, txtHNumber.Text.Trim())) { MessageBox.Show("代码重复！", "提示"); return false; } return true; } //读取类 到 控件 private void ShowData(long sItemID) { DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View(); DAL.ClsGy_UnitGroup_View oUtp = new DAL.ClsGy_UnitGroup_View(); DAL.ClsGy_Warehouse_View oWare = new DAL.ClsGy_Warehouse_View(); DAL.ClsGy_Property_View oProp = new DAL.ClsGy_Property_View(); DAL.ClsGy_StockPlace_View oStock = new DAL.ClsGy_StockPlace_View(); DAL.ClsGy_StockPlaceGroup_View oSpg = new DAL.ClsGy_StockPlaceGroup_View(); if (oGroupHlp.GetInfoByID(sItemID)) { txtHNumber.Text = oGroupHlp.omodel.HNumber; txtHName.Text = oGroupHlp.omodel.HName; txtHRemark.Text = oGroupHlp.omodel.HRemark; txtHHelpCode.Text = oGroupHlp.omodel.HHelpCode; txtHUnitID.Tag = Convert.ToInt64(oGroupHlp.omodel.HUnitID.ToString()); if (oUnit.GetInfoByID(oGroupHlp.omodel.HUnitID)) { txtHUnitID.Text = oUnit.omodel.HName; txtHUnitID.Tag = oUnit.omodel.HItemID.ToString(); } else { txtHUnitID.Text = ""; } //------------------- txtHUnitGroupID.Tag = Convert.ToInt64(oGroupHlp.omodel.HUnitGroupID.ToString()); if (oUtp.GetInfoByID(oGroupHlp.omodel.HUnitGroupID)) { txtHUnitGroupID.Text = oUtp.omodel.HName; txtHUnitGroupID.Tag = oUtp.omodel.HItemID.ToString(); } else { txtHUnitGroupID.Text = ""; } //------------------- txtHWhID.Tag = Convert.ToInt64(oGroupHlp.omodel.HWhID.ToString()); if (oWare.GetInfoByID(oGroupHlp.omodel.HWhID)) { txtHWhID.Text = oWare.omodel.HName; txtHWhID.Tag = oWare.omodel.HItemID.ToString(); } else { txtHWhID.Text = ""; } //------------------- txtHSecUnitID.Tag = Convert.ToInt64(oGroupHlp.omodel.HSecUnitID.ToString()); if (oUnit.GetInfoByID(oGroupHlp.omodel.HSecUnitID)) { txtHSecUnitID.Text = oUnit.omodel.HName; txtHSecUnitID.Tag = oUnit.omodel.HItemID.ToString(); } else { txtHSecUnitID.Text = ""; } //------------------- txtHPropertyTypeID.Tag = Convert.ToInt64(oGroupHlp.omodel.HPropertyTypeID.ToString()); if (oProp.GetInfoByID(oGroupHlp.omodel.HPropertyTypeID)) { txtHPropertyTypeID.Text = oProp.omodel.HName; txtHPropertyTypeID.Tag = oProp.omodel.HItemID.ToString(); } else { txtHPropertyTypeID.Text = ""; } //------------------- txtHSPGroupID.Tag = Convert.ToInt64(oGroupHlp.omodel.HSPGroupID.ToString()); if (oSpg.GetInfoByID(oGroupHlp.omodel.HSPGroupID)) { txtHSPGroupID.Text = oSpg.omodel.HName; txtHSPGroupID.Tag = oSpg.omodel.HItemID.ToString(); } else { txtHSPGroupID.Text = ""; } //------------------- txtHSPID.Tag = Convert.ToInt64(oGroupHlp.omodel.HSPID.ToString()); if (oStock.GetInfoByID(oGroupHlp.omodel.HSPID)) { txtHSPID.Text = oStock.omodel.HName; txtHSPID.Tag = oStock.omodel.HItemID.ToString(); } else { txtHSPID.Text = ""; } //------------------- txtHModel.Text = oGroupHlp.omodel.HModel; txtHSecUnitRate.Text = oGroupHlp.omodel.HSecUnitRate.ToString(); txtHHighStock.Text = oGroupHlp.omodel.HHighStock.ToString(); txtHLowStock.Text = oGroupHlp.omodel.HLowStock.ToString(); txtHSafeStock.Text = oGroupHlp.omodel.HSafeStock.ToString(); txtHOrderPrice.Text = oGroupHlp.omodel.HOrderPrice.ToString(); txtHSalePrice.Text = oGroupHlp.omodel.HSalePrice.ToString(); txtHKeepDays.Text = oGroupHlp.omodel.HKeepDays.ToString(); txtHPlanPrice.Text = oGroupHlp.omodel.HPlanPrice.ToString(); txtHstdPrice.Text = oGroupHlp.omodel.HstdPrice.ToString(); txtHQtyMin.Text = oGroupHlp.omodel.HQtyMin.ToString(); txtHQtyMax.Text = oGroupHlp.omodel.HQtyMax.ToString(); txtHVersion.Text = oGroupHlp.omodel.HVersion; txtHSubjoin.Text = oGroupHlp.omodel.HSubjoin; txtHSubjoin2.Text = oGroupHlp.omodel.HSubjoin2; txtHColor.Text = oGroupHlp.omodel.HColor; txtHEngName.Text = oGroupHlp.omodel.HEngName; txtHEngModel.Text = oGroupHlp.omodel.HEngModel; txtHMaterClsID.Text = ""; txtHMaterTypeID.Text = ""; txtHRoutingID.Text = ""; txtHBomID.Text = ""; if (oGroupHlp.omodel.HStopflag) chkHStopflag.Checked = true; else chkHStopflag.Checked = false; HItemID = oGroupHlp.omodel.HItemID; } } //写入类 从控件 private bool WriteClass() { //判断是否允许 保存 if (!AllowSave()) { return false; } //检查父级是否存在 string sParent; sParent = DBUtility.ClsPub.GetParentCode(txtHNumber.Text.Trim()); if (sParent.Trim() == "") { oGroup.oModel.HParentID = 0; } else { if (oGroup.HavParentCode(sParent.Trim(), HItemID)) { oGroup.oModel.HParentID = oGroup.oModel.HItemID; } else { MessageBox.Show("上级代码不存在或被禁用！", "提示"); return false; } } //得到短代码 string sShortNumber; sShortNumber = DBUtility.ClsPub.GetShortNumber(txtHNumber.Text.Trim()); if (sShortNumber.Trim() == "") { return false; } //保存原代码 if (oGroupHlp.GetInfoByID(HItemID)) { oGroup.HOldNumber = oGroupHlp.omodel.HNumber; //是否新代码是自己子项目的　子项目 if (sParent.Length >= oGroup.HOldNumber.Length) { if (sParent.Substring(0, oGroup.HOldNumber.ToString().Length) == oGroup.HOldNumber.Trim()) { MessageBox.Show("新代码不能是自己的下级的子项目！", "提示"); return false; } } } else { oGroup.HOldNumber = ""; } //写入信息 oGroup.oModel.HShortNumber = sShortNumber; oGroup.oModel.HEndFlag = true; oGroup.oModel.HLevel = DBUtility.ClsPub.GetLevel(txtHNumber.Text.Trim()); oGroup.oModel.HNumber = txtHNumber.Text.Trim(); oGroup.oModel.HHelpCode = txtHHelpCode.Text.Trim(); oGroup.oModel.HName = txtHName.Text.Trim(); oGroup.oModel.HStopflag = chkHStopflag.Checked; oGroup.oModel.HRemark = txtHRemark.Text.Trim(); oGroup.oModel.HModel = txtHModel.Text.Trim(); oGroup.oModel.HUnitID = DBUtility.ClsPub.isLong(txtHUnitID.Tag); oGroup.oModel.HMaterClsID = DBUtility.ClsPub.isLong(txtHMaterClsID.Tag); oGroup.oModel.HMaterTypeID = DBUtility.ClsPub.isLong(txtHMaterTypeID.Tag); oGroup.oModel.HUnitGroupID = DBUtility.ClsPub.isLong(txtHUnitGroupID.Tag); oGroup.oModel.HWhID = DBUtility.ClsPub.isLong(txtHWhID.Tag); oGroup.oModel.HRoutingID = DBUtility.ClsPub.isLong(txtHRoutingID.Tag); oGroup.oModel.HBomID = DBUtility.ClsPub.isLong(txtHBomID.Tag); oGroup.oModel.HSecUnitID = DBUtility.ClsPub.isLong(txtHSecUnitID.Tag); oGroup.oModel.HSecUnitRate = DBUtility.ClsPub.isDoule(txtHSecUnitRate.Text); oGroup.oModel.HHighStock = DBUtility.ClsPub.isDoule(txtHHighStock.Text); oGroup.oModel.HLowStock = DBUtility.ClsPub.isDoule(txtHLowStock.Text); oGroup.oModel.HSafeStock = DBUtility.ClsPub.isDoule(txtHSafeStock.Text); oGroup.oModel.HOrderPrice = DBUtility.ClsPub.isDoule(txtHOrderPrice.Text); oGroup.oModel.HSalePrice = DBUtility.ClsPub.isDoule(txtHSalePrice.Text); oGroup.oModel.HKeepDays = DBUtility.ClsPub.isDoule(txtHKeepDays.Text); oGroup.oModel.HPlanPrice = DBUtility.ClsPub.isDoule(txtHPlanPrice.Text); oGroup.oModel.HstdPrice = DBUtility.ClsPub.isDoule(txtHstdPrice.Text); oGroup.oModel.HQtyMin = DBUtility.ClsPub.isDoule(txtHQtyMin.Text); oGroup.oModel.HQtyMax = DBUtility.ClsPub.isDoule(txtHQtyMax.Text); oGroup.oModel.HVersion = txtHVersion.Text.Trim(); oGroup.oModel.HEngName = txtHEngName.Text.Trim(); oGroup.oModel.HEngModel = txtHEngModel.Text.Trim(); oGroup.oModel.HSubjoin = txtHSubjoin.Text.Trim(); oGroup.oModel.HSubjoin2 = txtHSubjoin2.Text.Trim(); oGroup.oModel.HColor = txtHColor.Text.Trim(); oGroup.oModel.HPropertyTypeID = DBUtility.ClsPub.isLong(txtHPropertyTypeID.Tag); oGroup.oModel.HSPGroupID = DBUtility.ClsPub.isLong(txtHSPGroupID.Tag); oGroup.oModel.HSPID = DBUtility.ClsPub.isLong(txtHSPID.Tag); return true; } #endregion #region 界面控件处理 #endregion //检测按钮 20141020 private void jc_Click(object sender, EventArgs e) { BLL.ClsPub_BLL.Sub_CheckUseStatus(grdMain, HItemIDCol, CheckProcName); Display(); } //禁用项目 红色字体 20141020 public void Sub_ShowStopFlag() { BLL.ClsPub_BLL.Sub_ShowStopFlag(grdMain, Fun_GetCol("禁用标记")); } private void cmdHUnitID_Click(object sender, EventArgs e) { DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View(); if (oUnit.RefreshView()) { this.txtHUnitID.Text = oUnit.oModel.HName; this.txtHUnitID.Tag = oUnit.oModel.HItemID.ToString(); } else { this.txtHUnitID.Text = ""; } } private void txtHUnitID_TextChanged(object sender, EventArgs e) { if (txtHUnitID.Text.Length == 0) { txtHUnitID.Tag = "0"; } } private void cmdHUnitGroupID_Click(object sender, EventArgs e) { DAL.ClsGy_UnitGroup_View oUtp = new DAL.ClsGy_UnitGroup_View(); if (oUtp.RefreshView()) { this.txtHUnitGroupID.Text = oUtp.oModel.HName; this.txtHUnitGroupID.Tag = oUtp.oModel.HItemID.ToString(); } else { this.txtHUnitGroupID.Text = ""; } } private void txtHUnitGroupID_TextChanged(object sender, EventArgs e) { if (txtHUnitGroupID.Text.Length == 0) { txtHUnitGroupID.Tag = "0"; } } private void cmdHMaterClsID_Click(object sender, EventArgs e) { } private void txtHMaterClsID_TextChanged(object sender, EventArgs e) { } private void cmdHMaterTypeID_Click(object sender, EventArgs e) { } private void txtHMaterTypeID_TextChanged(object sender, EventArgs e) { } private void cmdHWhID_Click(object sender, EventArgs e) { DAL.ClsGy_Warehouse_View oWare = new DAL.ClsGy_Warehouse_View(); if (oWare.RefreshView()) { this.txtHWhID.Text = oWare.oModel.HName; this.txtHWhID.Tag = oWare.oModel.HItemID.ToString(); } else { this.txtHWhID.Text = ""; } } private void txtHWhID_TextChanged(object sender, EventArgs e) { if (txtHWhID.Text.Length == 0) { txtHWhID.Tag = "0"; } } private void cmdHRoutingID_Click(object sender, EventArgs e) { } private void txtHRoutingID_TextChanged(object sender, EventArgs e) { } private void cmdHBomID_Click(object sender, EventArgs e) { } private void txtHBomID_TextChanged(object sender, EventArgs e) { } private void cmdHSecUnitID_Click(object sender, EventArgs e) { DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View(); if (oUnit.RefreshView()) { this.txtHSecUnitID.Text = oUnit.oModel.HName; this.txtHSecUnitID.Tag = oUnit.oModel.HItemID.ToString(); } else { this.txtHSecUnitID.Text = ""; } } private void txtHSecUnitID_TextChanged(object sender, EventArgs e) { if (txtHSecUnitID.Text.Length == 0) { txtHSecUnitID.Tag = "0"; } } private void cmdHPropertyTypeID_Click(object sender, EventArgs e) { DAL.ClsGy_Property_View oProp = new DAL.ClsGy_Property_View(); if (oProp.RefreshView()) { this.txtHPropertyTypeID.Text = oProp.oModel.HName; this.txtHPropertyTypeID.Tag = oProp.oModel.HItemID.ToString(); } else { this.txtHPropertyTypeID.Text = ""; } } private void txtHPropertyTypeID_TextChanged(object sender, EventArgs e) { if (txtHPropertyTypeID.Text.Length == 0) { txtHPropertyTypeID.Tag = "0"; } } private void cmdHSPGroupID_Click(object sender, EventArgs e) { DAL.ClsGy_StockPlaceGroup_View oSpg = new DAL.ClsGy_StockPlaceGroup_View(); if (oSpg.RefreshView()) { this.txtHSPGroupID.Text = oSpg.oModel.HName; this.txtHSPGroupID.Tag = oSpg.oModel.HItemID.ToString(); } else { this.txtHSPGroupID.Text = ""; } } private void txtHSPGroupID_TextChanged(object sender, EventArgs e) { if (txtHSPGroupID.Text.Length == 0) { txtHSPGroupID.Tag = "0"; } } private void cmdHSPID_Click(object sender, EventArgs e) { DAL.ClsGy_StockPlace_View oStock = new DAL.ClsGy_StockPlace_View(); if (oStock.RefreshView()) { this.txtHSPID.Text = oStock.oModel.HName; this.txtHSPID.Tag = oStock.oModel.HItemID.ToString(); } else { this.txtHSPID.Text = ""; } } private void txtHSPID_TextChanged(object sender, EventArgs e) { if (txtHSPID.Text.Length == 0) { txtHSPID.Tag = "0"; } } } }