using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace BLL
|
{
|
/// <summary>
|
/// ·µ»Ø»ù´¡×ÊÁÏÐÅÏ¢ÀàK3
|
/// </summary>
|
public class ClsBaseSelect_K3
|
{
|
|
#region ÉèÖÃÎı¾¿ò
|
|
//³É±¾¶ÔÏó
|
/// <summary>
|
/// ³É±¾¶ÔÏó ·µ»Ø´úÂë
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBycbCostObj_K3(TextBox txt, bool backNumber)
|
{
|
DAL.ClsK3_cbCostObj_View oCost = new DAL.ClsK3_cbCostObj_View();
|
if (oCost.RefreshView())
|
{
|
txt.Text = oCost.oModel.HNumber;
|
txt.Tag = oCost.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹©Ó¦ÉÌ
|
/// <summary>
|
/// ¹©Ó¦ÉÌ ·µ»Ø´úÂë
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySupplier_K3(TextBox txt, bool backNumber)
|
{
|
DAL.ClsK3_Supplier_View oSup = new DAL.ClsK3_Supplier_View();
|
if (oSup.RefreshView())
|
{
|
txt.Text = oSup.oModel.HNumber;
|
txt.Tag = oSup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3Ö°Ô±
|
public static void SetTextByEmp_K3(TextBox txt)
|
{
|
DAL.ClsK3_Employee_View oEmp = new DAL.ClsK3_Employee_View();
|
if (oEmp.RefreshView())
|
{
|
txt.Text = oEmp.oModel.HName;
|
txt.Tag = oEmp.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//³É±¾¶ÔÏó
|
/// <summary>
|
/// ³É±¾¶ÔÏó
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBycbCostObj_K3(TextBox txt)
|
{
|
DAL.ClsK3_cbCostObj_View oCO = new DAL.ClsK3_cbCostObj_View();
|
if (oCO.RefreshView())
|
{
|
txt.Text = oCO.oModel.HName;
|
txt.Tag = oCO.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//Ñ¡ÔñK3²¿ÃÅ
|
/// <summary>
|
/// Ñ¡ÔñK3²¿ÃÅ
|
/// </summary>
|
/// <param name="txt">µÝÈëÎı¾¿ò</param>
|
/// <param name="BackNumber">ÊÇ·ñ·µ»Ø´úÂë</param>
|
public static void SetTextByDept_K3(TextBox txt,bool BackNumber)
|
{
|
DAL.ClsK3_Department_View oDept = new DAL.ClsK3_Department_View();
|
if (oDept.RefreshView())
|
{
|
if (BackNumber==false)
|
{
|
txt.Text = oDept.oModel.HName;
|
txt.Tag = oDept.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = oDept.oModel.HNumber;
|
txt.Tag = oDept.oModel.HItemID.ToString();
|
}
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3²¿ÃÅ
|
/// <summary>
|
/// Ñ¡ÔñK3²¿ÃÅ
|
/// </summary>
|
/// <param name="txt">µÝÈëÎı¾¿ò</param>
|
public static void SetTextByDept_K3(TextBox txt)
|
{
|
DAL.ClsK3_Department_View oDept = new DAL.ClsK3_Department_View();
|
if (oDept.RefreshView())
|
{
|
txt.Text = oDept.oModel.HName;
|
txt.Tag = oDept.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3²Ö¿â
|
public static void SetTextByWareHouse_K3(TextBox txt)
|
{
|
DAL.ClsK3_Warehouse_View oWh = new DAL.ClsK3_Warehouse_View();
|
if (oWh.RefreshView())
|
{
|
txt.Text = oWh.oModel.HName;
|
txt.Tag = oWh.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3²Ö¿â
|
public static void SetTextByWareHouse_K3(TextBox txt,bool BackNumber)
|
{
|
DAL.ClsK3_Warehouse_View oWh = new DAL.ClsK3_Warehouse_View();
|
if (oWh.RefreshView())
|
{
|
txt.Text = oWh.oModel.HNumber;
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3¿Í»§
|
public static void SetTextByCus_K3(TextBox txt)
|
{
|
DAL.ClsK3_Customer_View oCus = new DAL.ClsK3_Customer_View();
|
if (oCus.RefreshView())
|
{
|
txt.Text = oCus.oModel.HName;
|
txt.Tag = oCus.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3°à×é
|
public static void SetTextByGroup_K3(TextBox txt)
|
{
|
DAL.ClsK3_Group_View oGroup = new DAL.ClsK3_Group_View();
|
if (oGroup.RefreshView())
|
{
|
txt.Text = oGroup.oModel.HName;
|
txt.Tag = oGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//Ñ¡ÔñK3¹¤Ðò
|
public static void SetTextByProc_K3(TextBox txt)
|
{
|
DAL.ClsK3_Process_View oProc = new DAL.ClsK3_Process_View();
|
if (oProc.RefreshView())
|
{
|
txt.Text = oProc.oModel.HName;
|
txt.Tag = oProc.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3ÏúÊÛ·½Ê½
|
public static void SetTextBySellStyle_K3(TextBox txt)
|
{
|
DAL.ClsK3_SellStyle_View oSellStyle = new DAL.ClsK3_SellStyle_View();
|
if (oSellStyle.RefreshView())
|
{
|
txt.Text = oSellStyle.oModel.HName;
|
txt.Tag = oSellStyle.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3½áË㷽ʽ
|
public static void SetTextBySettleStyle_K3(TextBox txt)
|
{
|
DAL.ClsK3_SettleStyle_View oSettleStyle = new DAL.ClsK3_SettleStyle_View();
|
if (oSettleStyle.RefreshView())
|
{
|
txt.Text = oSettleStyle.oModel.HName;
|
txt.Tag = oSettleStyle.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3¹©Ó¦ÉÌ
|
public static void SetTextBySupplier_K3(TextBox txt)
|
{
|
DAL.ClsK3_Supplier_View oSup = new DAL.ClsK3_Supplier_View();
|
if (oSup.RefreshView())
|
{
|
txt.Text = oSup.oModel.HName;
|
txt.Tag = oSup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3¼ÆÁ¿µ¥Î»
|
public static void SetTextByUnit_K3(TextBox txt)
|
{
|
DAL.ClsK3_Unit_View oUnit = new DAL.ClsK3_Unit_View();
|
if (oUnit.RefreshView())
|
{
|
txt.Text = oUnit.oModel.HName;
|
txt.Tag = oUnit.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3¼ÆÁ¿µ¥Î»×é
|
public static void SetTextByUnitGroup_K3(TextBox txt)
|
{
|
DAL.ClsK3_UnitGroup_View oUnitGroup = new DAL.ClsK3_UnitGroup_View();
|
if (oUnitGroup.RefreshView())
|
{
|
txt.Text = oUnitGroup.oModel.HName;
|
txt.Tag = oUnitGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3ÎïÁÏÉϼ¶×é
|
public static void SetTextByMaterGroup_K3(TextBox txt)
|
{
|
DAL.ClsK3_MaterGroup_View oMaterGroup = new DAL.ClsK3_MaterGroup_View();
|
if (oMaterGroup.RefreshViewForBig(""))
|
{
|
txt.Text = oMaterGroup.oModel.HNumber;
|
txt.Tag = oMaterGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3ÎïÁÏ
|
/// <summary>
|
/// Ñ¡ÔñK3ÎïÁÏ
|
/// </summary>
|
/// <param name="txtNumber">´úÂëÎı¾¿ò</param>
|
/// <param name="txtName">Ãû³ÆÎı¾¿ò</param>
|
/// <param name="txtModel">¹æ¸ñÎı¾¿ò</param>
|
/// <param name="txtUnit">µ¥Î»Îı¾¿ò</param>
|
public static void SetTextByMater_K3(TextBox txtNumber,TextBox txtName,TextBox txtModel,TextBox txtUnit)
|
{
|
DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();
|
DAL.ClsK3_Unit_View oUnit = new DAL.ClsK3_Unit_View();
|
if (oMater.RefreshView())
|
{
|
if (oMater.GetInfoByID(oMater.oModel.HItemID))
|
{
|
txtNumber.Tag = oMater.omodel.HItemID.ToString();
|
txtNumber.Text = oMater.omodel.HNumber;
|
txtName.Text = oMater.omodel.HName;
|
txtModel.Text = oMater.omodel.HModel;
|
if (oUnit.GetInfoByID(oMater.omodel.HItemID))
|
{
|
txtUnit.Text = oUnit.omodel.HName;
|
txtUnit.Tag = oUnit.omodel.HItemID.ToString();
|
}
|
else
|
{
|
txtUnit.Text ="";
|
txtUnit.Tag = "0";
|
}
|
}
|
}
|
else
|
{
|
txtNumber.Tag = "0";
|
txtNumber.Text = "";
|
txtName.Text = "";
|
txtModel.Text = "";
|
txtUnit.Text = "";
|
txtUnit.Tag = "0";
|
}
|
}
|
|
//Ñ¡ÔñK3ÎïÁÏ
|
/// <summary>
|
/// Ñ¡ÔñK3ÎïÁÏ
|
/// </summary>
|
/// <param name="txtNumber">´úÂëÎı¾¿ò</param>
|
/// <param name="txtName">Ãû³ÆÎı¾¿ò</param>
|
/// <param name="txtModel">¹æ¸ñÎı¾¿ò</param>
|
public static void SetTextByMater_K3(TextBox txtNumber, TextBox txtName, TextBox txtModel)
|
{
|
DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();
|
DAL.ClsK3_Unit_View oUnit = new DAL.ClsK3_Unit_View();
|
if (oMater.RefreshView())
|
{
|
//if (oMater.GetInfoByID(oMater.omodel.HItemID))
|
//{
|
txtNumber.Tag = oMater.omodel.HItemID.ToString();
|
txtNumber.Text = oMater.omodel.HNumber;
|
txtName.Text = oMater.omodel.HName;
|
txtModel.Text = oMater.omodel.HModel;
|
//}
|
}
|
else
|
{
|
txtNumber.Tag = "0";
|
txtNumber.Text = "";
|
txtName.Text = "";
|
txtModel.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3ÎïÁÏ
|
/// <summary>
|
/// Ñ¡ÔñK3ÎïÁÏ
|
/// </summary>
|
/// <param name="txtNumber">´úÂëÎı¾¿ò</param>
|
public static void SetTextByMater_K3(TextBox txtNumber)
|
{
|
DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();
|
if (oMater.RefreshView())
|
{
|
if (oMater.GetInfoByID(oMater.omodel.HItemID))
|
{
|
txtNumber.Tag = oMater.omodel.HItemID.ToString();
|
txtNumber.Text = oMater.omodel.HNumber;
|
|
}
|
else
|
{
|
txtNumber.Tag = "0";
|
txtNumber.Text = "";
|
}
|
}
|
else
|
{
|
txtNumber.Tag = "0";
|
txtNumber.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3±Ò±ð
|
public static void SetTextByCur_K3(TextBox txt,TextBox txtHRate)
|
{
|
DAL.ClsK3_Currency_View oCur = new DAL.ClsK3_Currency_View();
|
if (oCur.RefreshView())
|
{
|
if (oCur.GetInfoByID(oCur.oModel.HItemID))
|
{
|
txt.Text = oCur.omodel.HName;
|
txt.Tag = oCur.omodel.HItemID.ToString();
|
txtHRate.Text = oCur.omodel.HExRate.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
txt.Tag = "0";
|
txtHRate.Text = "1";
|
}
|
}
|
else
|
{
|
txt.Text = "";
|
txt.Tag = "0";
|
txtHRate.Text = "1";
|
}
|
}
|
//Ñ¡ÔñK3ÁìÁϵ¥
|
public static void SetTextByMateOutBill_K3(TextBox txt)
|
{
|
DAL.ClsK3_MateOutBill_View oMateOutBill = new DAL.ClsK3_MateOutBill_View();
|
if (oMateOutBill.RefreshView())
|
{
|
txt.Text = oMateOutBill.oModel.HNumber.ToString();
|
txt.Tag = oMateOutBill.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
//Ñ¡ÔñÁìÁÏÉêÇëµ¥
|
public static void SetTextByMateOutRequestBill_K3(TextBox txt)
|
{
|
DAL.ClsKf_MateOutRequestBill_View oMateOutRequestBill = new DAL.ClsKf_MateOutRequestBill_View();
|
if (oMateOutRequestBill.RefreshView())
|
{
|
txt.Text = oMateOutRequestBill.oModel.HNumber.ToString();
|
txt.Tag = oMateOutRequestBill.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//Ñ¡ÔñÉú²úÈÎÎñµ¥K3
|
public static void SetTextByICMOBill_K3(TextBox txt)
|
{
|
DAL.ClsK3_ICMOBill_View oICMO = new DAL.ClsK3_ICMOBill_View();
|
if (oICMO.RefreshView())
|
{
|
txt.Text = oICMO.oModel.HNumber.ToString();
|
txt.Tag = oICMO.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñK3Éú²ú×ÊÔ´
|
public static void SetTextBySource_K3(TextBox txt)
|
{
|
DAL.ClsK3_Source_View oSource = new DAL.ClsK3_Source_View();
|
if (oSource.RefreshView())
|
{
|
txt.Text = oSource.oModel.HName;
|
txt.Tag = oSource.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
#endregion
|
|
|
#region ÉèÖÃÍø¸ñ
|
|
//ÎïÁÏ-Íø¸ñ
|
/// <summary>
|
/// ÎïÁÏ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HMaterIDCol"></param>
|
/// <param name="HMaterNumberCol"></param>
|
/// <param name="HMaterNameCol"></param>
|
/// <param name="HMaterModelCol"></param>
|
/// <param name="HUnitIDCol"></param>
|
/// <param name="HUnitNumberCol"></param>
|
/// <param name="HUnitNameCol"></param>
|
public static void SetGridByMater_K3(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
|
{
|
DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();
|
DAL.ClsK3_Unit_View oUnit = new DAL.ClsK3_Unit_View();
|
if (oMater.RefreshView())
|
{
|
if (oMater.GetInfoByID(oMater.omodel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
|
grdMain.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
|
if (oUnit.GetInfoByID(oMater.omodel.HUnitID))
|
{
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = oUnit.omodel.HNumber;
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = oUnit.omodel.HName;
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID.ToString();
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
|
}
|
}
|
|
//²Ö¿â-Íø¸ñ
|
/// <summary>
|
/// ²Ö¿â-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HWhIDCol"></param>
|
/// <param name="HWhNumberCol"></param>
|
/// <param name="HWhNameCol"></param>
|
public static void SetGridByWareHouse_K3(DataGridView grdMain, int i, int HWhIDCol, int HWhNumberCol, int HWhNameCol)
|
{
|
DAL.ClsK3_Warehouse_View oWh = new DAL.ClsK3_Warehouse_View();
|
if (oWh.RefreshView())
|
{
|
if (oWh.GetInfoByID(oWh.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HWhIDCol].Value = oWh.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HWhNumberCol].Value = oWh.omodel.HNumber;
|
grdMain.Rows[i].Cells[HWhNameCol].Value = oWh.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HWhIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HWhNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HWhNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HWhIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HWhNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HWhNameCol].Value = "";
|
}
|
}
|
|
|
//ÎïÁÏ-Íø¸ñ
|
/// <summary>
|
/// ÎïÁÏ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HMaterIDCol"></param>
|
/// <param name="HMaterNumberCol"></param>
|
/// <param name="HMaterNameCol"></param>
|
/// <param name="HMaterModelCol"></param>
|
/// <param name="HUnitIDCol"></param>
|
/// <param name="HUnitNumberCol"></param>
|
/// <param name="HUnitNameCol"></param>
|
public static void SetGridByMater_K3(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol, int HQtyDecimalCol, int HPriceDecimalCol)
|
{
|
DAL.ClsK3_Material_View oMater = new DAL.ClsK3_Material_View();
|
DAL.ClsK3_Unit_View oUnit = new DAL.ClsK3_Unit_View();
|
if (oMater.RefreshView())
|
{
|
if (oMater.GetInfoByID(oMater.omodel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
|
grdMain.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
|
grdMain.Rows[i].Cells[HQtyDecimalCol].Value = oMater.omodel.HQtyDecimal;
|
grdMain.Rows[i].Cells[HPriceDecimalCol].Value = oMater.omodel.HPriceDecimal;
|
if (oUnit.GetInfoByID(oMater.omodel.HUnitID))
|
{
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = oUnit.omodel.HNumber;
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = oUnit.omodel.HName;
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID.ToString();
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
|
grdMain.Rows[i].Cells[HQtyDecimalCol].Value = "0";
|
grdMain.Rows[i].Cells[HPriceDecimalCol].Value = "0";
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
|
grdMain.Rows[i].Cells[HQtyDecimalCol].Value = "0";
|
grdMain.Rows[i].Cells[HPriceDecimalCol].Value = "0";
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
|
}
|
}
|
|
//²Öλ-Íø¸ñ
|
/// <summary>
|
/// ²Öλ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSPIDCol"></param>
|
/// <param name="HSPNumberCol"></param>
|
/// <param name="HSPNameCol"></param>
|
public static void SetGridByStockPlace_K3(DataGridView grdMain, int i, int HSPIDCol, int HSPNumberCol, int HSPNameCol)
|
{
|
DAL.ClsK3_StockPlace_View oSP = new DAL.ClsK3_StockPlace_View();
|
if (oSP.RefreshView())
|
{
|
if (oSP.GetInfoByID(oSP.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = oSP.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = oSP.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSPNameCol].Value = oSP.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSPNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSPNameCol].Value = "";
|
}
|
}
|
|
//²Öλ-Íø¸ñ
|
/// <summary>
|
/// ²Öλ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSPIDCol"></param>
|
/// <param name="HSPNumberCol"></param>
|
/// <param name="HSPNameCol"></param>
|
public static void SetGridByStockPlace_K3(DataGridView grdMain, int i,Int64 HMaterID, int HSPIDCol, int HSPNumberCol, int HSPNameCol)
|
{
|
DAL.ClsK3_StockPlace_View oSP = new DAL.ClsK3_StockPlace_View();
|
if (oSP.RefreshViewByRelation(HMaterID))
|
{
|
if (oSP.GetInfoByID(oSP.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = oSP.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = oSP.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSPNameCol].Value = oSP.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSPNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSPNameCol].Value = "";
|
}
|
}
|
|
//²Öλ-Íø¸ñ
|
/// <summary>
|
/// ²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â»ñÈ¡²Öλ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSPIDCol"></param>
|
/// <param name="HSPNumberCol"></param>
|
/// <param name="HSPNameCol"></param>
|
public static void SetGridByStockPlaceToWH_K3(DataGridView grdMain, int i, Int64 HWHID, int HSPIDCol, int HSPNumberCol, int HSPNameCol)
|
{
|
DAL.ClsK3_StockPlace_View oSP = new DAL.ClsK3_StockPlace_View();
|
if (oSP.RefreshViewByWH(HWHID))
|
{
|
if (oSP.GetInfoByID(oSP.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = oSP.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = oSP.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSPNameCol].Value = oSP.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSPNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSPIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSPNameCol].Value = "";
|
}
|
}
|
|
|
//¼ÆÁ¿µ¥Î»-Íø¸ñ
|
/// <summary>
|
/// ¼ÆÁ¿µ¥Î»-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HUnitIDCol"></param>
|
/// <param name="HUnitNumberCol"></param>
|
/// <param name="HUnitNameCol"></param>
|
public static void SetGridByUnit_K3(DataGridView grdMain, int i, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
|
{
|
|
DAL.ClsK3_Unit_View oUnit = new DAL.ClsK3_Unit_View();
|
if (oUnit.RefreshView())
|
{
|
if (oUnit.GetInfoByID(oUnit.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = oUnit.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = oUnit.omodel.HNumber;
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = oUnit.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HUnitIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = "";
|
}
|
}
|
|
|
//¼ÆÁ¿µ¥Î»×é-Íø¸ñ
|
/// <summary>
|
/// ¼ÆÁ¿µ¥Î»×é-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HUnitGroupIDCol"></param>
|
/// <param name="HUnitGroupNumberCol"></param>
|
/// <param name="HUnitGroupNameCol"></param>
|
public static void SetGridByUnitGroup_K3(DataGridView grdMain, int i, int HUnitGroupIDCol, int HUnitGroupNumberCol, int HUnitGroupNameCol)
|
{
|
|
DAL.ClsK3_UnitGroup_View oUnitGroup = new DAL.ClsK3_UnitGroup_View();
|
if (oUnitGroup.RefreshView())
|
{
|
if (oUnitGroup.GetInfoByID(oUnitGroup.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HUnitGroupIDCol].Value = oUnitGroup.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HUnitGroupNumberCol].Value = oUnitGroup.omodel.HNumber;
|
grdMain.Rows[i].Cells[HUnitGroupNameCol].Value = oUnitGroup.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HUnitGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HUnitGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitGroupNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HUnitGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HUnitGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HUnitGroupNameCol].Value = "";
|
}
|
}
|
|
|
//ÎïÁÏÉϼ¶×é-Íø¸ñ
|
/// <summary>
|
/// ÎïÁÏÉϼ¶×é-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HParentIDCol"></param>
|
/// <param name="HParentNumberCol"></param>
|
public static void SetGridByMaterGroup_K3(DataGridView grdMain, int i, int HParentIDCol, int HParentNumberCol,int HParentNameCol)
|
{
|
|
DAL.ClsK3_MaterGroup_View oMaterGroup = new DAL.ClsK3_MaterGroup_View();
|
if (oMaterGroup.RefreshViewForBig(""))
|
{
|
if (oMaterGroup.GetInfoByID(oMaterGroup.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HParentIDCol].Value = oMaterGroup.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HParentNumberCol].Value = oMaterGroup.omodel.HNumber;
|
grdMain.Rows[i].Cells[HParentNameCol].Value = oMaterGroup.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HParentIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HParentNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HParentNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HParentIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HParentNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HParentNameCol].Value = "";
|
}
|
}
|
|
|
//ÎïÁÏÊôÐÔ-Íø¸ñ
|
public static void SetGridByErpCls_K3(DataGridView grdMain, int i, int HErpClsIDCol, int HErpClsNameCol)
|
{
|
|
DAL.ClsK3_ErpCls_View oErpCls = new DAL.ClsK3_ErpCls_View();
|
if (oErpCls.RefreshView())
|
{
|
if (oErpCls.GetInfoByID(oErpCls.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HErpClsIDCol].Value = oErpCls.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HErpClsNameCol].Value = oErpCls.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HErpClsIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HErpClsNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HErpClsIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HErpClsNameCol].Value = "";
|
}
|
}
|
|
|
//²¿ÃÅ-Íø¸ñ
|
/// <summary>
|
/// ²¿ÃÅ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HDeptIDCol"></param>
|
/// <param name="HDeptNumberCol"></param>
|
/// <param name="HDeptNameCol"></param>
|
public static void SetGridByDept_K3(DataGridView grdMain, int i, int HDeptIDCol, int HDeptNumberCol, int HDeptNameCol)
|
{
|
|
DAL.ClsK3_Department_View oDept = new DAL.ClsK3_Department_View();
|
if (oDept.RefreshView())
|
{
|
if (oDept.GetInfoByID(oDept.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HDeptIDCol].Value = oDept.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HDeptNumberCol].Value = oDept.omodel.HNumber;
|
grdMain.Rows[i].Cells[HDeptNameCol].Value = oDept.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDeptIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDeptNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDeptNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDeptIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDeptNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDeptNameCol].Value = "";
|
}
|
}
|
|
//Ö°Ô±-Íø¸ñ
|
/// <summary>
|
/// Ö°Ô±-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HEmpIDCol"></param>
|
/// <param name="HEmpNumberCol"></param>
|
/// <param name="HEmpNameCol"></param>
|
public static void SetGridByEmp_K3(DataGridView grdMain, int i, int HEmpIDCol, int HEmpNumberCol, int HEmpNameCol)
|
{
|
|
DAL.ClsK3_Employee_View oEmp = new DAL.ClsK3_Employee_View();
|
if (oEmp.RefreshView())
|
{
|
if (oEmp.GetInfoByID(oEmp.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HEmpIDCol].Value = oEmp.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HEmpNumberCol].Value = oEmp.omodel.HNumber;
|
grdMain.Rows[i].Cells[HEmpNameCol].Value = oEmp.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HEmpIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HEmpNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HEmpNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HEmpIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HEmpNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HEmpNameCol].Value = "";
|
}
|
}
|
|
//°à×é-Íø¸ñ
|
/// <summary>
|
/// °à×é-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HGroupIDCol"></param>
|
/// <param name="HGroupNumberCol"></param>
|
/// <param name="HGroupNameCol"></param>
|
public static void SetGridByGroup_K3(DataGridView grdMain, int i, int HGroupIDCol, int HGroupNumberCol, int HGroupNameCol)
|
{
|
|
DAL.ClsK3_Group_View oGroup = new DAL.ClsK3_Group_View();
|
if (oGroup.RefreshView())
|
{
|
if (oGroup.GetInfoByID(oGroup.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HGroupIDCol].Value = oGroup.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HGroupNumberCol].Value = oGroup.omodel.HNumber;
|
grdMain.Rows[i].Cells[HGroupNameCol].Value = oGroup.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HGroupNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HGroupNameCol].Value = "";
|
}
|
}
|
|
//³É±¾¶ÔÏó-Íø¸ñ
|
/// <summary>
|
/// ³É±¾¶ÔÏó-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HUnitIDCol"></param>
|
/// <param name="HUnitNumberCol"></param>
|
/// <param name="HUnitNameCol"></param>
|
public static void SetGridBycbCostObj_K3(DataGridView grdMain, int i, int HCostObjIDCol, int HCostObjNumberCol, int HCostObjNameCol)
|
{
|
|
DAL.ClsK3_cbCostObj_View ocbC = new DAL.ClsK3_cbCostObj_View();
|
if (ocbC.RefreshView())
|
{
|
if (ocbC.GetInfoByID(ocbC.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HCostObjIDCol].Value = ocbC.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HCostObjNumberCol].Value = ocbC.omodel.HNumber;
|
grdMain.Rows[i].Cells[HCostObjNameCol].Value = ocbC.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCostObjIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCostObjNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCostObjNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCostObjIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCostObjNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCostObjNameCol].Value = "";
|
}
|
}
|
|
|
|
//ÎïÁÏ·ÖÀà-Íø¸ñ
|
/// <summary>
|
/// ÎïÁÏ·ÖÀà-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HMaterTypeIDCol"></param>
|
/// <param name="HMaterTypeNumberCol"></param>
|
/// <param name="HMaterTypeNameCol"></param>
|
public static void SetGridByMaterType_K3(DataGridView grdMain, int i, int HMaterTypeIDCol, int HMaterTypeNumberCol, int HMaterTypeNameCol)
|
{
|
|
DAL.ClsK3_MaterType_View oMaterType = new DAL.ClsK3_MaterType_View();
|
if (oMaterType.RefreshView())
|
{
|
if (oMaterType.GetInfoByID(oMaterType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HMaterTypeIDCol].Value = oMaterType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HMaterTypeNumberCol].Value = oMaterType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HMaterTypeNameCol].Value = oMaterType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterTypeNameCol].Value = "";
|
}
|
}
|
|
//¹¤Ðò-Íø¸ñ
|
/// <summary>
|
/// ¹¤Ðò-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HProcIDCol"></param>
|
/// <param name="HProcNumberCol"></param>
|
/// <param name="HProcNameCol"></param>
|
public static void SetGridByProc_K3(DataGridView grdMain, int i, int HProcIDCol, int HProcNumberCol, int HProcNameCol)
|
{
|
|
DAL.ClsK3_Process_View oProc = new DAL.ClsK3_Process_View();
|
if (oProc.RefreshView())
|
{
|
if (oProc.GetInfoByID(oProc.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HProcIDCol].Value = oProc.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber;
|
grdMain.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcNameCol].Value = "";
|
}
|
}
|
|
//¹©Ó¦ÉÌ-Íø¸ñ
|
/// <summary>
|
/// ¹©Ó¦ÉÌ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSupIDCol"></param>
|
/// <param name="HSupNumberCol"></param>
|
/// <param name="HSupNameCol"></param>
|
public static void SetGridBySup_K3(DataGridView grdMain, int i, int HSupIDCol, int HSupNumberCol, int HSupNameCol)
|
{
|
|
DAL.ClsK3_Supplier_View oSup = new DAL.ClsK3_Supplier_View();
|
if (oSup.RefreshView())
|
{
|
if (oSup.GetInfoByID(oSup.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSupIDCol].Value = oSup.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSupNumberCol].Value = oSup.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSupNameCol].Value = oSup.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSupNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSupNameCol].Value = "";
|
}
|
}
|
|
|
#endregion
|
}
|
}
|
