1456 lines
48 KiB
C#
1456 lines
48 KiB
C#
using System;
|
||
using System.Collections.Generic;
|
||
using System.ComponentModel;
|
||
using System.Drawing;
|
||
using System.Data;
|
||
using System.Linq;
|
||
using System.Windows.Forms;
|
||
|
||
namespace WMS.Ctrl
|
||
{
|
||
/// <summary>
|
||
/// 字典控件的设置
|
||
/// </summary>
|
||
[ToolboxBitmap(typeof(CtrlDictonary), @"CtrlDictonary.png")]
|
||
|
||
public partial class CtrlDictonary : UserControl
|
||
{
|
||
|
||
/// <summary>
|
||
/// 定义一个委托
|
||
/// </summary>
|
||
/// <param name="nameTable"></param>
|
||
public delegate void TableNameColumn(string nameTable);
|
||
|
||
/// <summary>
|
||
/// 执行弹出窗体查询以前执行的事件
|
||
/// </summary>
|
||
public event KeyDownPress DownKeyPressCt;
|
||
/// <summary>
|
||
/// 定义一个委托
|
||
/// </summary>
|
||
/// <param name="nameTable"></param>
|
||
public delegate bool KeyDownPress();
|
||
/// <summary>
|
||
/// 自定义事件
|
||
/// </summary>
|
||
public event TableNameColumn TableColumn;
|
||
/// <summary>
|
||
/// 按钮事件控件事件
|
||
/// </summary>
|
||
public event EventHandler Button_Click;
|
||
/// <summary>
|
||
/// textbox的值
|
||
/// </summary>
|
||
public string TextBoxValue
|
||
{
|
||
get
|
||
{
|
||
return t_dictonary.Text.Trim();
|
||
}
|
||
set
|
||
{
|
||
t_dictonary.Text = value;
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// index列
|
||
/// </summary>
|
||
string txtKeyWordCloum = string.Empty;
|
||
/// <summary>
|
||
/// 查询SQL
|
||
/// </summary>
|
||
public string selSql="";
|
||
/// <summary>
|
||
/// textbox的标记
|
||
/// </summary>
|
||
public string TextBoxFlag
|
||
{
|
||
get
|
||
{
|
||
if (t_dictonary.Tag != null && !string.IsNullOrEmpty(t_dictonary.Tag.ToString()))
|
||
{
|
||
return t_dictonary.Tag.ToString();
|
||
}
|
||
else
|
||
{
|
||
return string.Empty;
|
||
}
|
||
}
|
||
set
|
||
{
|
||
t_dictonary.Tag = value;
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 是否用where条件
|
||
/// </summary>
|
||
public bool IsSqlWhere
|
||
{
|
||
get;
|
||
set;
|
||
}
|
||
/// <summary>
|
||
/// where条件 判断他长度是否大于0 大于0时 用and拼接 等于0时 加where
|
||
/// </summary>
|
||
public string SqlStr
|
||
{
|
||
get;
|
||
set;
|
||
}
|
||
|
||
public CtrlDictonary()
|
||
{
|
||
|
||
InitializeComponent();
|
||
this.TableColumn += new TableNameColumn(ColumnChange);
|
||
|
||
}
|
||
|
||
|
||
/// <summary>
|
||
/// 事件执行的方法
|
||
/// </summary>
|
||
/// <param name="nameTable"></param>
|
||
public void ColumnChange(string nameTable)
|
||
{
|
||
if (oldname == nameTable)
|
||
{
|
||
return;
|
||
|
||
}
|
||
else
|
||
{
|
||
_ComplexItems.Clear();
|
||
Invalidate();
|
||
}
|
||
|
||
oldname = nameTable;
|
||
|
||
if (nameTable == "运力资料t_base_capacity")
|
||
{
|
||
#region 运力资料
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "CAR_ID";
|
||
item.NameCaption = "车牌号";
|
||
item.SelectCmn = true;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CAR_TYPE";
|
||
item.NameCaption = "类型";
|
||
item.TextBoxVal = true;
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
|
||
selSql = string.Format(@"select CAR_ID,CAR_TYPE
|
||
from t_base_capacity
|
||
where STATUS='1' order by CAR_ID");
|
||
#endregion
|
||
return;
|
||
}
|
||
|
||
if (nameTable == "入库通知单t_rk_ware_notice")
|
||
{
|
||
#region 入库通知单编号
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "WAREHOUSING_ID";
|
||
item.NameCaption = "入库通知单编号";
|
||
item.SelectCmn = true;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PROVIDER_NAME";
|
||
item.NameCaption = "供应商名称";
|
||
item.TextBoxVal = true;
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "RECIPIENTS";
|
||
item.NameCaption = "收货人";
|
||
item.TextBoxVal = true;
|
||
item.SelectCmn = false;
|
||
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "ORDER_DATE";
|
||
item.NameCaption = "下单日期";
|
||
item.TextBoxVal = true;
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "STORAGE_MODE";
|
||
item.NameCaption = "入库类型";
|
||
item.TextBoxVal = true;
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
#endregion
|
||
return;
|
||
}
|
||
|
||
if (nameTable == "供应商t_BASE_PROVIDER_DICTIONARY")
|
||
{
|
||
#region 供应商
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "PROVIDER_ID";
|
||
item.NameCaption = "供应商编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PROVIDER_NAME";
|
||
item.NameCaption = "供应商名称";
|
||
item.TextBoxVal = true;
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
return;
|
||
}
|
||
if (nameTable == "采购单t_pur_purchaseInfo")
|
||
{
|
||
#region 采购单
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "PurchaseID";
|
||
item.NameCaption = "采购单编号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "ProviderName";
|
||
item.NameCaption = "供应商";
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PurchaseDate";
|
||
item.NameCaption = "采购日期";
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PurchaseMoney";
|
||
item.NameCaption = "采购金额";
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "ExpectedDeliveryDate";
|
||
item.NameCaption = "预计到货日期";
|
||
item.SelectCmn = false;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
return;
|
||
}
|
||
|
||
if (nameTable == "仓库信息t_BASE_STORAGEINFO")
|
||
{
|
||
#region 仓库信息
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "STORAGE_ID";
|
||
item.NameCaption = "仓库编号";
|
||
item.SelectCmn = true;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "storage_name";
|
||
item.NameCaption = "仓库名称";
|
||
item.SelectCmn = true;
|
||
item.IndexVal = false;
|
||
_ComplexItems.Add(item);
|
||
|
||
#endregion
|
||
|
||
|
||
return;
|
||
}
|
||
if (nameTable == "商品分类t_Base_Goods_Type")
|
||
{
|
||
#region 商品类别
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "GOODS_TYPE_ID";
|
||
item.NameCaption = "商品分类编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "GOODS_TYPE_NAME";
|
||
item.NameCaption = "商品分类名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PARENT_ID";
|
||
item.NameCaption = "父分类编号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
return;
|
||
}
|
||
if (nameTable == "人员信息t_Base_UserInfo")
|
||
{
|
||
#region 人员信息
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "User_ID";
|
||
item.NameCaption = "用户编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "Name";
|
||
item.NameCaption = "用户名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PHONE";
|
||
item.NameCaption = "电话";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
return;
|
||
}
|
||
|
||
if (nameTable == "部门信息t_Sys_Department")
|
||
{
|
||
#region 部门信息
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "DepartmentID";
|
||
item.NameCaption = "组织编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "DepartmentName";
|
||
item.NameCaption = "组织名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
return;
|
||
}
|
||
|
||
if (nameTable == "商品资料t_Base_Goods")
|
||
{
|
||
#region 商品资料
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "Goods_ID";
|
||
item.NameCaption = "物料编码";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
item.TextBoxVal = false;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "Goods_Name";
|
||
item.NameCaption = "物料名称";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "Goods_TYPE_ID";
|
||
item.NameCaption = "物料分类编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = false;
|
||
item.TextBoxVal = false;
|
||
_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "GOODS_SHORT_NAME";
|
||
//item.NameCaption = "商品简称";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "PY_NAME";
|
||
//item.NameCaption = "助记码";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "GOODS_TYPE_ID";
|
||
//item.NameCaption = "商品分类编号";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "SPECIFICATION";
|
||
//item.NameCaption = "规格";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "MODEL";
|
||
//item.NameCaption = "型号";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PRICE";
|
||
item.NameCaption = "单价";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "BARCODE";
|
||
//item.NameCaption = "BarCode";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "GLENGTH";
|
||
//item.NameCaption = "长";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "GWIDTH";
|
||
//item.NameCaption = "宽";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "GHEIGHT";
|
||
//item.NameCaption = "高";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "GVOLUME";
|
||
item.NameCaption = "体积";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "SCALE_UNIT";
|
||
item.NameCaption = "商品重量UNIT";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "UNIT";
|
||
item.NameCaption = "商品UNIT";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "WARN_UP";
|
||
//item.NameCaption = "库存上限";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "WARN_DOWN";
|
||
//item.NameCaption = "库存下限";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "PRODUCE_AREA";
|
||
//item.NameCaption = "产地";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "GROSS_WEIGHT";
|
||
item.NameCaption = "毛重";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "NET_WEIGHT";
|
||
item.NameCaption = "净重";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "PROVIDER_NAME";
|
||
//item.NameCaption = "供应商名称";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PROVIDER_ID";
|
||
item.NameCaption = "供应商编号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "HSNUMBER";
|
||
//item.NameCaption = "海关编码";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "ABC";
|
||
//item.NameCaption = "ABC分类";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "HAZARDOUS";
|
||
//item.NameCaption = "危险品";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "STORED";
|
||
//item.NameCaption = "存储条件 ";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "PERIOD";
|
||
//item.NameCaption = "保质期";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "PERIODUNIT";
|
||
//item.NameCaption = "保质期UNIT";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "ADDTAX";
|
||
//item.NameCaption = "增值税";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "SEASON";
|
||
//item.NameCaption = "季节";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "TARIFFRATE";
|
||
//item.NameCaption = "关税税率";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "REMARK";
|
||
//item.NameCaption = "备注";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "STATUS";
|
||
//item.NameCaption = "Status";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "VERSION";
|
||
//item.NameCaption = "版本";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
#endregion
|
||
return;
|
||
}
|
||
|
||
if (nameTable == "功能表T_BASE_FUNCTIONINFO")
|
||
{
|
||
#region 功能表
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "FUN_ID";
|
||
item.NameCaption = "功能编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = false;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "FUN_NAME";
|
||
item.NameCaption = "功能名称";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = false;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "FUN_NAME";
|
||
item.NameCaption = "功能描述";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = false;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "FUN_NAME";
|
||
item.NameCaption = "功能描述";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = false;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "FUN_IMAGE";
|
||
item.NameCaption = "图片地址";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = false;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
}
|
||
if (nameTable == "容器资料t_BASE_PALLET")
|
||
{
|
||
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "PALLET_ID";
|
||
item.NameCaption = "容器编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "";
|
||
//item.NameCaption = "Pallet Name";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
return;
|
||
}
|
||
|
||
if (nameTable == "到货录入t_RK_RECEIVING")
|
||
{
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "RECE_ID";
|
||
item.NameCaption = "入库单号";
|
||
item.SelectCmn = false;
|
||
//item.IndexVal = true;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "NOTICE_ID";
|
||
item.NameCaption = "通知单号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PROVIDER_NAME";
|
||
item.NameCaption = "供应商";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
return;
|
||
}
|
||
|
||
if (nameTable == "收货验收t_RK_ACCEPTANCE")
|
||
{
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "ACCE_ID";
|
||
item.NameCaption = "验收单号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "LOT_ID";
|
||
item.NameCaption = "入库批次号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "acc_status";
|
||
item.NameCaption = "验收Status";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "operatedate";
|
||
item.NameCaption = "录入时间";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
}
|
||
if (nameTable == "库位t_BASE_STORAGE_AREA_LOCATION")
|
||
{
|
||
#region 库位信息
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "LOCATION_ID";
|
||
item.NameCaption = "库位编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "STORAGE_AREA_ID";
|
||
//item.NameCaption = "库区编号";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "VOLUME";
|
||
//item.NameCaption = "容积";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
//item = new ColumnsItem();
|
||
//item.NameCmn = "HASVOLUME";
|
||
//item.NameCaption = "已占用容积";
|
||
//item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
//_ComplexItems.Add(item);
|
||
|
||
#endregion
|
||
}
|
||
|
||
if (nameTable == "盘点单t_STOCK_COUNTING")
|
||
{
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "COUNT_ID";
|
||
item.NameCaption = "盘点单号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
}
|
||
|
||
if (nameTable == "供应商补货单t_STOCK_PROREP")
|
||
{
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "PROREP_ID";
|
||
item.NameCaption = "供应商补货单据";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
}
|
||
|
||
if (nameTable == "仓库调拨单t_STOCK_STOREP")
|
||
{
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "STOREP_ID";
|
||
item.NameCaption = "仓库调拨单据";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
}
|
||
|
||
if (nameTable == "地址区域t_BASE_ADDRESSAREA")
|
||
{
|
||
#region 地址区域表
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "Add_id";
|
||
item.NameCaption = "地址编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "Add_name";
|
||
item.NameCaption = "地址名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "LEV";
|
||
item.NameCaption = "层级";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "Add_Pid";
|
||
item.NameCaption = "父编号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
}
|
||
|
||
if (nameTable == "库区t_Base_Storage_Area")
|
||
{
|
||
#region 库区表
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "STORAGE_AREA_ID";
|
||
item.NameCaption = "库区编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "STORAGE_AREA_NAME";
|
||
item.NameCaption = "库区名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "STORAGE_ID";
|
||
item.NameCaption = "仓库编号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
IsSqlWhere = true;
|
||
SqlStr = "where storage_id is not null order by storage_id,sort";
|
||
#endregion
|
||
}
|
||
|
||
if (nameTable == "客户资料t_CUS_CUSTOMER")
|
||
{
|
||
#region 客户资料表
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "CUSTOMER_ID";
|
||
item.NameCaption = "客户编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CUSTOMER_NAME";
|
||
item.NameCaption = "客户名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "Telephone";
|
||
item.NameCaption = "手机号";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
}
|
||
if (nameTable == "班组人员t_SYS_TEAMUSER")
|
||
{
|
||
#region 班组人员
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "TEAM_NAME";
|
||
item.NameCaption = "班组";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "USER_ID";
|
||
item.NameCaption = "人员编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "NAME";
|
||
item.NameCaption = "人员名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
}
|
||
if (nameTable == "班组信息t_SYS_TEAM")
|
||
{
|
||
#region 班组信息表
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "TEAM_ID";
|
||
item.NameCaption = "班组编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "TEAM_NAME";
|
||
item.NameCaption = "班组名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
}
|
||
if (nameTable == "部门t_BASE_COMPANY")
|
||
{
|
||
#region 班组信息表
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "COM_ID";
|
||
item.NameCaption = "部门编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "COM_NAME";
|
||
item.NameCaption = "部门名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
}
|
||
if (nameTable == "工种t_sys_dictionary_tabworkkind_type")
|
||
{
|
||
#region 班组信息表
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "VC_CHAR_VALUE";
|
||
item.NameCaption = "工种编号";
|
||
item.SelectCmn = true;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "VC_DICTIONARY_NAME";
|
||
item.NameCaption = "工种";
|
||
item.SelectCmn = true;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
#endregion
|
||
}
|
||
|
||
if (nameTable == "计划t_sc_process_plan")
|
||
{
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "PLAN_ID";
|
||
item.NameCaption = "计划编号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PLAN_NAME";
|
||
item.NameCaption = "计划名称";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "plan_userid";
|
||
item.NameCaption = "发起人";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "plan_description";
|
||
item.NameCaption = "计划描述";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "plan_createtime";
|
||
item.NameCaption = "发起时间";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "storage_id";
|
||
item.NameCaption = "生产仓库";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
}
|
||
if (nameTable == "车辆t_BASE_CAPACITY")
|
||
{
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "CAR_ID";
|
||
item.NameCaption = "车牌号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CAR_DEPARTMENT";
|
||
item.NameCaption = "所属部门";
|
||
item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CAR_DRIVER";
|
||
item.NameCaption = "主要驾驶员";
|
||
item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CAR_TYPE";
|
||
item.NameCaption = "运力类型";
|
||
item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CAR_PRIVATEID";
|
||
item.NameCaption = "自车编号";
|
||
item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CAR_DISPART";
|
||
item.NameCaption = "调度Status";
|
||
item.SelectCmn = false;
|
||
//item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
IsSqlWhere = true;
|
||
SqlStr = "where STATUS = '1' and CAR_DISPART = '0' ";
|
||
}
|
||
|
||
|
||
if (nameTable == "出库通知单t_ck_orders")
|
||
{
|
||
ColumnsItem item = new ColumnsItem();
|
||
item.NameCmn = "ORDER_ID";
|
||
item.NameCaption = "出库单号";
|
||
item.SelectCmn = false;
|
||
item.IndexVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CUSTOMERADDRESS";
|
||
item.NameCaption = "收货人地址";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "PACKINGWEITH";
|
||
item.NameCaption = "包裹重量";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CUSTOMERPROVINCE";
|
||
item.NameCaption = "收货人所在省";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CUSTOMERCITY";
|
||
item.NameCaption = "收货人所在市";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
item = new ColumnsItem();
|
||
item.NameCmn = "CUSTOMERDISTRICT";
|
||
item.NameCaption = "收货人所在区";
|
||
item.SelectCmn = false;
|
||
item.TextBoxVal = true;
|
||
_ComplexItems.Add(item);
|
||
|
||
IsSqlWhere = true;
|
||
SqlStr = "where STATUS = '4' ";
|
||
}
|
||
}
|
||
private string errText = "无数据重新查询";
|
||
/// <summary>
|
||
///
|
||
/// </summary>
|
||
|
||
[Description("错误提示")]
|
||
[EditorBrowsable(EditorBrowsableState.Always)]
|
||
[Localizable(true)]
|
||
[Browsable(true)]
|
||
public string ErrText
|
||
{
|
||
get { return errText; }
|
||
set { errText=value; }
|
||
}
|
||
/// <summary>
|
||
///
|
||
/// </summary>
|
||
|
||
[Description("字典选择类型radioSelect单选MultiSelect多选")]
|
||
[EditorBrowsable(EditorBrowsableState.Always)]
|
||
[Localizable(true)]
|
||
[Browsable(true)]
|
||
public DataSlectType SelectType
|
||
{
|
||
get;
|
||
set;
|
||
}
|
||
private string oldname = string.Empty;
|
||
private DictonaryType dictyName = DictonaryType.选择;
|
||
[Description("字典表的表名")]
|
||
[EditorBrowsable(EditorBrowsableState.Always)]
|
||
[Localizable(true)]
|
||
[Browsable(true)]
|
||
|
||
public DictonaryType DictonaryTableName
|
||
{
|
||
get
|
||
{
|
||
return dictyName;
|
||
}
|
||
set
|
||
{
|
||
oldname = dictyName.ToString();
|
||
dictyName = value;
|
||
TableColumn(dictyName.ToString());
|
||
|
||
}
|
||
}
|
||
|
||
|
||
/// <summary>
|
||
///列的选择
|
||
///1）需要自定义类型
|
||
///2）自定类型的集合
|
||
///3）集合编辑器
|
||
/// </summary>
|
||
private ComplexItems _ComplexItems = new ComplexItems();
|
||
[DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
|
||
[Browsable(true)]
|
||
[Description("表的列名")]
|
||
[Editor(typeof(ComplexItemCollectionEditor), typeof(System.Drawing.Design.UITypeEditor))]
|
||
public ComplexItems ShowColumns
|
||
{
|
||
get
|
||
{
|
||
return _ComplexItems;
|
||
}
|
||
set
|
||
{
|
||
_ComplexItems = value;
|
||
Invalidate();
|
||
}
|
||
|
||
}
|
||
|
||
|
||
[DesignerSerializationVisibility(DesignerSerializationVisibility.Visible)]
|
||
private List<ColumnsItem> userColumns = new List<ColumnsItem>();
|
||
[Localizable(true)]
|
||
[MergableProperty(false)]
|
||
[Description("表的列名")]
|
||
public List<ColumnsItem> UserColumns
|
||
{
|
||
get
|
||
{
|
||
return userColumns;
|
||
}
|
||
|
||
}
|
||
|
||
|
||
public DataTable SelectTable = new DataTable();
|
||
public void SelectDataTable()
|
||
{
|
||
|
||
if (DownKeyPressCt != null)
|
||
{
|
||
|
||
if (DownKeyPressCt())
|
||
{
|
||
return;
|
||
}
|
||
}
|
||
LoadForm load = new LoadForm();
|
||
DevExpress.XtraSplashScreen.SplashScreenManager.ShowForm(load, load.GetType(), false, true, false);
|
||
FormDictonary frmDty = new FormDictonary(ShowColumns, UserColumns, DictonaryTableName, SelectType, t_dictonary.Text.Trim(), IsSqlWhere, SqlStr, selSql);
|
||
if (frmDty.tableDictonary != null)
|
||
{
|
||
if (frmDty.tableDictonary.Rows.Count == 1)
|
||
{
|
||
SelectTable = frmDty.tableDictonary;
|
||
foreach (ColumnsItem clmValue in ShowColumns)
|
||
{
|
||
if (clmValue.TextBoxVal)
|
||
{
|
||
t_dictonary.Text = frmDty.tableDictonary.Rows[0][clmValue.NameCmn.Trim()].ToString();
|
||
}
|
||
if (clmValue.IndexVal)
|
||
{
|
||
t_dictonary.Tag = frmDty.tableDictonary.Rows[0][clmValue.NameCmn.Trim()].ToString();
|
||
txtKeyWordCloum = clmValue.NameCmn;
|
||
}
|
||
}
|
||
|
||
if (this.Button_Click != null)
|
||
{
|
||
this.Button_Click(new object(), new EventArgs());
|
||
}
|
||
DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm();
|
||
return;
|
||
}
|
||
}
|
||
DevExpress.XtraSplashScreen.SplashScreenManager.CloseForm();
|
||
if (!string.IsNullOrEmpty(TextBoxValue))
|
||
{
|
||
frmDty.txtKeyWordtext = TextBoxValue;
|
||
if (string.IsNullOrEmpty(txtKeyWordCloum))
|
||
{
|
||
foreach (ColumnsItem clmValue in ShowColumns)
|
||
{
|
||
if (clmValue.IndexVal)
|
||
{
|
||
txtKeyWordCloum = clmValue.NameCmn;
|
||
}
|
||
}
|
||
}
|
||
}
|
||
frmDty.ErrText = errText;
|
||
DialogResult dia = frmDty.ShowDialog();
|
||
if (dia == DialogResult.OK)
|
||
{
|
||
SelectTable = frmDty.tableSelect;
|
||
if (SelectTable != null)
|
||
{
|
||
if (SelectTable.Rows.Count == 1)
|
||
{
|
||
foreach (ColumnsItem clmValue in ShowColumns)
|
||
{
|
||
if (clmValue.TextBoxVal)
|
||
{
|
||
t_dictonary.Text = SelectTable.Rows[0][clmValue.NameCmn.Trim()].ToString();
|
||
}
|
||
if (clmValue.IndexVal)
|
||
{
|
||
t_dictonary.Tag = SelectTable.Rows[0][clmValue.NameCmn.Trim()].ToString();
|
||
}
|
||
}
|
||
|
||
}
|
||
}
|
||
}
|
||
else
|
||
{
|
||
SelectTable.Rows.Clear();
|
||
}
|
||
if (this.Button_Click != null)
|
||
{
|
||
this.Button_Click(new object(), new EventArgs());
|
||
}
|
||
|
||
}
|
||
/// <summary>
|
||
/// 获取信息编号
|
||
/// </summary>
|
||
public int Number { get; set; }
|
||
|
||
public void CtrlDictonary_KeyDown(object sender, KeyEventArgs e)
|
||
{
|
||
if (e == null || e.KeyData == Keys.Enter)
|
||
{
|
||
SelectDataTable();
|
||
}
|
||
}
|
||
public void t_dictonary_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
|
||
{
|
||
SelectTable.Rows.Clear();
|
||
SelectDataTable();
|
||
t_dictonary.Focus();
|
||
t_dictonary.SelectAll();
|
||
}
|
||
|
||
private void t_dictonary_Leave(object sender, EventArgs e)
|
||
{
|
||
if (t_dictonary.Text.Trim().Length > 0)
|
||
{
|
||
if (t_dictonary.Tag != null)
|
||
{
|
||
return;
|
||
}
|
||
if (SelectTable.Rows.Count == 0)
|
||
{
|
||
SelectDataTable();
|
||
}
|
||
|
||
|
||
}
|
||
else
|
||
{
|
||
t_dictonary.Tag = string.Empty;
|
||
}
|
||
}
|
||
|
||
private void t_dictonary_EditValueChanged(object sender, EventArgs e)
|
||
{
|
||
|
||
}
|
||
}
|
||
|
||
|
||
[Serializable]
|
||
|
||
public class ColumnsItem
|
||
{
|
||
private string nameColumn = string.Empty;
|
||
/// <summary>
|
||
/// 列名称
|
||
/// </summary>
|
||
public string NameCmn
|
||
{
|
||
get
|
||
{
|
||
return nameColumn;
|
||
}
|
||
set
|
||
{
|
||
nameColumn = value;
|
||
}
|
||
}
|
||
private string nameCaption = string.Empty;
|
||
|
||
/// <summary>
|
||
/// Gird显示列名称
|
||
/// </summary>
|
||
public string NameCaption
|
||
{
|
||
get
|
||
{
|
||
return nameCaption;
|
||
}
|
||
set
|
||
{
|
||
nameCaption = value;
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 返回后,textbox用户显示列,呈现于用户
|
||
/// </summary>
|
||
private bool textBoxVal = false;
|
||
[Description("返回后,textbox用户显示列")]
|
||
[Browsable(true)]
|
||
public bool TextBoxVal
|
||
{
|
||
get
|
||
{
|
||
return textBoxVal;
|
||
}
|
||
set
|
||
{
|
||
textBoxVal = value;
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 返回后,隐藏显示字段，主键
|
||
/// </summary>
|
||
private bool indexVal = false;
|
||
[Description("返回后,隐藏显示字段，主键")]
|
||
[Browsable(true)]
|
||
public bool IndexVal
|
||
{
|
||
get
|
||
{
|
||
return indexVal;
|
||
}
|
||
set
|
||
{
|
||
indexVal = value;
|
||
}
|
||
}
|
||
/// <summary>
|
||
/// 是否查询条件列
|
||
/// </summary>
|
||
private bool select = false;
|
||
/// <summary>
|
||
/// 是否查询条件列
|
||
/// </summary>
|
||
[Description("是否选择列，默认为选择列")]
|
||
[Browsable(true)]
|
||
public bool SelectCmn
|
||
{
|
||
get
|
||
{
|
||
return select;
|
||
}
|
||
set
|
||
{
|
||
select = value;
|
||
}
|
||
}
|
||
|
||
private bool dispalyCmn = true;
|
||
|
||
/// <summary>
|
||
/// Grid显示列
|
||
/// </summary>
|
||
[Description("Grid显示列")]
|
||
[Browsable(true)]
|
||
|
||
public bool DispalyCmn
|
||
{
|
||
get
|
||
{
|
||
return dispalyCmn;
|
||
}
|
||
set
|
||
{
|
||
dispalyCmn = value;
|
||
}
|
||
}
|
||
}
|
||
public enum DataSlectType
|
||
{
|
||
MultiSelect = 0,
|
||
RadioSelect = 1
|
||
}
|
||
public enum DictonaryType
|
||
{
|
||
|
||
选择 = 0,
|
||
供应商t_BASE_PROVIDER_DICTIONARY = 1,
|
||
会员信息 = 2,
|
||
部门信息t_Sys_Department = 3,
|
||
采购单t_pur_purchaseInfo = 4,
|
||
仓库信息t_BASE_STORAGEINFO = 5,
|
||
人员信息t_Base_UserInfo = 6,
|
||
商品分类t_Base_Goods_Type = 7,
|
||
商品资料t_Base_Goods = 8,
|
||
退货单t_CS_DirectReturnOrderView = 9,
|
||
功能表t_BASE_FUNCTIONINFO = 10,
|
||
容器资料t_BASE_PALLET = 11,
|
||
到货录入t_RK_RECEIVING = 12,
|
||
收货验收t_RK_ACCEPTANCE = 13,
|
||
库位t_BASE_STORAGE_AREA_LOCATION = 14,
|
||
盘点单t_STOCK_COUNTING = 15,
|
||
供应商补货单t_STOCK_PROREP = 16,
|
||
仓库调拨单t_STOCK_STOREP = 17,
|
||
地址区域t_BASE_ADDRESSAREA = 18,
|
||
库区t_Base_Storage_Area = 19,
|
||
入库通知单t_rk_ware_notice = 20,
|
||
客户资料t_CUS_CUSTOMER = 21,
|
||
运力资料t_base_capacity = 22,
|
||
班组人员t_SYS_TEAMUSER = 23,
|
||
班组信息t_SYS_TEAM = 24,
|
||
部门t_BASE_COMPANY = 25,
|
||
工种t_sys_dictionary_tabworkkind_type = 26,
|
||
计划t_sc_process_plan = 27,
|
||
车辆t_BASE_CAPACITY = 28,
|
||
出库通知单t_ck_orders = 29,
|
||
}
|
||
}
|