using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace BLL
|
{
|
public class ClsBaseSelect_InterFace
|
{
|
|
//结算方式
|
/// <summary>
|
/// 结算方式
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextBySettleStyle(TextBox txt)
|
{
|
DAL.ClsIF_SettleStyle_View oSettleStyle = new DAL.ClsIF_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 SetTextByPoStockStyle(TextBox txt)
|
{
|
DAL.ClsIF_PoStockStyle_View oPoStockStyle = new DAL.ClsIF_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>
|
/// <param name="txtHRate"></param>
|
public static void SetTextByCur(TextBox txt, TextBox txtHRate)
|
{
|
DAL.ClsIF_Currency_View oCur = new DAL.ClsIF_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>
|
//public static void SetTextByProc_ICMO(TextBox txt, long HICMOInterID)
|
//{
|
// //DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
|
// DAL.ClsK3_Process_View oProc = new DAL.ClsK3_Process_View();
|
// if (oProc.RefreshView(" and HItemID in (select HProcID from K3_ICMOBillList_HProcID where hmainid=" + HICMOInterID + ")"))
|
// {
|
// txt.Text = oProc.oModel.HName;
|
// txt.Tag = oProc.oModel.HItemID.ToString();
|
// }
|
// else
|
// {
|
// txt.Text = "";
|
// }
|
//}
|
|
//选择接口类职员-按班组
|
/// <summary>
|
/// 选择接口类职员-按班组
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByEmp_Group(TextBox txt, long HGroupID)
|
{
|
DAL.ClsIF_Employee_View oEmp = new DAL.ClsIF_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="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.ClsIF_Employee_View oEmp = new DAL.ClsIF_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="txt"></param>
|
public static void SetTextBySupplier(TextBox txt)
|
{
|
DAL.ClsIF_Supplier_View oSupplier = new DAL.ClsIF_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, string sWhere)
|
{
|
DAL.ClsIF_Supplier_View oSupplier = new DAL.ClsIF_Supplier_View();
|
if (oSupplier.RefreshView(sWhere))
|
{
|
txt.Text = oSupplier.oModel.HName;
|
txt.Tag = oSupplier.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
|
//选择接口类工序-按任务单
|
/// <summary>
|
/// 选择接口类工序-按任务单
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProc_ICMO(TextBox txt, long HICMOInterID)
|
{
|
DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
|
if (oProc.RefreshView(" and HItemID in (select HProcID from K3_ICMOBillList_HProcID where hmainid=" + HICMOInterID + ")"))
|
{
|
txt.Text = oProc.oModel.HName;
|
txt.Tag = oProc.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//选择接口类客户
|
/// <summary>
|
/// 选择接口类客户
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByCus(TextBox txt)
|
{
|
DAL.ClsIF_Customer_View oCus = new DAL.ClsIF_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 SetTextBySource(TextBox txt)
|
{
|
DAL.ClsIF_Source_View oSource = new DAL.ClsIF_Source_View();
|
if (oSource.RefreshView())
|
{
|
txt.Text = oSource.oModel.HName;
|
txt.Tag = oSource.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//接口类生产资源-网格
|
/// <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.ClsIF_Source_View oSource = new DAL.ClsIF_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="txt"></param>
|
public static void SetTextByDept(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, string sWhere)
|
{
|
DAL.ClsIF_Department_View oDept = new DAL.ClsIF_Department_View();
|
if (oDept.RefreshView(sWhere))
|
{
|
txt.Text = oDept.oModel.HName;
|
txt.Tag = oDept.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//接口类部门-网格
|
/// <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.ClsIF_Department_View oDept = new DAL.ClsIF_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="txt"></param>
|
public static void SetTextByEmp(TextBox txt)
|
{
|
DAL.ClsIF_Employee_View oEmp = new DAL.ClsIF_Employee_View();
|
if (oEmp.RefreshView())
|
{
|
txt.Text = oEmp.oModel.HName;
|
txt.Tag = oEmp.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
//接口类职员-网格
|
/// <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.ClsIF_Employee_View oEmp = new DAL.ClsIF_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="txt"></param>
|
public static void SetTextByProc(TextBox txt)
|
{
|
DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
|
if (oProc.RefreshView())
|
{
|
txt.Text = oProc.oModel.HName;
|
txt.Tag = oProc.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
//选择接口类工序
|
/// <summary>
|
/// 选择接口类工序
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByProc(TextBox txt,TextBox txt2)
|
{
|
DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
|
if (oProc.RefreshView())
|
{
|
txt.Text = oProc.oModel.HNumber;
|
txt.Tag = oProc.oModel.HItemID.ToString();
|
txt2.Text = oProc.oModel.HName;
|
}
|
else
|
{
|
txt.Text = "";
|
txt2.Text = "";
|
}
|
}
|
//接口类工序-网格
|
/// <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.ClsIF_Process_View oProc = new DAL.ClsIF_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="HCusIDCol"></param>
|
/// <param name="HCusNumberCol"></param>
|
/// <param name="HCusNameCol"></param>
|
public static void SetGridByCus(DataGridView grdMain, int i, int HCusIDCol, int HCusNumberCol, int HCusNameCol)
|
{
|
DAL.ClsIF_Customer_View oCus = new DAL.ClsIF_Customer_View();
|
if (oCus.RefreshView())
|
{
|
if (oCus.GetInfoByID(oCus.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HCusIDCol].Value = oCus.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HCusNumberCol].Value = oCus.omodel.HNumber;
|
grdMain.Rows[i].Cells[HCusNameCol].Value = oCus.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCusIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCusNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCusNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HCusIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HCusNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HCusNameCol].Value = "";
|
}
|
}
|
|
|
//选择接口类物料
|
/// <summary>
|
/// 选择接口类物料
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByMater(TextBox txt,bool backNumber)
|
{
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
|
if (oMater.RefreshView())
|
{
|
txt.Text = oMater.omodel.HNumber;
|
txt.Tag = oMater.omodel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//选择接口类物料
|
/// <summary>
|
/// 选择接口类物料
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByMater(TextBox txt)
|
{
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
|
if (oMater.RefreshView())
|
{
|
txt.Text = oMater.omodel.HName;
|
txt.Tag = oMater.omodel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//选择接口类物料
|
/// <summary>
|
/// 选择接口类物料
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByMater(TextBox txt, TextBox txt2, TextBox txt3)
|
{
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
|
if (oMater.RefreshView())
|
{
|
if (oMater.GetInfoByID(oMater.omodel.HItemID))
|
{
|
txt.Text = oMater.omodel.HNumber;
|
txt.Tag = oMater.omodel.HItemID.ToString();
|
txt2.Text = oMater.omodel.HName;
|
txt3.Text = oMater.omodel.HModel;
|
}
|
}
|
else
|
{
|
txt.Text = "";
|
txt2.Text = "";
|
txt3.Text = "";
|
}
|
}
|
|
//选择接口类物料
|
/// <summary>
|
/// 选择接口类物料
|
/// </summary>
|
/// <param name="txtNumber">代码文本框</param>
|
/// <param name="txtName">名称文本框</param>
|
/// <param name="txtModel">规格文本框</param>
|
/// <param name="txtUnit">单位文本框</param>
|
public static void SetTextByMater(TextBox txtNumber, TextBox txtName, TextBox txtModel, TextBox txtUnit)
|
{
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
|
DAL.ClsIF_Unit_View oUnit = new DAL.ClsIF_Unit_View();
|
if (oMater.RefreshView())
|
{
|
if (oMater.GetInfoByID(oMater.omodel.HItemID))
|
{
|
txtNumber.Text = oMater.omodel.HNumber;
|
txtNumber.Tag = oMater.omodel.HItemID.ToString();
|
txtName.Text = oMater.omodel.HName;
|
txtModel.Text = oMater.omodel.HModel;
|
if (oUnit.GetInfoByID(oMater.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="grdMain"></param>
|
/// <param name="i"></param>
|
/// <param name="HMaterIDCol"></param>
|
/// <param name="HMaterNumberCol"></param>
|
/// <param name="HMaterNameCol"></param>
|
public static void SetGridByMater(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol, int HUnitIDCol, int HUnitNumberCol, int HUnitNameCol)
|
{
|
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_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[HUnitIDCol].Value = oMater.omodel.HUnitID;
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value = oMater.omodel.HUnitNumber;
|
grdMain.Rows[i].Cells[HUnitNameCol].Value = oMater.omodel.HUnitName;
|
}
|
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[HUnitIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HUnitNumberCol].Value ="";
|
grdMain.Rows[i].Cells[HUnitNameCol].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 = "";
|
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="HMaterIDCol"></param>
|
/// <param name="HMaterNumberCol"></param>
|
/// <param name="HMaterNameCol"></param>
|
public static void SetGridByMater(DataGridView grdMain, int i, int HMaterIDCol, int HMaterNumberCol, int HMaterNameCol, int HMaterModelCol)
|
{
|
|
DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_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="txt"></param>
|
public static void SetTextByGroup(TextBox txt)
|
{
|
DAL.ClsIF_Group_View oGroup = new DAL.ClsIF_Group_View();
|
if (oGroup.RefreshView())
|
{
|
txt.Text = oGroup.oModel.HName;
|
txt.Tag = oGroup.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
//接口类班组-网格
|
/// <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.ClsIF_Group_View oGroup = new DAL.ClsIF_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="txt"></param>
|
public static void SetTextByUnit(TextBox txt)
|
{
|
DAL.ClsIF_Unit_View oUnit = new DAL.ClsIF_Unit_View();
|
if (oUnit.RefreshView())
|
{
|
txt.Text = oUnit.oModel.HName;
|
txt.Tag = oUnit.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
//接口类计量单位-网格
|
/// <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.ClsIF_Unit_View oUnit = new DAL.ClsIF_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="txt"></param>
|
public static void SetTextByWarehouse(TextBox txt)
|
{
|
DAL.ClsIF_Warehouse_View oWh = new DAL.ClsIF_Warehouse_View();
|
if (oWh.RefreshView())
|
{
|
txt.Text = oWh.oModel.HName;
|
txt.Tag = oWh.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
//选择接口类仓库 递入过滤条件
|
/// <summary>
|
/// 选择接口类仓库 递入过滤条件
|
/// </summary>
|
/// <param name="txt"></param>
|
public static void SetTextByWarehouse(TextBox txt, string sWhere)
|
{
|
DAL.ClsIF_Warehouse_View oWh = new DAL.ClsIF_Warehouse_View();
|
if (oWh.RefreshView(sWhere))
|
{
|
txt.Text = oWh.oModel.HName;
|
txt.Tag = oWh.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//接口类仓库-网格
|
/// <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.ClsIF_Warehouse_View oWh = new DAL.ClsIF_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="txt"></param>
|
public static void SetTextByArea(TextBox txt)
|
{
|
DAL.ClsIF_Area_View oArea = new DAL.ClsIF_Area_View();
|
if (oArea.RefreshView())
|
{
|
txt.Text = oArea.oModel.HName;
|
txt.Tag = oArea.oModel.HItemID.ToString();
|
}
|
else
|
{
|
txt.Text = "";
|
}
|
}
|
|
|
//仓位-网格 根据仓库
|
/// <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.ClsIF_StockPlace_View oStockPlace = new DAL.ClsIF_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.ClsIF_StockPlace_View oSP = new DAL.ClsIF_StockPlace_View();
|
DAL.ClsIF_StockPlaceGroup_View oSPGroup = new DAL.ClsIF_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="HAreaIDCol"></param>
|
/// <param name="HAreaNumberCol"></param>
|
/// <param name="HAreaNameCol"></param>
|
public static void SetGridByArea(DataGridView grdMain, int i, int HAreaIDCol, int HAreaNumberCol, int HAreaNameCol)
|
{
|
|
DAL.ClsIF_Area_View oArea = new DAL.ClsIF_Area_View();
|
if (oArea.RefreshView())
|
{
|
if (oArea.GetInfoByID(oArea.oModel.HItemID))
|
{
|
grdMain.Rows[i].Cells[HAreaIDCol].Value = oArea.omodel.HItemID.ToString();
|
grdMain.Rows[i].Cells[HAreaNumberCol].Value = oArea.omodel.HNumber;
|
grdMain.Rows[i].Cells[HAreaNameCol].Value = oArea.omodel.HName;
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HAreaIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HAreaNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HAreaNameCol].Value = "";
|
}
|
}
|
else
|
{
|
grdMain.Rows[i].Cells[HAreaIDCol].Value = "0";
|
grdMain.Rows[i].Cells[HAreaNumberCol].Value = "";
|
grdMain.Rows[i].Cells[HAreaNameCol].Value = "";
|
}
|
}
|
|
}
|
}
|
