using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Windows.Forms;
|
using DBUtility;
|
|
namespace BLL
|
{
|
/// <summary>
|
/// ·µ»Ø»ù´¡×ÊÁÏÐÅÏ¢Àà
|
/// </summary>
|
public class ClsBaseSelect
|
{
|
|
#region ÉèÖÃÎı¾¿ò
|
|
|
//ÎïÁÏ·ÖÀà
|
/// <summary>
|
/// ÎïÁÏ·ÖÀà
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByMaterType(TextBox txt)
|
{
|
DAL.ClsGy_UnitGroup_View oUnitGroup = new DAL.ClsGy_UnitGroup_View();
|
if (oUnitGroup.RefreshView())
|
{
|
txt.Text = oUnitGroup.oModel.HName;
|
txt.Tag = oUnitGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñÖ°Ô±-°´°à×é
|
/// <summary>
|
/// Ñ¡ÔñÖ°Ô±-°´°à×é
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByEmp_Group(TextBox txt, long HGroupID)
|
{
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
|
if (oEmp.RefreshView("and HGroupID=" + HGroupID))
|
{
|
txt.Text = oEmp.oModel.HName;
|
txt.Tag = oEmp.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ðé²Ö²Ö¿â
|
/// <summary>
|
/// ²Ö¿â
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByVirtualWarehouse(TextBox txt)
|
{
|
DAL.ClsGy_VirtualWarehouse_View oWare = new DAL.ClsGy_VirtualWarehouse_View();
|
if (oWare.RefreshView())
|
{
|
txt.Text = oWare.oModel.HName;
|
txt.Tag = oWare.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñÐé²Ö³öÈëÀàÐÍ
|
/// <summary>
|
/// Ñ¡ÔñÐé²Ö³öÈëÀàÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByVirtualStockClass(TextBox txt)
|
{
|
DAL.ClsGy_VirtualStockClass_View oVSC = new DAL.ClsGy_VirtualStockClass_View();
|
if (oVSC.RefreshView())
|
{
|
txt.Text = oVSC.oModel.HName;
|
txt.Tag = oVSC.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¼ì¾ß
|
/// <summary>
|
/// ¼ì¾ß
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByCheckTools(TextBox txt)
|
{
|
DAL.ClsGy_CheckToolsFileMain_View oCheck = new DAL.ClsGy_CheckToolsFileMain_View();
|
if (oCheck.RefreshView())
|
{
|
txt.Text = oCheck.oModel.HName;
|
txt.Tag = oCheck.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡Ôñ»õÔ˹«Ë¾
|
/// <summary>
|
/// Ñ¡Ôñ»õÔ˹«Ë¾
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByConveyComp(TextBox txt)
|
{
|
DAL.ClsGy_ConveyComp_View oConveyComp = new DAL.ClsGy_ConveyComp_View();
|
if (oConveyComp.RefreshView())
|
{
|
txt.Text = oConveyComp.oModel.HName;
|
txt.Tag = oConveyComp.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//Ñ¡Ôñµµ°¸¹ñ
|
/// <summary>
|
/// Ñ¡Ôñµµ°¸¹ñ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByArchivesArk(TextBox txt)
|
{
|
DAL.ClsGy_ArchivesArk_View oArchivesArk = new DAL.ClsGy_ArchivesArk_View();
|
if (oArchivesArk.RefreshView())
|
{
|
txt.Text = oArchivesArk.oModel.HName;
|
txt.Tag = oArchivesArk.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡Ôñµµ°¸²ã
|
/// <summary>
|
/// Ñ¡Ôñµµ°¸²ã
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByArchivesFloor(TextBox txt)
|
{
|
DAL.ClsGy_ArchivesFloor_View oArchivesFloor = new DAL.ClsGy_ArchivesFloor_View();
|
if (oArchivesFloor.RefreshView())
|
{
|
txt.Text = oArchivesFloor.oModel.HName;
|
txt.Tag = oArchivesFloor.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñµØÇø
|
/// <summary>
|
/// Ñ¡ÔñµØÇø
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByAreaSet(TextBox txt)
|
{
|
DAL.ClsGy_AreaSet_View oAreaSet = new DAL.ClsGy_AreaSet_View();
|
if (oAreaSet.RefreshView())
|
{
|
txt.Text = oAreaSet.omodel.HName;
|
txt.Tag = oAreaSet.omodel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//²»Á¼ÔÒò
|
/// <summary>
|
/// ²»Á¼ÔÒò
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByBadReason(TextBox txt)
|
{
|
DAL.ClsGy_BadReason_View oBadReason = new DAL.ClsGy_BadReason_View();
|
if (oBadReason.RefreshView())
|
{
|
txt.Text = oBadReason.oModel.HName;
|
txt.Tag = oBadReason.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//ÒøÐÐ
|
/// <summary>
|
/// ÒøÐÐ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByBank(TextBox txt)
|
{
|
DAL.ClsGy_Bank_View oBank = new DAL.ClsGy_Bank_View();
|
if (oBank.RefreshView())
|
{
|
txt.Text = oBank.oModel.HName;
|
txt.Tag = oBank.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//³µÁ¾
|
/// <summary>
|
/// ³µÁ¾
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByCar(TextBox txt)
|
{
|
DAL.ClsGy_Car_View oCar = new DAL.ClsGy_Car_View();
|
if (oCar.RefreshView())
|
{
|
txt.Text = oCar.oModel.HName;
|
txt.Tag = oCar.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¼¯Ìå¼Æ¼þ·½°¸
|
/// <summary>
|
/// ¼¯Ìå¼Æ¼þ·½°¸
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByClassTimePrjGroup(TextBox txt)
|
{
|
DAL.ClsGy_ClassTimePrjGroup_View oCTPG = new DAL.ClsGy_ClassTimePrjGroup_View();
|
if (oCTPG.RefreshView())
|
{
|
txt.Text = oCTPG.oModel.HName;
|
txt.Tag = oCTPG.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹«Ë¾ÐÔÖÊ
|
/// <summary>
|
/// ¹«Ë¾ÐÔÖÊ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByComKind(TextBox txt)
|
{
|
DAL.ClsGy_ComKind_View oComKind = new DAL.ClsGy_ComKind_View();
|
if (oComKind.RefreshView())
|
{
|
txt.Text = oComKind.oModel.HName;
|
txt.Tag = oComKind.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹«Ë¾¹æÄ£
|
/// <summary>
|
/// ¹«Ë¾¹æÄ£
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByComScope(TextBox txt)
|
{
|
DAL.ClsGy_ComScope_View oComScope = new DAL.ClsGy_ComScope_View();
|
if (oComScope.RefreshView())
|
{
|
txt.Text = oComScope.oModel.HName;
|
txt.Tag = oComScope.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹«Ë¾Àà±ð
|
/// <summary>
|
/// ¹«Ë¾Àà±ð
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByComSort(TextBox txt)
|
{
|
DAL.ClsGy_ComSort_View oComSort = new DAL.ClsGy_ComSort_View();
|
if (oComSort.RefreshView())
|
{
|
txt.Text = oComSort.oModel.HName;
|
txt.Tag = oComSort.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹«Ë¾ÀàÐÍ/
|
/// <summary>
|
/// ¹«Ë¾ÀàÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByComType(TextBox txt)
|
{
|
DAL.ClsGy_ComType_View oComType = new DAL.ClsGy_ComType_View();
|
if (oComType.RefreshView())
|
{
|
txt.Text = oComType.oModel.HName;
|
txt.Tag = oComType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹ÊÕÏÔÒò
|
/// <summary>
|
/// ¹ÊÕÏÔÒò
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByConkReason(TextBox txt)
|
{
|
DAL.ClsGy_ConkReason_View oConkReason = new DAL.ClsGy_ConkReason_View();
|
if (oConkReason.RefreshView())
|
{
|
txt.Text = oConkReason.oModel.HName;
|
txt.Tag = oConkReason.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹ÊÕÏÀà±ð
|
/// <summary>
|
/// ¹ÊÕÏÀà±ð
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByConkType(TextBox txt)
|
{
|
DAL.ClsGy_ConkType_View oConkType = new DAL.ClsGy_ConkType_View();
|
if (oConkType.RefreshView())
|
{
|
txt.Text = oConkType.oModel.HName;
|
txt.Tag = oConkType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//³É±¾ÖÐÐÄ
|
/// <summary>
|
/// ³É±¾ÖÐÐÄ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByCostCenter(TextBox txt)
|
{
|
DAL.ClsGy_CostCenter_View oCostCenter = new DAL.ClsGy_CostCenter_View();
|
if (oCostCenter.RefreshView())
|
{
|
txt.Text = oCostCenter.oModel.HName;
|
txt.Tag = oCostCenter.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//±Ò±ð
|
/// <summary>
|
/// ±Ò±ð
|
/// </summary>
|
/// <param name="txt"></param>
|
/// <param name="txtHRate"></param>
|
public static void SetTextByCur(TextBox txt, TextBox txtHRate)
|
{
|
DAL.ClsGy_Currency_View oCur = new DAL.ClsGy_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.HExchangeRate.ToString();
|
}
|
}
|
else
|
{
|
txt.Text = "";
|
txtHRate.Text = "1";
|
}
|
}
|
|
//±Ò±ð
|
/// <summary>
|
/// ±Ò±ð ·µ»Ø´úÂë
|
/// </summary>
|
/// <param name="txt"></param>
|
/// <param name="txtHRate"></param>
|
public static void SetTextByCur(TextBox txt,bool backNumber)
|
{
|
DAL.ClsGy_Currency_View oCur = new DAL.ClsGy_Currency_View();
|
if (oCur.RefreshView())
|
{
|
if (oCur.GetInfoByID(oCur.oModel.HItemID))
|
{
|
txt.Text = oCur.omodel.HNumber;
|
txt.Tag = oCur.omodel.HItemID.ToString();
|
}
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¿Í»§
|
/// <summary>
|
/// ¿Í»§
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByCus(TextBox txt)
|
{
|
DAL.ClsGy_Customer_View oCus = new DAL.ClsGy_Customer_View();
|
if (oCus.RefreshView())
|
{
|
txt.Text = oCus.oModel.HName;
|
txt.Tag = oCus.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¿Í»§·ÖÀà
|
/// <summary>
|
/// ¿Í»§·ÖÀà
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByCusType(TextBox txt)
|
{
|
DAL.ClsGy_CusType_View oCusType = new DAL.ClsGy_CusType_View();
|
if (oCusType.RefreshView())
|
{
|
txt.Text = oCusType.oModel.HName;
|
txt.Tag = oCusType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//²¿ÃÅ
|
/// <summary>
|
/// ²¿ÃÅ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByDept(TextBox txt)
|
{
|
DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();
|
if (oDept.RefreshView())
|
{
|
txt.Text = oDept.oModel.HName;
|
txt.Tag = oDept.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
////²¿ÃŽӿÚ
|
///// <summary>
|
///// ²¿ÃŽӿÚ
|
///// </summary>
|
///// <param name="txt"></param>
|
//public static void SetTextByDept_IF(TextBox txt)
|
//{
|
// DAL.ClsIF_Department_View oDept = new DAL.ClsIF_Department_View();
|
// if (oDept.RefreshView())
|
// {
|
// txt.Text = oDept.oModel.HName;
|
// txt.Tag = oDept.oModel.HItemID.ToString();
|
// }
|
// else
|
// {
|
// txt.Text = "";
|
// }
|
//}
|
|
//²¿ÃÅ
|
/// <summary>
|
/// ²¿ÃÅ ·µ»Ø´úÂë
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByDept(TextBox txt,bool backNumber)
|
{
|
DAL.ClsGy_Department_View oDept = new DAL.ClsGy_Department_View();
|
if (oDept.RefreshView())
|
{
|
txt.Text = oDept.oModel.HName;
|
txt.Tag = oDept.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//ËÞÉá
|
/// <summary>
|
/// ËÞÉá
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByDorm(TextBox txt)
|
{
|
DAL.ClsGy_Dorm_View oDorm = new DAL.ClsGy_Dorm_View();
|
if (oDorm.RefreshView())
|
{
|
txt.Text = oDorm.oModel.HName;
|
txt.Tag = oDorm.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¿Û²¹×ÊÁÏ
|
/// <summary>
|
/// ¿Û²¹×ÊÁÏ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByDuSubsidyItem(TextBox txt)
|
{
|
DAL.ClsGy_DuSubsidyItem_View oDuSubsidyItem = new DAL.ClsGy_DuSubsidyItem_View();
|
if (oDuSubsidyItem.RefreshView())
|
{
|
txt.Text = oDuSubsidyItem.oModel.HName;
|
txt.Tag = oDuSubsidyItem.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ö°Îñ
|
/// <summary>
|
/// Ö°Îñ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByDuty(TextBox txt)
|
{
|
DAL.ClsGy_Duty_View oDuty = new DAL.ClsGy_Duty_View();
|
if (oDuty.RefreshView())
|
{
|
txt.Text = oDuty.oModel.HName;
|
txt.Tag = oDuty.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ñ¡ÔñÖ°Ô±
|
/// <summary>
|
/// Ñ¡ÔñÖ°Ô±
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByEmp(TextBox txt)
|
{
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_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 SetTextByEmp(TextBox txt,TextBox txtName)
|
{
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
|
if (oEmp.RefreshView())
|
{
|
txt.Text = oEmp.oModel.HNumber;
|
txt.Tag = oEmp.oModel.HItemID.ToString();
|
txtName.Text = oEmp.oModel.HName;
|
}
|
else
|
{
|
txt.Text = "";
|
txtName.Text = "";
|
}
|
}
|
|
//ÄÜÔ´ÏîÄ¿
|
/// <summary>
|
/// ÄÜÔ´ÏîÄ¿
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByEnergy(TextBox txt)
|
{
|
DAL.ClsGy_Energy_View oEnergy = new DAL.ClsGy_Energy_View();
|
if (oEnergy.RefreshView())
|
{
|
txt.Text = oEnergy.oModel.HName;
|
txt.Tag = oEnergy.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//É豸
|
/// <summary>
|
/// É豸
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByEquipMent(TextBox txt)
|
{
|
DAL.ClsGy_EquipMent_View oEquipMent = new DAL.ClsGy_EquipMent_View();
|
if (oEquipMent.RefreshView())
|
{
|
txt.Text = oEquipMent.oModel.HName;
|
txt.Tag = oEquipMent.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Òì³£ÀàÐÍ
|
/// <summary>
|
/// Òì³£ÀàÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByErrType(TextBox txt)
|
{
|
DAL.ClsGy_ErrType_View oErrType = new DAL.ClsGy_ErrType_View();
|
if (oErrType.RefreshView())
|
{
|
txt.Text = oErrType.oModel.HName;
|
txt.Tag = oErrType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//ÆÀ¼ÛÇé¿ö
|
/// <summary>
|
/// ÆÀ¼ÛÇé¿ö
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByEvaluateStatus(TextBox txt)
|
{
|
DAL.ClsGy_EvaluateStatus_View oEvaluateStatus = new DAL.ClsGy_EvaluateStatus_View();
|
if (oEvaluateStatus.RefreshView())
|
{
|
txt.Text = oEvaluateStatus.oModel.HName;
|
txt.Tag = oEvaluateStatus.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//·ÑÓÃÇé¿ö
|
/// <summary>
|
/// ·ÑÓÃÇé¿ö
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByExpenseStatus(TextBox txt)
|
{
|
DAL.ClsGy_ExpenseStatus_View oExpenseStatus = new DAL.ClsGy_ExpenseStatus_View();
|
if (oExpenseStatus.RefreshView())
|
{
|
txt.Text = oExpenseStatus.oModel.HName;
|
txt.Tag = oExpenseStatus.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//³§¼Ò
|
/// <summary>
|
/// ³§¼Ò
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByFactory(TextBox txt)
|
{
|
DAL.ClsGy_Factory_View oFactory = new DAL.ClsGy_Factory_View();
|
if (oFactory.RefreshView())
|
{
|
txt.Text = oFactory.oModel.HName;
|
txt.Tag = oFactory.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//°à×é
|
/// <summary>
|
/// °à×é
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByGroup(TextBox txt)
|
{
|
DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
|
if (oGroup.RefreshView())
|
{
|
txt.Text = oGroup.oModel.HName;
|
txt.Tag = oGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//°à×é
|
/// <summary>
|
/// °à×é
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByGroup(TextBox txt,TextBox txtName)
|
{
|
DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_Group_View();
|
if (oGroup.RefreshView())
|
{
|
txt.Text = oGroup.oModel.HNumber;
|
txt.Tag = oGroup.oModel.HItemID.ToString();
|
txtName.Text = oGroup.oModel.HName;
|
}
|
else
|
{
|
txt.Text = "";
|
txtName.Text = "";
|
}
|
}
|
|
//½Ú¼ÙÈÕ
|
/// <summary>
|
/// ½Ú¼ÙÈÕ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByHoliday(TextBox txt)
|
{
|
DAL.ClsGy_Holiday_View oHoliday = new DAL.ClsGy_Holiday_View();
|
if (oHoliday.RefreshView())
|
{
|
txt.Text = oHoliday.oModel.HName;
|
txt.Tag = oHoliday.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//±£ÑøÏîÄ¿
|
/// <summary>
|
/// ±£ÑøÏîÄ¿
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByMaintain(TextBox txt)
|
{
|
DAL.ClsGy_Maintain_View oMaintain = new DAL.ClsGy_Maintain_View();
|
if (oMaintain.RefreshView())
|
{
|
txt.Text = oMaintain.oModel.HName;
|
txt.Tag = oMaintain.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¿Í»§¶ÔÓ¦ÎïÁÏ
|
/// <summary>
|
/// ¿Í»§¶ÔÓ¦ÎïÁÏ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByMateNumRelation(TextBox txt)
|
{
|
DAL.ClsGy_MateNumRelation_View oMateNumRelation = new DAL.ClsGy_MateNumRelation_View();
|
if (oMateNumRelation.RefreshView())
|
{
|
txt.Text = oMateNumRelation.oModel.HName;
|
txt.Tag = oMateNumRelation.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//ÎïÁÏ
|
/// <summary>
|
/// ÎïÁÏ
|
/// </summary>
|
/// <param name="txtNumber">´úÂëÎı¾¿ò</param>
|
/// <param name="txtName">Ãû³ÆÎı¾¿ò</param>
|
/// <param name="txtModel">¹æ¸ñÎı¾¿ò</param>
|
/// <param name="txtUnit">µ¥Î»Îı¾¿ò</param>
|
public static void SetTextByMaterial(TextBox txtNumber, TextBox txtName, TextBox txtModel, TextBox txtUnit)
|
{
|
DAL.ClsGy_Material_View oMaterial = new DAL.ClsGy_Material_View();
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();
|
if (oMaterial.RefreshView())
|
{
|
if (oMaterial.GetInfoByID(oMaterial.oModel.HItemID))
|
{
|
txtNumber.Text = oMaterial.omodel.HNumber;
|
txtNumber.Tag = oMaterial.omodel.HItemID.ToString();
|
txtName.Text = oMaterial.omodel.HName;
|
txtModel.Text = oMaterial.omodel.HModel;
|
if (oUnit.GetInfoByID(oMaterial.omodel.HUnitID))
|
{
|
txtUnit.Text = oUnit.omodel.HName;
|
txtUnit.Tag = oUnit.omodel.HItemID.ToString();
|
}
|
else
|
{
|
txtUnit.Text = "";
|
txtUnit.Tag = "0";
|
}
|
}
|
else
|
{
|
txtNumber.Text = "";
|
txtNumber.Tag = "0";
|
txtName.Text = "";
|
txtModel.Text = "";
|
txtUnit.Text = "";
|
txtUnit.Tag = "0";
|
}
|
}
|
else
|
{
|
txtNumber.Text = "";
|
txtNumber.Tag = "0";
|
txtName.Text = "";
|
txtModel.Text = "";
|
txtUnit.Text = "";
|
txtUnit.Tag = "0";
|
}
|
}
|
|
//ÎïÁÏ
|
/// <summary>
|
/// ÎïÁÏ Ö»·µ»Ø´úÂë
|
/// </summary>
|
/// <param name="txtNumber">´úÂëÎı¾¿ò</param>
|
public static void SetTextByMaterial(TextBox txtNumber)
|
{
|
DAL.ClsGy_Material_View oMaterial = new DAL.ClsGy_Material_View();
|
if (oMaterial.RefreshView())
|
{
|
if (oMaterial.GetInfoByID(oMaterial.oModel.HItemID))
|
{
|
txtNumber.Text = oMaterial.omodel.HNumber;
|
txtNumber.Tag = oMaterial.omodel.HItemID.ToString();
|
|
}
|
else
|
{
|
txtNumber.Text = "";
|
txtNumber.Tag = "0";
|
}
|
}
|
else
|
{
|
txtNumber.Text = "";
|
txtNumber.Tag = "0";
|
}
|
}
|
|
//ÎïÁÏÌØÐÔ
|
/// <summary>
|
/// ÎïÁÏÌØÐÔ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByMaterTrait(TextBox txt)
|
{
|
DAL.ClsGy_MaterTrait_View oMaterTrait = new DAL.ClsGy_MaterTrait_View();
|
if (oMaterTrait.RefreshView())
|
{
|
txt.Text = oMaterTrait.oModel.HName;
|
txt.Tag = oMaterTrait.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹æ¸ñÐͺÅ
|
/// <summary>
|
/// ¹æ¸ñÐͺÅ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByModel(TextBox txt)
|
{
|
DAL.ClsGy_Model_View oModel = new DAL.ClsGy_Model_View();
|
if (oModel.RefreshView())
|
{
|
txt.Text = oModel.oModel.HName;
|
txt.Tag = oModel.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¶©µ¥µÈ¼¶
|
/// <summary>
|
/// ¶©µ¥µÈ¼¶
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByOrderLev(TextBox txt)
|
{
|
DAL.ClsGy_OrderLev_View oOrderLev = new DAL.ClsGy_OrderLev_View();
|
if (oOrderLev.RefreshView())
|
{
|
txt.Text = oOrderLev.oModel.HName;
|
txt.Tag = oOrderLev.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Ö¤¼þÀà±ð
|
/// <summary>
|
/// Ö¤¼þÀà±ð
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByPaperSort(TextBox txt)
|
{
|
DAL.ClsGy_PaperSort_View oPaperSort = new DAL.ClsGy_PaperSort_View();
|
if (oPaperSort.RefreshView())
|
{
|
txt.Text = oPaperSort.oModel.HName;
|
txt.Tag = oPaperSort.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//×ÊÔ´ÄÜÁ¦
|
/// <summary>
|
/// ×ÊÔ´ÄÜÁ¦
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByPlanShifts(TextBox txt)
|
{
|
//DAL.ClsGy_PlanShifts_View oPlanShifts = new DAL.ClsGy_PlanShifts_View();
|
//if (oPlanShifts.RefreshView())
|
//{
|
// txt.Text = oPlanShifts.oModel.HName;
|
// txt.Tag = oPlanShifts.oModel.HItemID.ToString();
|
//}
|
//else
|
//{
|
// txt.Text = "";
|
//}
|
}
|
|
//¸Û¿Ú
|
/// <summary>
|
/// ¸Û¿Ú
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByPort(TextBox txt)
|
{
|
DAL.ClsGy_Port_View oPort = new DAL.ClsGy_Port_View();
|
if (oPort.RefreshView())
|
{
|
txt.Text = oPort.oModel.HName;
|
txt.Tag = oPort.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¸Úλ
|
/// <summary>
|
/// ¸Úλ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByPost(TextBox txt)
|
{
|
DAL.ClsGy_Post_View oPost = new DAL.ClsGy_Post_View();
|
if (oPost.RefreshView())
|
{
|
txt.Text = oPost.oModel.HName;
|
txt.Tag = oPost.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//²É¹º·½Ê½
|
/// <summary>
|
/// ²É¹º·½Ê½
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByPoStockStyle(TextBox txt)
|
{
|
DAL.ClsGy_PoStockStyle_View oPoStockStyle = new DAL.ClsGy_PoStockStyle_View();
|
if (oPoStockStyle.RefreshView())
|
{
|
txt.Text = oPoStockStyle.oModel.HName;
|
txt.Tag = oPoStockStyle.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//ίÍ⹤Ðò
|
/// <summary>
|
/// ίÍ⹤Ðò
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProcComm(TextBox txt)
|
{
|
DAL.ClsGy_ProcComm_View oProcComm = new DAL.ClsGy_ProcComm_View();
|
if (oProcComm.RefreshView())
|
{
|
txt.Text = oProcComm.oModel.HName;
|
txt.Tag = oProcComm.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹¤Ðò
|
/// <summary>
|
/// ¹¤Ðò
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProcess(TextBox txt)
|
{
|
DAL.ClsGy_Process_View oProcess = new DAL.ClsGy_Process_View();
|
if (oProcess.RefreshView())
|
{
|
txt.Text = oProcess.oModel.HName;
|
txt.Tag = oProcess.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹¤¶Î
|
/// <summary>
|
/// ¹¤¶Î
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProcMul(TextBox txt)
|
{
|
DAL.ClsGy_ProcMul_View oProcMul = new DAL.ClsGy_ProcMul_View();
|
if (oProcMul.RefreshView())
|
{
|
txt.Text = oProcMul.oModel.HName;
|
txt.Tag = oProcMul.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¶¨¶î¹é¼¯
|
/// <summary>
|
/// ¶¨¶î¹é¼¯
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProcPriceRela(TextBox txt)
|
{
|
DAL.ClsGy_ProcPriceRela_View oProcPriceRela = new DAL.ClsGy_ProcPriceRela_View();
|
if (oProcPriceRela.RefreshView())
|
{
|
txt.Text = oProcPriceRela.oModel.HName;
|
txt.Tag = oProcPriceRela.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¶¨¶î¹é¼¯×é
|
/// <summary>
|
/// ¶¨¶î¹é¼¯×é
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProcPriceRelaGroup(TextBox txt)
|
{
|
DAL.ClsGy_ProcPriceRelaGroup_View oPriceRelaGroup = new DAL.ClsGy_ProcPriceRelaGroup_View();
|
if (oPriceRelaGroup.RefreshView())
|
{
|
txt.Text = oPriceRelaGroup.oModel.HName;
|
txt.Tag = oPriceRelaGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Éú²úÀàÐÍ
|
/// <summary>
|
/// Éú²úÀàÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProdType(TextBox txt)
|
{
|
DAL.ClsGy_ProdType_View oProdType = new DAL.ClsGy_ProdType_View();
|
if (oProdType.RefreshView())
|
{
|
txt.Text = oProdType.oModel.HName;
|
txt.Tag = oProdType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//²úÆ·ÌØÐÔ
|
/// <summary>
|
/// ²úÆ·ÌØÐÔ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProductSpec(TextBox txt)
|
{
|
DAL.ClsGy_ProductSpec_View oProductSpec = new DAL.ClsGy_ProductSpec_View();
|
if (oProductSpec.RefreshView())
|
{
|
txt.Text = oProductSpec.oModel.HName;
|
txt.Tag = oProductSpec.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//ÏîÄ¿¹¤³Ì
|
/// <summary>
|
/// ÏîÄ¿¹¤³Ì
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProject(TextBox txt)
|
{
|
DAL.ClsGy_Project_View oProject = new DAL.ClsGy_Project_View();
|
if (oProject.RefreshView())
|
{
|
txt.Text = oProject.oModel.HName;
|
txt.Tag = oProject.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¸¨ÖúÊôÐÔ
|
/// <summary>
|
/// ¸¨ÖúÊôÐÔ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProperty(TextBox txt)
|
{
|
DAL.ClsGy_Property_View oProperty = new DAL.ClsGy_Property_View();
|
if (oProperty.RefreshView())
|
{
|
txt.Text = oProperty.oModel.HName;
|
txt.Tag = oProperty.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¸¨ÖúÊôÐÔÀà±ð
|
/// <summary>
|
/// ¸¨ÖúÊôÐÔÀà±ð
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByPropertyType(TextBox txt)
|
{
|
DAL.ClsGy_PropertyType_View oPropertyType = new DAL.ClsGy_PropertyType_View();
|
if (oPropertyType.RefreshView())
|
{
|
txt.Text = oPropertyType.oModel.HName;
|
txt.Tag = oPropertyType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//άÐÞÏîÄ¿
|
/// <summary>
|
/// άÐÞÏîÄ¿
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByRepair(TextBox txt)
|
{
|
DAL.ClsGy_Repair_View oRepair = new DAL.ClsGy_Repair_View();
|
if (oRepair.RefreshView())
|
{
|
txt.Text = oRepair.oModel.HName;
|
txt.Tag = oRepair.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//άÐÞÑéÊÕÏîÄ¿
|
/// <summary>
|
/// άÐÞÑéÊÕÏîÄ¿
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByRepairCheck(TextBox txt)
|
{
|
DAL.ClsGy_RepairCheck_View oRepairCheck = new DAL.ClsGy_RepairCheck_View();
|
if (oRepairCheck.RefreshView())
|
{
|
txt.Text = oRepairCheck.oModel.HName;
|
txt.Tag = oRepairCheck.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//άÐÞ·½Ê½
|
/// <summary>
|
/// άÐÞ·½Ê½
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByRepairType(TextBox txt)
|
{
|
DAL.ClsGy_RepairType_View oRepairType = new DAL.ClsGy_RepairType_View();
|
if (oRepairType.RefreshView())
|
{
|
txt.Text = oRepairType.oModel.HName;
|
txt.Tag = oRepairType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹¤ÒÕ·Ïß´óÀà
|
/// <summary>
|
/// ¹¤ÒÕ·Ïß´óÀà
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByRoutingGroup(TextBox txt)
|
{
|
DAL.ClsGy_RoutingGroup_View oRoutingGroup = new DAL.ClsGy_RoutingGroup_View();
|
if (oRoutingGroup.RefreshView())
|
{
|
txt.Text = oRoutingGroup.oModel.HName;
|
txt.Tag = oRoutingGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//°²È«ÏîÄ¿
|
/// <summary>
|
/// °²È«ÏîÄ¿
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySafety(TextBox txt)
|
{
|
DAL.ClsGy_Safety_View oSafety = new DAL.ClsGy_Safety_View();
|
if (oSafety.RefreshView())
|
{
|
txt.Text = oSafety.oModel.HName;
|
txt.Tag = oSafety.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//±¨·ÏÔÒò
|
/// <summary>
|
/// ±¨·ÏÔÒò
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByScrapReason(TextBox txt)
|
{
|
DAL.ClsGy_ScrapReason_View oScrapReason = new DAL.ClsGy_ScrapReason_View();
|
if (oScrapReason.RefreshView())
|
{
|
txt.Text = oScrapReason.oModel.HName;
|
txt.Tag = oScrapReason.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//·þÎñÀàÐÍ
|
/// <summary>
|
/// ·þÎñÀàÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySecType(TextBox txt)
|
{
|
DAL.ClsGy_SecType_View oSecType = new DAL.ClsGy_SecType_View();
|
if (oSecType.RefreshView())
|
{
|
txt.Text = oSecType.oModel.HName;
|
txt.Tag = oSecType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//ÏúÊÛ·½Ê½
|
/// <summary>
|
/// ÏúÊÛ·½Ê½
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySellStyle(TextBox txt)
|
{
|
DAL.ClsGy_SellStyle_View oSellStyle = new DAL.ClsGy_SellStyle_View();
|
if (oSellStyle.RefreshView())
|
{
|
txt.Text = oSellStyle.oModel.HName;
|
txt.Tag = oSellStyle.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//½áË㷽ʽ
|
/// <summary>
|
/// ½áË㷽ʽ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySettleStyle(TextBox txt)
|
{
|
DAL.ClsGy_SettleStyle_View oSettleStyle = new DAL.ClsGy_SettleStyle_View();
|
if (oSettleStyle.RefreshView())
|
{
|
txt.Text = oSettleStyle.oModel.HName;
|
txt.Tag = oSettleStyle.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//°à´Î
|
/// <summary>
|
/// °à´Î
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByShifts(TextBox txt)
|
{
|
DAL.ClsGy_Shifts_View oShifts = new DAL.ClsGy_Shifts_View();
|
if (oShifts.RefreshView())
|
{
|
txt.Text = oShifts.oModel.HName;
|
txt.Tag = oShifts.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Éú²ú×ÊÔ´
|
/// <summary>
|
/// Éú²ú×ÊÔ´
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySource(TextBox txt)
|
{
|
DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
|
if (oSource.RefreshView())
|
{
|
txt.Text = oSource.oModel.HName;
|
txt.Tag = oSource.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Èë¿âÀàÐÍ
|
/// <summary>
|
/// Èë¿âÀàÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByStockInStyle(TextBox txt)
|
{
|
DAL.ClsGy_StockInStyle_View oStockInStyle = new DAL.ClsGy_StockInStyle_View();
|
if (oStockInStyle.RefreshView())
|
{
|
txt.Text = oStockInStyle.oModel.HName;
|
txt.Tag = oStockInStyle.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//³ö¿âÀàÐÍ
|
/// <summary>
|
/// ³ö¿âÀàÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByStockOutStyle(TextBox txt)
|
{
|
DAL.ClsGy_StockOutStyle_View oStockOutStyle = new DAL.ClsGy_StockOutStyle_View();
|
if (oStockOutStyle.RefreshView())
|
{
|
txt.Text = oStockOutStyle.oModel.HName;
|
txt.Tag = oStockOutStyle.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//²Öλ
|
/// <summary>
|
/// ²Öλ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByStockPlace(TextBox txt)
|
{
|
DAL.ClsGy_StockPlace_View oStockPlace = new DAL.ClsGy_StockPlace_View();
|
if (oStockPlace.RefreshView())
|
{
|
txt.Text = oStockPlace.oModel.HName;
|
txt.Tag = oStockPlace.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//²Öλ×é
|
/// <summary>
|
/// ²Öλ×é
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByStockPlaceGroup(TextBox txt)
|
{
|
DAL.ClsGy_StockPlaceGroup_View oStockPlaceGroup = new DAL.ClsGy_StockPlaceGroup_View();
|
if (oStockPlaceGroup.RefreshView())
|
{
|
txt.Text = oStockPlaceGroup.oModel.HName;
|
txt.Tag = oStockPlaceGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹©Ó¦ÉÌ
|
/// <summary>
|
/// ¹©Ó¦ÉÌ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySupplier(TextBox txt)
|
{
|
DAL.ClsGy_Supplier_View oSupplier = new DAL.ClsGy_Supplier_View();
|
if (oSupplier.RefreshView())
|
{
|
txt.Text = oSupplier.oModel.HName;
|
txt.Tag = oSupplier.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹©Ó¦ÉÌ
|
/// <summary>
|
/// ¹©Ó¦ÉÌ ·µ»Ø´úÂë
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySupplier(TextBox txt,bool backNumber)
|
{
|
DAL.ClsGy_Supplier_View oSupplier = new DAL.ClsGy_Supplier_View();
|
if (oSupplier.RefreshView())
|
{
|
txt.Text = oSupplier.oModel.HNumber;
|
txt.Tag = oSupplier.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹©Ó¦Àà±ð
|
/// <summary>
|
/// ¹©Ó¦Àà±ð
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySupSort(TextBox txt)
|
{
|
DAL.ClsGy_SupSort_View oSupSort = new DAL.ClsGy_SupSort_View();
|
if (oSupSort.RefreshView())
|
{
|
txt.Text = oSupSort.oModel.HName;
|
txt.Tag = oSupSort.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹©Ó¦É̵ȼ¶
|
/// <summary>
|
/// ¹©Ó¦É̵ȼ¶
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySupStatus(TextBox txt)
|
{
|
DAL.ClsGy_SupStatus_View oSupStatus = new DAL.ClsGy_SupStatus_View();
|
if (oSupStatus.RefreshView())
|
{
|
txt.Text = oSupStatus.oModel.HName;
|
txt.Tag = oSupStatus.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹©Ó¦ÉÌÖ¸±ê
|
/// <summary>
|
/// ¹©Ó¦ÉÌÖ¸±ê
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySupTarget(TextBox txt)
|
{
|
DAL.ClsGy_SupTarget_View oSupTarget = new DAL.ClsGy_SupTarget_View();
|
if (oSupTarget.RefreshView())
|
{
|
txt.Text = oSupTarget.oModel.HName;
|
txt.Tag = oSupTarget.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹©Ó¦ÉÌ·ÖÀà
|
/// <summary>
|
/// ¹©Ó¦ÉÌ·ÖÀà
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySupType(TextBox txt)
|
{
|
DAL.ClsGy_SupType_View oSupType = new DAL.ClsGy_SupType_View();
|
if (oSupType.RefreshView())
|
{
|
txt.Text = oSupType.oModel.HName;
|
txt.Tag = oSupType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//ËùÊôÐÐÒµ
|
/// <summary>
|
/// ËùÊôÐÐÒµ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByTrade(TextBox txt)
|
{
|
DAL.ClsGy_Trade_View oTrade = new DAL.ClsGy_Trade_View();
|
if (oTrade.RefreshView())
|
{
|
txt.Text = oTrade.oModel.HName;
|
txt.Tag = oTrade.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¼ÆÁ¿µ¥Î»
|
/// <summary>
|
/// ¼ÆÁ¿µ¥Î»
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByUnit(TextBox txt)
|
{
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();
|
if (oUnit.RefreshView())
|
{
|
txt.Text = oUnit.oModel.HName;
|
txt.Tag = oUnit.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¼ÆÁ¿µ¥Î»
|
/// <summary>
|
/// ¼ÆÁ¿µ¥Î»
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByUnit(TextBox txt,string sWhere)
|
{
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_Unit_View();
|
if (oUnit.RefreshView(sWhere))
|
{
|
txt.Text = oUnit.oModel.HName;
|
txt.Tag = oUnit.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¼ÆÁ¿µ¥Î»×é
|
/// <summary>
|
/// ¼ÆÁ¿µ¥Î»×é
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByUnitGroup(TextBox txt)
|
{
|
DAL.ClsGy_UnitGroup_View oUnitGroup = new DAL.ClsGy_UnitGroup_View();
|
if (oUnitGroup.RefreshView())
|
{
|
txt.Text = oUnitGroup.oModel.HName;
|
txt.Tag = oUnitGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//²Ö¿â
|
/// <summary>
|
/// ²Ö¿â
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByWarehouse(TextBox txt)
|
{
|
DAL.ClsGy_Warehouse_View oWarehouse = new DAL.ClsGy_Warehouse_View();
|
if (oWarehouse.RefreshView())
|
{
|
txt.Text = oWarehouse.oModel.HName;
|
txt.Tag = oWarehouse.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//²Ö¿â
|
/// <summary>
|
/// ²Ö¿â Ö»·µ»Ø´úÂë
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByWarehouse(TextBox txt,bool backNumber)
|
{
|
DAL.ClsGy_Warehouse_View oWarehouse = new DAL.ClsGy_Warehouse_View();
|
if (oWarehouse.RefreshView())
|
{
|
txt.Text = oWarehouse.oModel.HNumber;
|
txt.Tag = oWarehouse.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹¤×÷ÖÐÐÄ
|
/// <summary>
|
/// ¹¤×÷ÖÐÐÄ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByWorkCenter(TextBox txt)
|
{
|
DAL.ClsGy_WorkCenter_View oWorkCenter = new DAL.ClsGy_WorkCenter_View();
|
if (oWorkCenter.RefreshView())
|
{
|
txt.Text = oWorkCenter.oModel.HName;
|
txt.Tag = oWorkCenter.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹¤×ÊÀàÐÍ
|
/// <summary>
|
/// ¹¤×ÊÀàÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByWorkPayType(TextBox txt)
|
{
|
DAL.ClsGy_WorkPayType_View oWorkPayType = new DAL.ClsGy_WorkPayType_View();
|
if (oWorkPayType.RefreshView())
|
{
|
txt.Text = oWorkPayType.oModel.HName;
|
txt.Tag = oWorkPayType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//¹¤ÖÖ
|
/// <summary>
|
/// ¹¤ÖÖ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByWorkType(TextBox txt)
|
{
|
DAL.ClsGy_WorkType_View oWorkType = new DAL.ClsGy_WorkType_View();
|
if (oWorkType.RefreshView())
|
{
|
txt.Text = oWorkType.oModel.HName;
|
txt.Tag = oWorkType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//Òì³£¹¤¼Û
|
/// <summary>
|
/// Òì³£¹¤¼Û
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByErrWorkPirce(TextBox txt)
|
{
|
DAL.ClsGy_ErrWorkPrice_View oWorkPrice = new DAL.ClsGy_ErrWorkPrice_View();
|
if (oWorkPrice.RefreshView())
|
{
|
txt.Text = oWorkPrice.oModel.HName;
|
txt.Tag = oWorkPrice.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//²É¼¯Æ÷
|
/// <summary>
|
/// ²É¼¯Æ÷
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByCollect(TextBox txt)
|
{
|
DAL.ClsGy_Collect_View oCollect = new DAL.ClsGy_Collect_View();
|
if (oCollect.RefreshView())
|
{
|
txt.Text = oCollect.oModel.HName;
|
txt.Tag = oCollect.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Òµ»§
|
/// <summary>
|
/// Òµ»§
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByRoom(TextBox txt)
|
{
|
DAL.ClsGy_Room_View oRoom = new DAL.ClsGy_Room_View();
|
if (oRoom.RefreshView())
|
{
|
txt.Text = oRoom.oModel.HName;
|
txt.Tag = oRoom.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//Â¥ºÅ
|
/// <summary>
|
/// Â¥ºÅ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByBuilding(TextBox txt)
|
{
|
DAL.ClsGy_Building_View oBuilding = new DAL.ClsGy_Building_View();
|
if (oBuilding.RefreshView())
|
{
|
txt.Text = oBuilding.oModel.HName;
|
txt.Tag = oBuilding.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//»§ÐÍ
|
/// <summary>
|
/// »§ÐÍ
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByHouseType(TextBox txt)
|
{
|
DAL.ClsGy_HouseType_View oHouseType = new DAL.ClsGy_HouseType_View();
|
if (oHouseType.RefreshView())
|
{
|
txt.Text = oHouseType.oModel.HName;
|
txt.Tag = oHouseType.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
#endregion
|
|
|
|
#region ÉèÖÃÍø¸ñ
|
|
|
//²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â
|
/// <summary>
|
/// ²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HStockPlaceIDCol"></param>
|
/// <param name="HStockPlaceNumberCol"></param>
|
/// <param name="HStockPlaceNameCol"></param>
|
public static void SetGridByStockPlaceByWh(DataGridView grdMain, int i, int HWhIDCol, int HStockPlaceIDCol, int HStockPlaceNumberCol, int HStockPlaceNameCol)
|
{
|
|
DAL.ClsGy_StockPlace_View oStockPlace = new DAL.ClsGy_StockPlace_View();
|
if (oStockPlace.RefreshView())
|
{
|
if (oStockPlace.GetInfoByID(oStockPlace.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = oStockPlace.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = oStockPlace.omodel.HNumber;
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = oStockPlace.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
|
}
|
}
|
|
|
//²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â
|
/// <summary>
|
/// ²Öλ-Íø¸ñ ¸ù¾Ý²Ö¿â
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HStockPlaceIDCol"></param>
|
/// <param name="HStockPlaceNumberCol"></param>
|
/// <param name="HStockPlaceNameCol"></param>
|
public static void SetGridByStockPlaceByWh(DataGridView grdMain, int i, int HWhIDCol, int HStockPlaceIDCol, int HStockPlaceNumberCol, int HStockPlaceNameCol, int HSPGroupIDCol, int HSPGroupNameCol, ref string sBackStr)
|
{
|
|
DAL.ClsGy_StockPlace_View oSP = new DAL.ClsGy_StockPlace_View();
|
DAL.ClsGy_StockPlaceGroup_View oSPGroup = new DAL.ClsGy_StockPlaceGroup_View();
|
if (DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HWhIDCol].Value) == 0)
|
{
|
sBackStr = "ûÓÐÑ¡Ôñ²Ö¿â£¡";
|
return;
|
}
|
if (oSP.RefreshViewByWh(DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HWhIDCol].Value)))
|
{
|
if (oSP.GetInfoByID(oSP.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = oSP.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = oSP.omodel.HNumber;
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = oSP.omodel.HName;
|
if (oSPGroup.GetInfoByID(oSP.omodel.HSPGroupID))
|
{
|
grdMain.Rows[i].Cells[HSPGroupIDCol].Value = oSPGroup.omodel.HItemID;
|
grdMain.Rows[i].Cells[HSPGroupNameCol].Value = oSPGroup.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSPGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPGroupNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
|
grdMain.Rows[i].Cells[HSPGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPGroupNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
|
grdMain.Rows[i].Cells[HSPGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSPGroupNameCol].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(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
|
{
|
DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_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="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(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol, int HSubjoinCol, int HColorCol)
|
{
|
DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_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[HSubjoinCol].Value = oMater.omodel.HSubjoin;
|
grdMain.Rows[i].Cells[HColorCol].Value = oMater.omodel.HColor;
|
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[HSubjoinCol].Value = "";
|
grdMain.Rows[i].Cells[HColorCol].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[HSubjoinCol].Value = "";
|
grdMain.Rows[i].Cells[HColorCol].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(DataGridView grdMain, int i, int HWhIDCol, int HWhNumberCol, int HWhNameCol)
|
{
|
DAL.ClsGy_Warehouse_View oWh = new DAL.ClsGy_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="HQCCheckItemIDCol"></param>
|
/// <param name="HQCCheckItemNumberCol"></param>
|
/// <param name="HQCCheckItemNameCol"></param>
|
public static void SetGridByQCCheckItem(DataGridView grdMain, int i, int HQCCheckItemIDCol, int HQCCheckItemNumberCol, int HQCCheckItemNameCol)
|
{
|
DAL.ClsGy_QCCheckItem_View oQCCheckItem = new DAL.ClsGy_QCCheckItem_View();
|
if (oQCCheckItem.RefreshView())
|
{
|
if (oQCCheckItem.GetInfoByID(oQCCheckItem.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = oQCCheckItem.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = oQCCheckItem.omodel.HNumber;
|
grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = oQCCheckItem.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = "";
|
}
|
}
|
|
|
public static void SetGridByQCCheckClass(DataGridView grdMain, int i, int HQCCheckClassIDCol, int HQCCheckClassNumberCol, int HQCCheckClassNameCol)
|
{
|
DAL.ClsGy_QCCheckClass_View oQCCheckClass = new DAL.ClsGy_QCCheckClass_View();
|
if (oQCCheckClass.RefreshView())
|
{
|
if (oQCCheckClass.GetInfoByID(oQCCheckClass.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = oQCCheckClass.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = oQCCheckClass.omodel.HNumber;
|
grdMain.Rows[i].Cells[HQCCheckClassNameCol].Value = oQCCheckClass.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HQCCheckClassNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HQCCheckClassNameCol].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(DataGridView grdMain, int i, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
|
{
|
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_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="HBadReasonIDCol"></param>
|
/// <param name="HBadReasonNumberCol"></param>
|
/// <param name="HBadReasonNameCol"></param>
|
public static void SetGridByBadReason(DataGridView grdMain, int i, int HBadReasonIDCol, int HBadReasonNumberCol, int HBadReasonNameCol)
|
{
|
|
DAL.ClsGy_BadReason_View oBadReason = new DAL.ClsGy_BadReason_View();
|
if (oBadReason.RefreshView())
|
{
|
if (oBadReason.GetInfoByID(oBadReason.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HBadReasonIDCol].Value = oBadReason.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HBadReasonNumberCol].Value = oBadReason.omodel.HNumber;
|
grdMain.Rows[i].Cells[HBadReasonNameCol].Value = oBadReason.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HBadReasonIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HBadReasonNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HBadReasonNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HBadReasonIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HBadReasonNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HBadReasonNameCol].Value = "";
|
}
|
}
|
|
//³µÁ¾-Íø¸ñ
|
/// <summary>
|
/// ³µÁ¾-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HCarIDCol"></param>
|
/// <param name="HCarNumberCol"></param>
|
/// <param name="HCarNameCol"></param>
|
public static void SetGridByCar(DataGridView grdMain, int i, int HCarIDCol, int HCarNumberCol, int HCarNameCol)
|
{
|
|
DAL.ClsGy_Car_View oCar = new DAL.ClsGy_Car_View();
|
if (oCar.RefreshView())
|
{
|
if (oCar.GetInfoByID(oCar.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HCarIDCol].Value = oCar.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HCarNumberCol].Value = oCar.omodel.HNumber;
|
grdMain.Rows[i].Cells[HCarNameCol].Value = oCar.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCarIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCarNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCarNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCarIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCarNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCarNameCol].Value = "";
|
}
|
}
|
|
//¹ÊÕÏÔÒò-Íø¸ñ
|
/// <summary>
|
/// ¹ÊÕÏÔÒò-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HConkReasonIDCol"></param>
|
/// <param name="HConkReasonNumberCol"></param>
|
/// <param name="HConkReasonNameCol"></param>
|
public static void SetGridByConkReason(DataGridView grdMain, int i, int HConkReasonIDCol, int HConkReasonNumberCol, int HConkReasonNameCol)
|
{
|
|
DAL.ClsGy_ConkReason_View oConkReason = new DAL.ClsGy_ConkReason_View();
|
if (oConkReason.RefreshView())
|
{
|
if (oConkReason.GetInfoByID(oConkReason.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HConkReasonIDCol].Value = oConkReason.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HConkReasonNumberCol].Value = oConkReason.omodel.HNumber;
|
grdMain.Rows[i].Cells[HConkReasonNameCol].Value = oConkReason.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HConkReasonIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HConkReasonNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HConkReasonNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HConkReasonIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HConkReasonNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HConkReasonNameCol].Value = "";
|
}
|
}
|
|
//¹ÊÕÏÀà±ð-Íø¸ñ
|
/// <summary>
|
/// ¹ÊÕÏÀà±ð-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HConkTypeIDCol"></param>
|
/// <param name="HConkTypeNumberCol"></param>
|
/// <param name="HConkTypeNameCol"></param>
|
public static void SetGridByConkType(DataGridView grdMain, int i, int HConkTypeIDCol, int HConkTypeNumberCol, int HConkTypeNameCol)
|
{
|
|
DAL.ClsGy_ConkType_View oConkType = new DAL.ClsGy_ConkType_View();
|
if (oConkType.RefreshView())
|
{
|
if (oConkType.GetInfoByID(oConkType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HConkTypeIDCol].Value = oConkType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HConkTypeNumberCol].Value = oConkType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HConkTypeNameCol].Value = oConkType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HConkTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HConkTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HConkTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HConkTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HConkTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HConkTypeNameCol].Value = "";
|
}
|
}
|
|
//³É±¾ÖÐÐÄ-Íø¸ñ
|
/// <summary>
|
/// ³É±¾ÖÐÐÄ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HCostCenterIDCol"></param>
|
/// <param name="HCostCenterNumberCol"></param>
|
/// <param name="HCostCenterNameCol"></param>
|
public static void SetGridByCostCenter(DataGridView grdMain, int i, int HCostCenterIDCol, int HCostCenterNumberCol, int HCostCenterNameCol)
|
{
|
|
DAL.ClsGy_CostCenter_View oCostCenter = new DAL.ClsGy_CostCenter_View();
|
if (oCostCenter.RefreshView())
|
{
|
if (oCostCenter.GetInfoByID(oCostCenter.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HCostCenterIDCol].Value = oCostCenter.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HCostCenterNumberCol].Value = oCostCenter.omodel.HNumber;
|
grdMain.Rows[i].Cells[HCostCenterNameCol].Value = oCostCenter.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCostCenterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCostCenterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCostCenterNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCostCenterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCostCenterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCostCenterNameCol].Value = "";
|
}
|
}
|
|
//±Ò±ð-Íø¸ñ
|
/// <summary>
|
/// ±Ò±ð-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HCurrencyIDCol"></param>
|
/// <param name="HCurrencyNumberCol"></param>
|
/// <param name="HCurrencyNameCol"></param>
|
public static void SetGridByCurrency(DataGridView grdMain, int i, int HCurrencyIDCol, int HCurrencyNumberCol, int HCurrencyNameCol)
|
{
|
|
DAL.ClsGy_Currency_View oCurrency = new DAL.ClsGy_Currency_View();
|
if (oCurrency.RefreshView())
|
{
|
if (oCurrency.GetInfoByID(oCurrency.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HCurrencyIDCol].Value = oCurrency.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HCurrencyNumberCol].Value = oCurrency.omodel.HNumber;
|
grdMain.Rows[i].Cells[HCurrencyNameCol].Value = oCurrency.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCurrencyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCurrencyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCurrencyNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCurrencyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCurrencyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCurrencyNameCol].Value = "";
|
}
|
}
|
|
//¿Í»§-Íø¸ñ
|
/// <summary>
|
/// ¿Í»§-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HCustomerIDCol"></param>
|
/// <param name="HCustomerNumberCol"></param>
|
/// <param name="HCustomerNameCol"></param>
|
public static void SetGridByCustomer(DataGridView grdMain, int i, int HCustomerIDCol, int HCustomerNumberCol, int HCustomerNameCol)
|
{
|
|
DAL.ClsGy_Customer_View oCustomer = new DAL.ClsGy_Customer_View();
|
if (oCustomer.RefreshView())
|
{
|
if (oCustomer.GetInfoByID(oCustomer.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HCustomerIDCol].Value = oCustomer.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HCustomerNumberCol].Value = oCustomer.omodel.HNumber;
|
grdMain.Rows[i].Cells[HCustomerNameCol].Value = oCustomer.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCustomerIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCustomerNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCustomerNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCustomerIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCustomerNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCustomerNameCol].Value = "";
|
}
|
}
|
|
//¿Í»§·ÖÀà-Íø¸ñ
|
/// <summary>
|
/// ¿Í»§·ÖÀà-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HCusTypeIDCol"></param>
|
/// <param name="HCusTypeNumberCol"></param>
|
/// <param name="HCusTypeNameCol"></param>
|
public static void SetGridByCusType(DataGridView grdMain, int i, int HCusTypeIDCol, int HCusTypeNumberCol, int HCusTypeNameCol)
|
{
|
|
DAL.ClsGy_CusType_View oCusType = new DAL.ClsGy_CusType_View();
|
if (oCusType.RefreshView())
|
{
|
if (oCusType.GetInfoByID(oCusType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HCusTypeIDCol].Value = oCusType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HCusTypeNumberCol].Value = oCusType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HCusTypeNameCol].Value = oCusType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCusTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCusTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCusTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCusTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCusTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCusTypeNameCol].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(DataGridView grdMain, int i, int HDeptIDCol, int HDeptNumberCol, int HDeptNameCol)
|
{
|
|
DAL.ClsGy_Department_View oDept = new DAL.ClsGy_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="HBuildingIDCol"></param>
|
/// <param name="HBuildingNumberCol"></param>
|
/// <param name="HBuildingNameCol"></param>
|
public static void SetGridByBui(DataGridView grdMain, int i, int HBuildingIDCol, int HBuildingNumberCol, int HBuildingNameCol)
|
{
|
|
DAL.ClsGy_Building_View oBui = new DAL.ClsGy_Building_View();
|
if (oBui.RefreshView())
|
{
|
if (oBui.GetInfoByID(oBui.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HBuildingIDCol].Value = oBui.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HBuildingNumberCol].Value = oBui.omodel.HNumber;
|
grdMain.Rows[i].Cells[HBuildingNameCol].Value = oBui.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HBuildingIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HBuildingNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HBuildingNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HBuildingIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HBuildingNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HBuildingNameCol].Value = "";
|
}
|
}
|
//
|
//·¿¼äÀàÐÍ-Íø¸ñ
|
/// <summary>
|
/// ·¿¼äÀàÐÍ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HBuildingIDCol"></param>
|
/// <param name="HBuildingNumberCol"></param>
|
/// <param name="HBuildingNameCol"></param>
|
public static void SetGridByHouseType(DataGridView grdMain, int i, int HHouseTypeIDCol, int HHouseTypeNumberCol, int HHouseTypeNameCol)
|
{
|
|
DAL.ClsGy_HouseType_View oHT = new DAL.ClsGy_HouseType_View();
|
if (oHT.RefreshView())
|
{
|
if (oHT.GetInfoByID(oHT.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HHouseTypeIDCol].Value = oHT.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HHouseTypeNumberCol].Value = oHT.omodel.HNumber;
|
grdMain.Rows[i].Cells[HHouseTypeNameCol].Value = oHT.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HHouseTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HHouseTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HHouseTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HHouseTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HHouseTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HHouseTypeNameCol].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 SetGridByMaterial(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol)
|
{
|
DAL.ClsGy_Material_View oMater = new DAL.ClsGy_Material_View();
|
DAL.ClsGy_Unit_View oUnit = new DAL.ClsGy_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;
|
|
}
|
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 = "";
|
}
|
}
|
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 = "";
|
}
|
}
|
|
//ËÞÉá-Íø¸ñ
|
/// <summary>
|
/// ËÞÉá-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HDormIDCol"></param>
|
/// <param name="HDormNumberCol"></param>
|
/// <param name="HDormNameCol"></param>
|
public static void SetGridByDorm(DataGridView grdMain, int i, int HDormIDCol, int HDormNumberCol, int HDormNameCol)
|
{
|
|
DAL.ClsGy_Dorm_View oDorm = new DAL.ClsGy_Dorm_View();
|
if (oDorm.RefreshView())
|
{
|
if (oDorm.GetInfoByID(oDorm.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HDormIDCol].Value = oDorm.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HDormNumberCol].Value = oDorm.omodel.HNumber;
|
grdMain.Rows[i].Cells[HDormNameCol].Value = oDorm.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDormIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDormNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDormNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDormIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDormNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDormNameCol].Value = "";
|
}
|
}
|
|
//¿Û²¹×ÊÁÏ-Íø¸ñ
|
/// <summary>
|
/// ¿Û²¹×ÊÁÏ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HDuSubsidyItemIDCol"></param>
|
/// <param name="HDuSubsidyItemNumberCol"></param>
|
/// <param name="HDuSubsidyItemNameCol"></param>
|
public static void SetGridByDuSubsidyItem(DataGridView grdMain, int i, int HDuSubsidyItemIDCol, int HDuSubsidyItemNumberCol, int HDuSubsidyItemNameCol)
|
{
|
|
DAL.ClsGy_DuSubsidyItem_View oDuSubsidyItem = new DAL.ClsGy_DuSubsidyItem_View();
|
if (oDuSubsidyItem.RefreshView())
|
{
|
if (oDuSubsidyItem.GetInfoByID(oDuSubsidyItem.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HDuSubsidyItemIDCol].Value = oDuSubsidyItem.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HDuSubsidyItemNumberCol].Value = oDuSubsidyItem.omodel.HNumber;
|
grdMain.Rows[i].Cells[HDuSubsidyItemNameCol].Value = oDuSubsidyItem.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDuSubsidyItemIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDuSubsidyItemNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDuSubsidyItemNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDuSubsidyItemIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDuSubsidyItemNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDuSubsidyItemNameCol].Value = "";
|
}
|
}
|
|
//Ö°Îñ-Íø¸ñ
|
/// <summary>
|
/// Ö°Îñ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HDutyIDCol"></param>
|
/// <param name="HDutyNumberCol"></param>
|
/// <param name="HDutyNameCol"></param>
|
public static void SetGridByDuty(DataGridView grdMain, int i, int HDutyIDCol, int HDutyNumberCol, int HDutyNameCol)
|
{
|
|
DAL.ClsGy_Duty_View oDuty = new DAL.ClsGy_Duty_View();
|
if (oDuty.RefreshView())
|
{
|
if (oDuty.GetInfoByID(oDuty.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HDutyIDCol].Value = oDuty.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HDutyNumberCol].Value = oDuty.omodel.HNumber;
|
grdMain.Rows[i].Cells[HDutyNameCol].Value = oDuty.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDutyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDutyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDutyNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDutyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDutyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDutyNameCol].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_Group(DataGridView grdMain, int i, int HEmpIDCol, int HEmpNumberCol, int HEmpNameCol, long HGroupID)
|
{
|
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_Employee_View();
|
if (oEmp.RefreshView("and HGroupID=" + HGroupID))
|
{
|
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="HEmpIDCol"></param>
|
/// <param name="HEmpNumberCol"></param>
|
/// <param name="HEmpNameCol"></param>
|
public static void SetGridByEmp(DataGridView grdMain, int i, int HEmpIDCol, int HEmpNumberCol, int HEmpNameCol)
|
{
|
|
DAL.ClsGy_Employee_View oEmp = new DAL.ClsGy_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="HEnergyIDCol"></param>
|
/// <param name="HEnergyNumberCol"></param>
|
/// <param name="HEnergyNameCol"></param>
|
public static void SetGridByEnergy(DataGridView grdMain, int i, int HEnergyIDCol, int HEnergyNumberCol, int HEnergyNameCol)
|
{
|
|
DAL.ClsGy_Energy_View oEnergy = new DAL.ClsGy_Energy_View();
|
if (oEnergy.RefreshView())
|
{
|
if (oEnergy.GetInfoByID(oEnergy.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HEnergyIDCol].Value = oEnergy.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HEnergyNumberCol].Value = oEnergy.omodel.HNumber;
|
grdMain.Rows[i].Cells[HEnergyNameCol].Value = oEnergy.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HEnergyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HEnergyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HEnergyNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HEnergyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HEnergyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HEnergyNameCol].Value = "";
|
}
|
}
|
|
//Òì³£ÀàÐÍ-Íø¸ñ
|
/// <summary>
|
/// Òì³£ÀàÐÍ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HErrTypeIDCol"></param>
|
/// <param name="HErrTypeNumberCol"></param>
|
/// <param name="HErrTypeNameCol"></param>
|
public static void SetGridByErrType(DataGridView grdMain, int i, int HErrTypeIDCol, int HErrTypeNumberCol, int HErrTypeNameCol)
|
{
|
|
DAL.ClsGy_ErrType_View oErrType = new DAL.ClsGy_ErrType_View();
|
if (oErrType.RefreshView())
|
{
|
if (oErrType.GetInfoByID(oErrType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HErrTypeIDCol].Value = oErrType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HErrTypeNumberCol].Value = oErrType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HErrTypeNameCol].Value = oErrType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HErrTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HErrTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HErrTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HErrTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HErrTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HErrTypeNameCol].Value = "";
|
}
|
}
|
|
//ÆÀ¼ÛÇé¿ö-Íø¸ñ
|
/// <summary>
|
/// ÆÀ¼ÛÇé¿ö-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HEvaluateStatusIDCol"></param>
|
/// <param name="HEvaluateStatusNumberCol"></param>
|
/// <param name="HEvaluateStatusNameCol"></param>
|
public static void SetGridByEvaluateStatus(DataGridView grdMain, int i, int HEvaluateStatusIDCol, int HEvaluateStatusNumberCol, int HEvaluateStatusNameCol)
|
{
|
|
DAL.ClsGy_EvaluateStatus_View oEvaluateStatus = new DAL.ClsGy_EvaluateStatus_View();
|
if (oEvaluateStatus.RefreshView())
|
{
|
if (oEvaluateStatus.GetInfoByID(oEvaluateStatus.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HEvaluateStatusIDCol].Value = oEvaluateStatus.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HEvaluateStatusNumberCol].Value = oEvaluateStatus.omodel.HNumber;
|
grdMain.Rows[i].Cells[HEvaluateStatusNameCol].Value = oEvaluateStatus.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HEvaluateStatusIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HEvaluateStatusNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HEvaluateStatusNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HEvaluateStatusIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HEvaluateStatusNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HEvaluateStatusNameCol].Value = "";
|
}
|
}
|
|
//·ÑÓÃÇé¿ö-Íø¸ñ
|
/// <summary>
|
/// ·ÑÓÃÇé¿ö-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HExpenseStatusIDCol"></param>
|
/// <param name="HExpenseStatusNumberCol"></param>
|
/// <param name="HExpenseStatusNameCol"></param>
|
public static void SetGridByExpenseStatus(DataGridView grdMain, int i, int HExpenseStatusIDCol, int HExpenseStatusNumberCol, int HExpenseStatusNameCol)
|
{
|
|
DAL.ClsGy_ExpenseStatus_View oExpenseStatus = new DAL.ClsGy_ExpenseStatus_View();
|
if (oExpenseStatus.RefreshView())
|
{
|
if (oExpenseStatus.GetInfoByID(oExpenseStatus.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HExpenseStatusIDCol].Value = oExpenseStatus.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HExpenseStatusNumberCol].Value = oExpenseStatus.omodel.HNumber;
|
grdMain.Rows[i].Cells[HExpenseStatusNameCol].Value = oExpenseStatus.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HExpenseStatusIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HExpenseStatusNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HExpenseStatusNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HExpenseStatusIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HExpenseStatusNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HExpenseStatusNameCol].Value = "";
|
}
|
}
|
|
//³µÁ¾³§¼Ò-Íø¸ñ
|
/// <summary>
|
/// ³µÁ¾³§¼Ò-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HFactoryIDCol"></param>
|
/// <param name="HFactoryNumberCol"></param>
|
/// <param name="HFactoryNameCol"></param>
|
public static void SetGridByFactory(DataGridView grdMain, int i, int HFactoryIDCol, int HFactoryNumberCol, int HFactoryNameCol)
|
{
|
|
DAL.ClsGy_Factory_View oFactory = new DAL.ClsGy_Factory_View();
|
if (oFactory.RefreshView())
|
{
|
if (oFactory.GetInfoByID(oFactory.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HFactoryIDCol].Value = oFactory.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HFactoryNumberCol].Value = oFactory.omodel.HNumber;
|
grdMain.Rows[i].Cells[HFactoryNameCol].Value = oFactory.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HFactoryIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HFactoryNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HFactoryNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HFactoryIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HFactoryNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HFactoryNameCol].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(DataGridView grdMain, int i, int HGroupIDCol, int HGroupNumberCol, int HGroupNameCol)
|
{
|
|
DAL.ClsGy_Group_View oGroup = new DAL.ClsGy_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="HHolidayIDCol"></param>
|
/// <param name="HHolidayNumberCol"></param>
|
/// <param name="HHolidayNameCol"></param>
|
public static void SetGridByHoliday(DataGridView grdMain, int i, int HHolidayIDCol, int HHolidayNumberCol, int HHolidayNameCol)
|
{
|
|
DAL.ClsGy_Holiday_View oHoliday = new DAL.ClsGy_Holiday_View();
|
if (oHoliday.RefreshView())
|
{
|
if (oHoliday.GetInfoByID(oHoliday.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HHolidayIDCol].Value = oHoliday.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HHolidayNumberCol].Value = oHoliday.omodel.HNumber;
|
grdMain.Rows[i].Cells[HHolidayNameCol].Value = oHoliday.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HHolidayIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HHolidayNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HHolidayNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HHolidayIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HHolidayNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HHolidayNameCol].Value = "";
|
}
|
}
|
|
//±£ÑøÏîÄ¿-Íø¸ñ
|
/// <summary>
|
/// ±£ÑøÏîÄ¿-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HMaintainIDCol"></param>
|
/// <param name="HMaintainNumberCol"></param>
|
/// <param name="HMaintainNameCol"></param>
|
public static void SetGridByMaintain(DataGridView grdMain, int i, int HMaintainIDCol, int HMaintainNumberCol, int HMaintainNameCol)
|
{
|
|
DAL.ClsGy_Maintain_View oMaintain = new DAL.ClsGy_Maintain_View();
|
if (oMaintain.RefreshView())
|
{
|
if (oMaintain.GetInfoByID(oMaintain.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HMaintainIDCol].Value = oMaintain.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HMaintainNumberCol].Value = oMaintain.omodel.HNumber;
|
grdMain.Rows[i].Cells[HMaintainNameCol].Value = oMaintain.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaintainIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaintainNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaintainNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaintainIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaintainNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaintainNameCol].Value = "";
|
}
|
}
|
|
//¿Í»§¶ÔÓ¦ÎïÁÏ-Íø¸ñ
|
/// <summary>
|
/// ¿Í»§¶ÔÓ¦ÎïÁÏ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HMateNumRelationIDCol"></param>
|
/// <param name="HMateNumRelationNumberCol"></param>
|
/// <param name="HMateNumRelationNameCol"></param>
|
public static void SetGridByMateNumRelation(DataGridView grdMain, int i, int HMateNumRelationIDCol, int HMateNumRelationNumberCol, int HMateNumRelationNameCol)
|
{
|
|
DAL.ClsGy_MateNumRelation_View oMateNumRelation = new DAL.ClsGy_MateNumRelation_View();
|
if (oMateNumRelation.RefreshView())
|
{
|
if (oMateNumRelation.GetInfoByID(oMateNumRelation.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HMateNumRelationIDCol].Value = oMateNumRelation.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HMateNumRelationNumberCol].Value = oMateNumRelation.omodel.HNumber;
|
grdMain.Rows[i].Cells[HMateNumRelationNameCol].Value = oMateNumRelation.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMateNumRelationIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMateNumRelationNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMateNumRelationNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMateNumRelationIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMateNumRelationNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMateNumRelationNameCol].Value = "";
|
}
|
}
|
|
//ÎïÁÏÌØÐÔ-Íø¸ñ
|
/// <summary>
|
/// ÎïÁÏÌØÐÔ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HMaterTraitIDCol"></param>
|
/// <param name="HMaterTraitNumberCol"></param>
|
/// <param name="HMaterTraitNameCol"></param>
|
public static void SetGridByMaterTrait(DataGridView grdMain, int i, int HMaterTraitIDCol, int HMaterTraitNumberCol, int HMaterTraitNameCol)
|
{
|
|
DAL.ClsGy_MaterTrait_View oMaterTrait = new DAL.ClsGy_MaterTrait_View();
|
if (oMaterTrait.RefreshView())
|
{
|
if (oMaterTrait.GetInfoByID(oMaterTrait.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HMaterTraitIDCol].Value = oMaterTrait.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HMaterTraitNumberCol].Value = oMaterTrait.omodel.HNumber;
|
grdMain.Rows[i].Cells[HMaterTraitNameCol].Value = oMaterTrait.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterTraitIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterTraitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterTraitNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterTraitIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterTraitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterTraitNameCol].Value = "";
|
}
|
}
|
|
//¹æ¸ñÐͺÅ-Íø¸ñ
|
/// <summary>
|
/// ¹æ¸ñÐͺÅ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HModelIDCol"></param>
|
/// <param name="HModelNumberCol"></param>
|
/// <param name="HModelNameCol"></param>
|
public static void SetGridByModel(DataGridView grdMain, int i, int HModelIDCol, int HModelNumberCol, int HModelNameCol)
|
{
|
|
DAL.ClsGy_Model_View oModel = new DAL.ClsGy_Model_View();
|
if (oModel.RefreshView())
|
{
|
if (oModel.GetInfoByID(oModel.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HModelIDCol].Value = oModel.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HModelNumberCol].Value = oModel.omodel.HNumber;
|
grdMain.Rows[i].Cells[HModelNameCol].Value = oModel.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HModelIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HModelNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HModelNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HModelIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HModelNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HModelNameCol].Value = "";
|
}
|
}
|
|
//¶©µ¥µÈ¼¶-Íø¸ñ
|
/// <summary>
|
/// ¶©µ¥µÈ¼¶-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HOrderLevIDCol"></param>
|
/// <param name="HOrderLevNumberCol"></param>
|
/// <param name="HOrderLevNameCol"></param>
|
public static void SetGridByOrderLev(DataGridView grdMain, int i, int HOrderLevIDCol, int HOrderLevNumberCol, int HOrderLevNameCol)
|
{
|
|
DAL.ClsGy_OrderLev_View oOrderLev = new DAL.ClsGy_OrderLev_View();
|
if (oOrderLev.RefreshView())
|
{
|
if (oOrderLev.GetInfoByID(oOrderLev.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HOrderLevIDCol].Value = oOrderLev.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HOrderLevNumberCol].Value = oOrderLev.omodel.HNumber;
|
grdMain.Rows[i].Cells[HOrderLevNameCol].Value = oOrderLev.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HOrderLevIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HOrderLevNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HOrderLevNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HOrderLevIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HOrderLevNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HOrderLevNameCol].Value = "";
|
}
|
}
|
|
//Ö¤¼þÀà±ð-Íø¸ñ
|
/// <summary>
|
/// Ö¤¼þÀà±ð-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HPaperSortIDCol"></param>
|
/// <param name="HPaperSortNumberCol"></param>
|
/// <param name="HPaperSortNameCol"></param>
|
public static void SetGridByPaperSort(DataGridView grdMain, int i, int HPaperSortIDCol, int HPaperSortNumberCol, int HPaperSortNameCol)
|
{
|
|
DAL.ClsGy_PaperSort_View oPaperSort = new DAL.ClsGy_PaperSort_View();
|
if (oPaperSort.RefreshView())
|
{
|
if (oPaperSort.GetInfoByID(oPaperSort.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HPaperSortIDCol].Value = oPaperSort.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HPaperSortNumberCol].Value = oPaperSort.omodel.HNumber;
|
grdMain.Rows[i].Cells[HPaperSortNameCol].Value = oPaperSort.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPaperSortIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPaperSortNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPaperSortNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPaperSortIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPaperSortNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPaperSortNameCol].Value = "";
|
}
|
}
|
|
//¸Û¿Ú-Íø¸ñ
|
/// <summary>
|
/// ¸Û¿Ú-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HPortIDCol"></param>
|
/// <param name="HPortNumberCol"></param>
|
/// <param name="HPortNameCol"></param>
|
public static void SetGridByPort(DataGridView grdMain, int i, int HPortIDCol, int HPortNumberCol, int HPortNameCol)
|
{
|
|
DAL.ClsGy_Port_View oPort = new DAL.ClsGy_Port_View();
|
if (oPort.RefreshView())
|
{
|
if (oPort.GetInfoByID(oPort.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HPortIDCol].Value = oPort.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HPortNumberCol].Value = oPort.omodel.HNumber;
|
grdMain.Rows[i].Cells[HPortNameCol].Value = oPort.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPortIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPortNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPortNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPortIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPortNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPortNameCol].Value = "";
|
}
|
}
|
|
//¸Úλ-Íø¸ñ
|
/// <summary>
|
/// ¸Úλ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HPostIDCol"></param>
|
/// <param name="HPostNumberCol"></param>
|
/// <param name="HPostNameCol"></param>
|
public static void SetGridByPost(DataGridView grdMain, int i, int HPostIDCol, int HPostNumberCol, int HPostNameCol)
|
{
|
|
DAL.ClsGy_Post_View oPost = new DAL.ClsGy_Post_View();
|
if (oPost.RefreshView())
|
{
|
if (oPost.GetInfoByID(oPost.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HPostIDCol].Value = oPost.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HPostNumberCol].Value = oPost.omodel.HNumber;
|
grdMain.Rows[i].Cells[HPostNameCol].Value = oPost.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPostIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPostNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPostNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPostIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPostNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPostNameCol].Value = "";
|
}
|
}
|
|
//ίÍ⹤Ðò-Íø¸ñ
|
/// <summary>
|
/// ίÍ⹤Ðò-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HProcCommIDCol"></param>
|
/// <param name="HProcCommNumberCol"></param>
|
/// <param name="HProcCommNameCol"></param>
|
public static void SetGridByProcComm(DataGridView grdMain, int i, int HProcCommIDCol, int HProcCommNumberCol, int HProcCommNameCol)
|
{
|
|
DAL.ClsGy_ProcComm_View oProcComm = new DAL.ClsGy_ProcComm_View();
|
if (oProcComm.RefreshView())
|
{
|
if (oProcComm.GetInfoByID(oProcComm.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HProcCommIDCol].Value = oProcComm.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HProcCommNumberCol].Value = oProcComm.omodel.HNumber;
|
grdMain.Rows[i].Cells[HProcCommNameCol].Value = oProcComm.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcCommIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcCommNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcCommNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcCommIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcCommNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcCommNameCol].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(DataGridView grdMain, int i, int HProcIDCol, int HProcNumberCol, int HProcNameCol)
|
{
|
|
DAL.ClsGy_Process_View oProc = new DAL.ClsGy_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="HProcMulIDCol"></param>
|
/// <param name="HProcMulNumberCol"></param>
|
/// <param name="HProcMulNameCol"></param>
|
public static void SetGridByProcMul(DataGridView grdMain, int i, int HProcMulIDCol, int HProcMulNumberCol, int HProcMulNameCol)
|
{
|
|
DAL.ClsGy_ProcMul_View oProcMul = new DAL.ClsGy_ProcMul_View();
|
if (oProcMul.RefreshView())
|
{
|
if (oProcMul.GetInfoByID(oProcMul.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HProcMulIDCol].Value = oProcMul.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HProcMulNumberCol].Value = oProcMul.omodel.HNumber;
|
grdMain.Rows[i].Cells[HProcMulNameCol].Value = oProcMul.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcMulIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcMulNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcMulNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcMulIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcMulNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcMulNameCol].Value = "";
|
}
|
}
|
|
//¶¨¶î¹é¼¯-Íø¸ñ
|
/// <summary>
|
/// ¶¨¶î¹é¼¯-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HProcPriceRelaIDCol"></param>
|
/// <param name="HProcPriceRelaNumberCol"></param>
|
/// <param name="HProcPriceRelaNameCol"></param>
|
public static void SetGridByProcPriceRela(DataGridView grdMain, int i, int HProcPriceRelaIDCol, int HProcPriceRelaNumberCol, int HProcPriceRelaNameCol)
|
{
|
|
DAL.ClsGy_ProcPriceRela_View oProcPriceRela = new DAL.ClsGy_ProcPriceRela_View();
|
if (oProcPriceRela.RefreshView())
|
{
|
if (oProcPriceRela.GetInfoByID(oProcPriceRela.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HProcPriceRelaIDCol].Value = oProcPriceRela.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HProcPriceRelaNumberCol].Value = oProcPriceRela.omodel.HNumber;
|
grdMain.Rows[i].Cells[HProcPriceRelaNameCol].Value = oProcPriceRela.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcPriceRelaIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcPriceRelaNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcPriceRelaNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcPriceRelaIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcPriceRelaNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcPriceRelaNameCol].Value = "";
|
}
|
}
|
|
//¶¨¶î¹é¼¯×é-Íø¸ñ
|
/// <summary>
|
/// ¶¨¶î¹é¼¯×é-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HProcPriceRelaGroupIDCol"></param>
|
/// <param name="HProcPriceRelaGroupNumberCol"></param>
|
/// <param name="HProcPriceRelaGroupNameCol"></param>
|
public static void SetGridByProcPriceRelaGroup(DataGridView grdMain, int i, int HProcPriceRelaGroupIDCol, int HProcPriceRelaGroupNumberCol, int HProcPriceRelaGroupNameCol)
|
{
|
|
DAL.ClsGy_ProcPriceRelaGroup_View oProcPriceRelaGroup = new DAL.ClsGy_ProcPriceRelaGroup_View();
|
if (oProcPriceRelaGroup.RefreshView())
|
{
|
if (oProcPriceRelaGroup.GetInfoByID(oProcPriceRelaGroup.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupIDCol].Value = oProcPriceRelaGroup.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupNumberCol].Value = oProcPriceRelaGroup.omodel.HNumber;
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupNameCol].Value = oProcPriceRelaGroup.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProcPriceRelaGroupNameCol].Value = "";
|
}
|
}
|
|
//Éú²úÀàÐÍ-Íø¸ñ
|
/// <summary>
|
/// Éú²úÀàÐÍ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HProdTypeIDCol"></param>
|
/// <param name="HProdTypeNumberCol"></param>
|
/// <param name="HProdTypeNameCol"></param>
|
public static void SetGridByProdType(DataGridView grdMain, int i, int HProdTypeIDCol, int HProdTypeNumberCol, int HProdTypeNameCol)
|
{
|
|
DAL.ClsGy_ProdType_View oProdType = new DAL.ClsGy_ProdType_View();
|
if (oProdType.RefreshView())
|
{
|
if (oProdType.GetInfoByID(oProdType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HProdTypeIDCol].Value = oProdType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HProdTypeNumberCol].Value = oProdType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HProdTypeNameCol].Value = oProdType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProdTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProdTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProdTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProdTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProdTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProdTypeNameCol].Value = "";
|
}
|
}
|
|
//²úÆ·ÌØÐÔ-Íø¸ñ
|
/// <summary>
|
/// ²úÆ·ÌØÐÔ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HProductSpecIDCol"></param>
|
/// <param name="HProductSpecNumberCol"></param>
|
/// <param name="HProductSpecNameCol"></param>
|
public static void SetGridByProductSpec(DataGridView grdMain, int i, int HProductSpecIDCol, int HProductSpecNumberCol, int HProductSpecNameCol)
|
{
|
|
DAL.ClsGy_ProductSpec_View oProductSpec = new DAL.ClsGy_ProductSpec_View();
|
if (oProductSpec.RefreshView())
|
{
|
if (oProductSpec.GetInfoByID(oProductSpec.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HProductSpecIDCol].Value = oProductSpec.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HProductSpecNumberCol].Value = oProductSpec.omodel.HNumber;
|
grdMain.Rows[i].Cells[HProductSpecNameCol].Value = oProductSpec.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProductSpecIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProductSpecNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProductSpecNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProductSpecIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProductSpecNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProductSpecNameCol].Value = "";
|
}
|
}
|
|
//ÏîÄ¿¹¤³Ì-Íø¸ñ
|
/// <summary>
|
/// ÏîÄ¿¹¤³Ì-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HProjectIDCol"></param>
|
/// <param name="HProjectNumberCol"></param>
|
/// <param name="HProjectNameCol"></param>
|
public static void SetGridByProject(DataGridView grdMain, int i, int HProjectIDCol, int HProjectNumberCol, int HProjectNameCol)
|
{
|
|
DAL.ClsGy_Project_View oProject = new DAL.ClsGy_Project_View();
|
if (oProject.RefreshView())
|
{
|
if (oProject.GetInfoByID(oProject.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HProjectIDCol].Value = oProject.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HProjectNumberCol].Value = oProject.omodel.HNumber;
|
grdMain.Rows[i].Cells[HProjectNameCol].Value = oProject.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProjectIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProjectNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProjectNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HProjectIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HProjectNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HProjectNameCol].Value = "";
|
}
|
}
|
|
//¸¨ÖúÊôÐÔ-Íø¸ñ
|
/// <summary>
|
/// ¸¨ÖúÊôÐÔ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HPropertyIDCol"></param>
|
/// <param name="HPropertyNumberCol"></param>
|
/// <param name="HPropertyNameCol"></param>
|
public static void SetGridByProperty(DataGridView grdMain, int i, int HPropertyIDCol, int HPropertyNumberCol, int HPropertyNameCol)
|
{
|
|
DAL.ClsGy_Property_View oProperty = new DAL.ClsGy_Property_View();
|
if (oProperty.RefreshView())
|
{
|
if (oProperty.GetInfoByID(oProperty.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HPropertyIDCol].Value = oProperty.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HPropertyNumberCol].Value = oProperty.omodel.HNumber;
|
grdMain.Rows[i].Cells[HPropertyNameCol].Value = oProperty.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPropertyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPropertyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPropertyNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPropertyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPropertyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPropertyNameCol].Value = "";
|
}
|
}
|
|
//¸¨ÖúÊôÐÔÀà±ð-Íø¸ñ
|
/// <summary>
|
/// ¸¨ÖúÊôÐÔÀà±ð-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HPropertyTypeIDCol"></param>
|
/// <param name="HPropertyTypeNumberCol"></param>
|
/// <param name="HPropertyTypeNameCol"></param>
|
public static void SetGridByPropertyType(DataGridView grdMain, int i, int HPropertyTypeIDCol, int HPropertyTypeNumberCol, int HPropertyTypeNameCol)
|
{
|
|
DAL.ClsGy_PropertyType_View oPropertyType = new DAL.ClsGy_PropertyType_View();
|
if (oPropertyType.RefreshView())
|
{
|
if (oPropertyType.GetInfoByID(oPropertyType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HPropertyTypeIDCol].Value = oPropertyType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HPropertyTypeNumberCol].Value = oPropertyType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HPropertyTypeNameCol].Value = oPropertyType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPropertyTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPropertyTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPropertyTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HPropertyTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HPropertyTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HPropertyTypeNameCol].Value = "";
|
}
|
}
|
|
//άÐÞÏîÄ¿-Íø¸ñ
|
/// <summary>
|
/// άÐÞÏîÄ¿-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HRepairIDCol"></param>
|
/// <param name="HRepairNumberCol"></param>
|
/// <param name="HRepairNameCol"></param>
|
public static void SetGridByRepair(DataGridView grdMain, int i, int HRepairIDCol, int HRepairNumberCol, int HRepairNameCol)
|
{
|
|
DAL.ClsGy_Repair_View oRepair = new DAL.ClsGy_Repair_View();
|
if (oRepair.RefreshView())
|
{
|
if (oRepair.GetInfoByID(oRepair.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HRepairIDCol].Value = oRepair.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HRepairNumberCol].Value = oRepair.omodel.HNumber;
|
grdMain.Rows[i].Cells[HRepairNameCol].Value = oRepair.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HRepairIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HRepairNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HRepairNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HRepairIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HRepairNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HRepairNameCol].Value = "";
|
}
|
}
|
|
//άÐÞÑéÊÕÏîÄ¿-Íø¸ñ
|
/// <summary>
|
/// άÐÞÑéÊÕÏîÄ¿-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HRepairCheckIDCol"></param>
|
/// <param name="HRepairCheckNumberCol"></param>
|
/// <param name="HRepairCheckNameCol"></param>
|
public static void SetGridByRepairCheck(DataGridView grdMain, int i, int HRepairCheckIDCol, int HRepairCheckNumberCol, int HRepairCheckNameCol)
|
{
|
|
DAL.ClsGy_RepairCheck_View oRepairCheck = new DAL.ClsGy_RepairCheck_View();
|
if (oRepairCheck.RefreshView())
|
{
|
if (oRepairCheck.GetInfoByID(oRepairCheck.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HRepairCheckIDCol].Value = oRepairCheck.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HRepairCheckNumberCol].Value = oRepairCheck.omodel.HNumber;
|
grdMain.Rows[i].Cells[HRepairCheckNameCol].Value = oRepairCheck.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HRepairCheckIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HRepairCheckNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HRepairCheckNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HRepairCheckIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HRepairCheckNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HRepairCheckNameCol].Value = "";
|
}
|
}
|
|
//άÐÞ·½Ê½-Íø¸ñ
|
/// <summary>
|
/// άÐÞ·½Ê½-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HRepairTypeIDCol"></param>
|
/// <param name="HRepairTypeNumberCol"></param>
|
/// <param name="HRepairTypeNameCol"></param>
|
public static void SetGridByRepairType(DataGridView grdMain, int i, int HRepairTypeIDCol, int HRepairTypeNumberCol, int HRepairTypeNameCol)
|
{
|
|
DAL.ClsGy_RepairType_View oRepairType = new DAL.ClsGy_RepairType_View();
|
if (oRepairType.RefreshView())
|
{
|
if (oRepairType.GetInfoByID(oRepairType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HRepairTypeIDCol].Value = oRepairType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HRepairTypeNumberCol].Value = oRepairType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HRepairTypeNameCol].Value = oRepairType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HRepairTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HRepairTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HRepairTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HRepairTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HRepairTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HRepairTypeNameCol].Value = "";
|
}
|
}
|
|
//¹¤ÒÕ·Ïß´óÀà-Íø¸ñ
|
/// <summary>
|
/// ¹¤ÒÕ·Ïß´óÀà-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HRoutingGroupIDCol"></param>
|
/// <param name="HRoutingGroupNumberCol"></param>
|
/// <param name="HRoutingGroupNameCol"></param>
|
public static void SetGridByRoutingGroup(DataGridView grdMain, int i, int HRoutingGroupIDCol, int HRoutingGroupNumberCol, int HRoutingGroupNameCol)
|
{
|
|
DAL.ClsGy_RoutingGroup_View oRoutingGroup = new DAL.ClsGy_RoutingGroup_View();
|
if (oRoutingGroup.RefreshView())
|
{
|
if (oRoutingGroup.GetInfoByID(oRoutingGroup.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HRoutingGroupIDCol].Value = oRoutingGroup.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HRoutingGroupNumberCol].Value = oRoutingGroup.omodel.HNumber;
|
grdMain.Rows[i].Cells[HRoutingGroupNameCol].Value = oRoutingGroup.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HRoutingGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HRoutingGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HRoutingGroupNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HRoutingGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HRoutingGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HRoutingGroupNameCol].Value = "";
|
}
|
}
|
|
//°²È«ÏîÄ¿-Íø¸ñ
|
/// <summary>
|
/// °²È«ÏîÄ¿-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSafetyIDCol"></param>
|
/// <param name="HSafetyNumberCol"></param>
|
/// <param name="HSafetyNameCol"></param>
|
public static void SetGridBySafety(DataGridView grdMain, int i, int HSafetyIDCol, int HSafetyNumberCol, int HSafetyNameCol)
|
{
|
|
DAL.ClsGy_Safety_View oSafety = new DAL.ClsGy_Safety_View();
|
if (oSafety.RefreshView())
|
{
|
if (oSafety.GetInfoByID(oSafety.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSafetyIDCol].Value = oSafety.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSafetyNumberCol].Value = oSafety.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSafetyNameCol].Value = oSafety.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSafetyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSafetyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSafetyNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSafetyIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSafetyNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSafetyNameCol].Value = "";
|
}
|
}
|
|
//±¨·ÏÔÒò-Íø¸ñ
|
/// <summary>
|
/// ±¨·ÏÔÒò-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HScrapReasonIDCol"></param>
|
/// <param name="HScrapReasonNumberCol"></param>
|
/// <param name="HScrapReasonNameCol"></param>
|
public static void SetGridByScrapReason(DataGridView grdMain, int i, int HScrapReasonIDCol, int HScrapReasonNumberCol, int HScrapReasonNameCol)
|
{
|
|
DAL.ClsGy_ScrapReason_View oScrapReason = new DAL.ClsGy_ScrapReason_View();
|
if (oScrapReason.RefreshView())
|
{
|
if (oScrapReason.GetInfoByID(oScrapReason.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HScrapReasonIDCol].Value = oScrapReason.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HScrapReasonNumberCol].Value = oScrapReason.omodel.HNumber;
|
grdMain.Rows[i].Cells[HScrapReasonNameCol].Value = oScrapReason.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HScrapReasonIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HScrapReasonNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HScrapReasonNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HScrapReasonIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HScrapReasonNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HScrapReasonNameCol].Value = "";
|
}
|
}
|
|
//·þÎñÀàÐÍ-Íø¸ñ
|
/// <summary>
|
/// ·þÎñÀàÐÍ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSecTypeIDCol"></param>
|
/// <param name="HSecTypeNumberCol"></param>
|
/// <param name="HSecTypeNameCol"></param>
|
public static void SetGridBySecType(DataGridView grdMain, int i, int HSecTypeIDCol, int HSecTypeNumberCol, int HSecTypeNameCol)
|
{
|
|
DAL.ClsGy_SecType_View oSecType = new DAL.ClsGy_SecType_View();
|
if (oSecType.RefreshView())
|
{
|
if (oSecType.GetInfoByID(oSecType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSecTypeIDCol].Value = oSecType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSecTypeNumberCol].Value = oSecType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSecTypeNameCol].Value = oSecType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSecTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSecTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSecTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSecTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSecTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSecTypeNameCol].Value = "";
|
}
|
}
|
|
//ÏúÊÛ·½Ê½-Íø¸ñ
|
/// <summary>
|
/// ÏúÊÛ·½Ê½-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSellStyleIDCol"></param>
|
/// <param name="HSellStyleNumberCol"></param>
|
/// <param name="HSellStyleNameCol"></param>
|
public static void SetGridBySellStyle(DataGridView grdMain, int i, int HSellStyleIDCol, int HSellStyleNumberCol, int HSellStyleNameCol)
|
{
|
|
DAL.ClsGy_SellStyle_View oSellStyle = new DAL.ClsGy_SellStyle_View();
|
if (oSellStyle.RefreshView())
|
{
|
if (oSellStyle.GetInfoByID(oSellStyle.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSellStyleIDCol].Value = oSellStyle.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSellStyleNumberCol].Value = oSellStyle.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSellStyleNameCol].Value = oSellStyle.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSellStyleIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSellStyleNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSellStyleNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSellStyleIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSellStyleNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSellStyleNameCol].Value = "";
|
}
|
}
|
|
//½áË㷽ʽ-Íø¸ñ
|
/// <summary>
|
/// ½áË㷽ʽ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSettleStyleIDCol"></param>
|
/// <param name="HSettleStyleNumberCol"></param>
|
/// <param name="HSettleStyleNameCol"></param>
|
public static void SetGridBySettleStyle(DataGridView grdMain, int i, int HSettleStyleIDCol, int HSettleStyleNumberCol, int HSettleStyleNameCol)
|
{
|
|
DAL.ClsGy_SettleStyle_View oSettleStyle = new DAL.ClsGy_SettleStyle_View();
|
if (oSettleStyle.RefreshView())
|
{
|
if (oSettleStyle.GetInfoByID(oSettleStyle.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSettleStyleIDCol].Value = oSettleStyle.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSettleStyleNumberCol].Value = oSettleStyle.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSettleStyleNameCol].Value = oSettleStyle.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSettleStyleIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSettleStyleNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSettleStyleNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSettleStyleIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSettleStyleNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSettleStyleNameCol].Value = "";
|
}
|
}
|
|
//°à´Î-Íø¸ñ
|
/// <summary>
|
/// °à´Î-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HShiftsIDCol"></param>
|
/// <param name="HShiftsNumberCol"></param>
|
/// <param name="HShiftsNameCol"></param>
|
public static void SetGridByShifts(DataGridView grdMain, int i, int HShiftsIDCol, int HShiftsNumberCol, int HShiftsNameCol)
|
{
|
|
DAL.ClsGy_Shifts_View oShifts = new DAL.ClsGy_Shifts_View();
|
if (oShifts.RefreshView())
|
{
|
if (oShifts.GetInfoByID(oShifts.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HShiftsIDCol].Value = oShifts.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HShiftsNumberCol].Value = oShifts.omodel.HNumber;
|
grdMain.Rows[i].Cells[HShiftsNameCol].Value = oShifts.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HShiftsIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HShiftsNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HShiftsNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HShiftsIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HShiftsNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HShiftsNameCol].Value = "";
|
}
|
}
|
|
//Éú²ú×ÊÔ´-Íø¸ñ
|
/// <summary>
|
/// Éú²ú×ÊÔ´-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSourceIDCol"></param>
|
/// <param name="HSourceNumberCol"></param>
|
/// <param name="HSourceNameCol"></param>
|
public static void SetGridBySource(DataGridView grdMain, int i, int HSourceIDCol, int HSourceNumberCol, int HSourceNameCol)
|
{
|
|
DAL.ClsGy_Source_View oSource = new DAL.ClsGy_Source_View();
|
if (oSource.RefreshView())
|
{
|
if (oSource.GetInfoByID(oSource.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSourceIDCol].Value = oSource.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSourceNumberCol].Value = oSource.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSourceNameCol].Value = oSource.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSourceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSourceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSourceNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSourceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSourceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSourceNameCol].Value = "";
|
}
|
}
|
|
|
|
|
//²Öλ-Íø¸ñ
|
/// <summary>
|
/// ²Öλ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HStockPlaceIDCol"></param>
|
/// <param name="HStockPlaceNumberCol"></param>
|
/// <param name="HStockPlaceNameCol"></param>
|
public static void SetGridByStockPlace(DataGridView grdMain, int i, int HStockPlaceIDCol, int HStockPlaceNumberCol, int HStockPlaceNameCol)
|
{
|
|
DAL.ClsGy_StockPlace_View oStockPlace = new DAL.ClsGy_StockPlace_View();
|
if (oStockPlace.RefreshView())
|
{
|
if (oStockPlace.GetInfoByID(oStockPlace.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = oStockPlace.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = oStockPlace.omodel.HNumber;
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = oStockPlace.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HStockPlaceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HStockPlaceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HStockPlaceNameCol].Value = "";
|
}
|
}
|
|
//²Öλ×é-Íø¸ñ
|
/// <summary>
|
/// ²Öλ×é-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HStockPlaceGroupIDCol"></param>
|
/// <param name="HStockPlaceGroupNumberCol"></param>
|
/// <param name="HStockPlaceGroupNameCol"></param>
|
public static void SetGridByStockPlaceGroup(DataGridView grdMain, int i, int HStockPlaceGroupIDCol, int HStockPlaceGroupNumberCol, int HStockPlaceGroupNameCol)
|
{
|
|
DAL.ClsGy_StockPlaceGroup_View oStockPlaceGroup = new DAL.ClsGy_StockPlaceGroup_View();
|
if (oStockPlaceGroup.RefreshView())
|
{
|
if (oStockPlaceGroup.GetInfoByID(oStockPlaceGroup.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HStockPlaceGroupIDCol].Value = oStockPlaceGroup.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HStockPlaceGroupNumberCol].Value = oStockPlaceGroup.omodel.HNumber;
|
grdMain.Rows[i].Cells[HStockPlaceGroupNameCol].Value = oStockPlaceGroup.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HStockPlaceGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HStockPlaceGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HStockPlaceGroupNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HStockPlaceGroupIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HStockPlaceGroupNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HStockPlaceGroupNameCol].Value = "";
|
}
|
}
|
|
//¹©Ó¦ÉÌ-Íø¸ñ
|
/// <summary>
|
/// ¹©Ó¦ÉÌ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSupplierIDCol"></param>
|
/// <param name="HSupplierNumberCol"></param>
|
/// <param name="HSupplierNameCol"></param>
|
public static void SetGridBySupplier(DataGridView grdMain, int i, int HSupplierIDCol, int HSupplierNumberCol, int HSupplierNameCol)
|
{
|
|
DAL.ClsGy_Supplier_View oSupplier = new DAL.ClsGy_Supplier_View();
|
if (oSupplier.RefreshView())
|
{
|
if (oSupplier.GetInfoByID(oSupplier.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSupplierIDCol].Value = oSupplier.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSupplierNumberCol].Value = oSupplier.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSupplierNameCol].Value = oSupplier.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSupplierIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSupplierNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSupplierNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSupplierIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSupplierNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSupplierNameCol].Value = "";
|
}
|
}
|
|
//¹©Ó¦ÉÌÖ¸±ê-Íø¸ñ
|
/// <summary>
|
/// ¹©Ó¦ÉÌÖ¸±ê-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HSupTargetIDCol"></param>
|
/// <param name="HSupTargetNumberCol"></param>
|
/// <param name="HSupTargetNameCol"></param>
|
public static void SetGridBySupTarget(DataGridView grdMain, int i, int HSupTargetIDCol, int HSupTargetNumberCol, int HSupTargetNameCol)
|
{
|
|
DAL.ClsGy_SupTarget_View oSupTarget = new DAL.ClsGy_SupTarget_View();
|
if (oSupTarget.RefreshView())
|
{
|
if (oSupTarget.GetInfoByID(oSupTarget.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HSupTargetIDCol].Value = oSupTarget.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HSupTargetNumberCol].Value = oSupTarget.omodel.HNumber;
|
grdMain.Rows[i].Cells[HSupTargetNameCol].Value = oSupTarget.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSupTargetIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSupTargetNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSupTargetNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HSupTargetIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HSupTargetNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HSupTargetNameCol].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(DataGridView grdMain, int i, int HUnitGroupIDCol, int HUnitGroupNumberCol, int HUnitGroupNameCol)
|
{
|
|
DAL.ClsGy_UnitGroup_View oUnitGroup = new DAL.ClsGy_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="HWorkCenterIDCol"></param>
|
/// <param name="HWorkCenterNumberCol"></param>
|
/// <param name="HWorkCenterNameCol"></param>
|
public static void SetGridByWorkCenter(DataGridView grdMain, int i, int HWorkCenterIDCol, int HWorkCenterNumberCol, int HWorkCenterNameCol)
|
{
|
|
DAL.ClsGy_WorkCenter_View oWorkCenter = new DAL.ClsGy_WorkCenter_View();
|
if (oWorkCenter.RefreshView())
|
{
|
if (oWorkCenter.GetInfoByID(oWorkCenter.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HWorkCenterIDCol].Value = oWorkCenter.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HWorkCenterNumberCol].Value = oWorkCenter.omodel.HNumber;
|
grdMain.Rows[i].Cells[HWorkCenterNameCol].Value = oWorkCenter.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HWorkCenterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HWorkCenterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HWorkCenterNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HWorkCenterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HWorkCenterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HWorkCenterNameCol].Value = "";
|
}
|
}
|
|
//¹¤×ÊÀàÐÍ-Íø¸ñ
|
/// <summary>
|
/// ¹¤×ÊÀàÐÍ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HWorkPayTypeIDCol"></param>
|
/// <param name="HWorkPayTypeNumberCol"></param>
|
/// <param name="HWorkPayTypeNameCol"></param>
|
public static void SetGridByWorkPayType(DataGridView grdMain, int i, int HWorkPayTypeIDCol, int HWorkPayTypeNumberCol, int HWorkPayTypeNameCol)
|
{
|
|
DAL.ClsGy_WorkPayType_View oWorkPayType = new DAL.ClsGy_WorkPayType_View();
|
if (oWorkPayType.RefreshView())
|
{
|
if (oWorkPayType.GetInfoByID(oWorkPayType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HWorkPayTypeIDCol].Value = oWorkPayType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HWorkPayTypeNumberCol].Value = oWorkPayType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HWorkPayTypeNameCol].Value = oWorkPayType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HWorkPayTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HWorkPayTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HWorkPayTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HWorkPayTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HWorkPayTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HWorkPayTypeNameCol].Value = "";
|
}
|
}
|
|
//¹¤ÖÖ-Íø¸ñ
|
/// <summary>
|
/// ¹¤ÖÖ-Íø¸ñ
|
/// </summary>
|
/// <param name="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HWorkTypeIDCol"></param>
|
/// <param name="HWorkTypeNumberCol"></param>
|
/// <param name="HWorkTypeNameCol"></param>
|
public static void SetGridByWorkType(DataGridView grdMain, int i, int HWorkTypeIDCol, int HWorkTypeNumberCol, int HWorkTypeNameCol)
|
{
|
DAL.ClsGy_WorkType_View oWorkType = new DAL.ClsGy_WorkType_View();
|
if (oWorkType.RefreshView())
|
{
|
if (oWorkType.GetInfoByID(oWorkType.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HWorkTypeIDCol].Value = oWorkType.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HWorkTypeNumberCol].Value = oWorkType.omodel.HNumber;
|
grdMain.Rows[i].Cells[HWorkTypeNameCol].Value = oWorkType.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HWorkTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HWorkTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HWorkTypeNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HWorkTypeIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HWorkTypeNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HWorkTypeNameCol].Value = "";
|
}
|
}
|
|
|
//ÐéÄâ²Ö¿â-Íø¸ñ
|
/// <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 SetGridByVirtualWarehouse(DataGridView grdMain, int i, int HWhIDCol, int HWhNumberCol, int HWhNameCol)
|
{
|
DAL.ClsGy_VirtualWarehouse_View oWh = new DAL.ClsGy_VirtualWarehouse_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="HStockPlaceIDCol"></param>
|
/// <param name="HStockPlaceNumberCol"></param>
|
/// <param name="HStockPlaceNameCol"></param>
|
public static void SetGridByVirtualStockPlace(DataGridView grdMain, int i, int HVirtualStockPlaceIDCol, int HVirtualStockPlaceNumberCol, int HVirtualStockPlaceNameCol)
|
{
|
|
DAL.ClsGy_VirtualStockPlace_View oVirtualStockPlace = new DAL.ClsGy_VirtualStockPlace_View();
|
if (oVirtualStockPlace.RefreshView())
|
{
|
if (oVirtualStockPlace.GetInfoByID(oVirtualStockPlace.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HVirtualStockPlaceIDCol].Value = oVirtualStockPlace.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HVirtualStockPlaceNumberCol].Value = oVirtualStockPlace.omodel.HNumber;
|
grdMain.Rows[i].Cells[HVirtualStockPlaceNameCol].Value = oVirtualStockPlace.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HVirtualStockPlaceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HVirtualStockPlaceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HVirtualStockPlaceNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HVirtualStockPlaceIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HVirtualStockPlaceNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HVirtualStockPlaceNameCol].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 SetGridByDotCheckItem(DataGridView grdMain, int i, int HDotCheckItemIDCol, int HDotCheckItemNumberCol, int HDotCheckItemNameCol)
|
{
|
|
DAL.ClsGy_DotCheck_View oDot = new DAL.ClsGy_DotCheck_View();
|
if (oDot.RefreshView())
|
{
|
if (oDot.GetInfoByID(oDot.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HDotCheckItemIDCol].Value = oDot.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HDotCheckItemNumberCol].Value = oDot.omodel.HNumber;
|
grdMain.Rows[i].Cells[HDotCheckItemNameCol].Value = oDot.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDotCheckItemIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDotCheckItemNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDotCheckItemNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HDotCheckItemIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HDotCheckItemNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HDotCheckItemNameCol].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 SetGridByQCCheckClass(DataGridView grdMain, int i, int HQCCheckClassIDCol, int HQCCheckClassNumberCol, int HQCCheckClassNameCol)
|
//{
|
|
// DAL.ClsGy_QCCheckClass_View oQCCheckClass = new DAL.ClsGy_QCCheckClass_View();
|
// if (oQCCheckClass.RefreshView())
|
// {
|
// if (oQCCheckClass.GetInfoByID(oQCCheckClass.oModel.HItemID))
|
// {
|
// grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = oQCCheckClass.omodel.HItemID.ToString();
|
// grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = oQCCheckClass.omodel.HNumber;
|
// grdMain.Rows[i].Cells[HQCCheckClassNameCol].Value = oQCCheckClass.omodel.HName;
|
// }
|
// else
|
// {
|
// grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = "0";
|
// grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = "";
|
// grdMain.Rows[i].Cells[HQCCheckClassNameCol].Value = "";
|
// }
|
// }
|
// else
|
// {
|
// grdMain.Rows[i].Cells[HQCCheckClassIDCol].Value = "0";
|
// grdMain.Rows[i].Cells[HQCCheckClassNumberCol].Value = "";
|
// grdMain.Rows[i].Cells[HQCCheckClassNameCol].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 SetGridByQCCheckItem(DataGridView grdMain, int i, int HQCCheckItemIDCol, int HQCCheckItemNumberCol, int HQCCheckItemNameCol)
|
//{
|
|
// DAL.ClsGy_QCCheckItem_View oQCCheckItem = new DAL.ClsGy_QCCheckItem_View();
|
// if (oQCCheckItem.RefreshView())
|
// {
|
// if (oQCCheckItem.GetInfoByID(oQCCheckItem.oModel.HItemID))
|
// {
|
// grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = oQCCheckItem.omodel.HItemID.ToString();
|
// grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = oQCCheckItem.omodel.HNumber;
|
// grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = oQCCheckItem.omodel.HName;
|
// }
|
// else
|
// {
|
// grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = "0";
|
// grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = "";
|
// grdMain.Rows[i].Cells[HQCCheckItemNameCol].Value = "";
|
// }
|
// }
|
// else
|
// {
|
// grdMain.Rows[i].Cells[HQCCheckItemIDCol].Value = "0";
|
// grdMain.Rows[i].Cells[HQCCheckItemNumberCol].Value = "";
|
// grdMain.Rows[i].Cells[HQCCheckItemNameCol].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 SetGridByCheckTools(DataGridView grdMain, int i, int HCheckToolsIDCol, int HCheckToolsNumberCol, int HCheckToolsNameCol)
|
{
|
|
DAL.ClsGy_CheckToolsFileMain_View oCheck = new DAL.ClsGy_CheckToolsFileMain_View();
|
if (oCheck.RefreshView())
|
{
|
if (oCheck.GetInfoByID(oCheck.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HCheckToolsIDCol].Value = oCheck.oModel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HCheckToolsNumberCol].Value = oCheck.oModel.HNumber;
|
grdMain.Rows[i].Cells[HCheckToolsNameCol].Value = oCheck.oModel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCheckToolsIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCheckToolsNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCheckToolsNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCheckToolsIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCheckToolsNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCheckToolsNameCol].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 SetGridByMouldFile(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol)
|
{
|
|
DAL.ClsGy_MouldFileMain_View oMFM = new DAL.ClsGy_MouldFileMain_View();
|
if (oMFM.RefreshView())
|
{
|
if (oMFM.GetInfoByID(oMFM.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = oMFM.oModel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMFM.oModel.HNumber;
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = oMFM.oModel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HMaterIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HMaterNameCol].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 SetGridByTech(DataGridView grdMain, int i, int HTechParamIDCol, int HTechParamNumberCol, int HTechParamNameCol)
|
{
|
|
DAL.ClsGy_TechnologyParameter_View oTech = new DAL.ClsGy_TechnologyParameter_View();
|
if (oTech.RefreshView())
|
{
|
if (oTech.GetInfoByID(oTech.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HTechParamIDCol].Value = oTech.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HTechParamNumberCol].Value = oTech.omodel.HNumber;
|
grdMain.Rows[i].Cells[HTechParamNameCol].Value = oTech.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HTechParamIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HTechParamNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HTechParamNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HTechParamIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HTechParamNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HTechParamNameCol].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 SetGridByTechU(DataGridView grdMain, int i, int HTechParamUnitIDCol, int HTechParamUnitNumberCol, int HTechParamUnitNameCol)
|
{
|
|
DAL.ClsGy_TechnologyParameterUnit_View oTechU = new DAL.ClsGy_TechnologyParameterUnit_View();
|
if (oTechU.RefreshView())
|
{
|
if (oTechU.GetInfoByID(oTechU.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HTechParamUnitIDCol].Value = oTechU.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HTechParamUnitNumberCol].Value = oTechU.omodel.HNumber;
|
grdMain.Rows[i].Cells[HTechParamUnitNameCol].Value = oTechU.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HTechParamUnitIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HTechParamUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HTechParamUnitNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HTechParamUnitIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HTechParamUnitNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HTechParamUnitNameCol].Value = "";
|
}
|
}
|
#endregion
|
}
|
}
|
