/// <summary> /// 初始化数据字典 /// </summary> /// <param name="lkp">LookUp控件</param> /// <param name="sdictcategoryno">数据编号</param> public static void InitLkpDataDict(BWS.ERP.Controls.BWSLookUp lkp, string sdictcategoryno) { string sText = BWS.ERP.DataAccess.DbHelperSQL.GetSingle("SELECT sDictCategoryCName FROM basDataDictMaster WHERE sDictCategoryNo='" + sdictcategoryno + "'").ToString(); InitLookUpBase(lkp, "SELECT sDictDataNo,sDictDataCName,sDictDataEName,sRemark FROM vwbasDataDictDetail WHERE bIsStop=0 AND sDictCategoryNo='" + sdictcategoryno + "'", "sDictDataNo", "sDictDataCName", "sDictDataNo,sDictDataCName,sDictDataEName,sRemark", "编号,中文名称,英文名称,备注/说明", sText); }
/// <summary> /// 从库存中选择商品 /// </summary> /// <param name="lkp"></param> public static void InitLkpGoodInfoFromStock(BWS.ERP.Controls.BWSLookUp lkp) { string sSql = "SELECT sGoodID,sSpec,fBasePrice,fSalePrice,fQuantity,sGoodCName,sGoodEName,sGoodTypeID, " + "sUnitID,sShopID,sGoodTypeName,sShopCName,sUnitName " + "FROM vwstkGoodStkInfoView "; InitLookUpBase(lkp, sSql, "sGoodID", "sGoodID", "sGoodID,sGoodCName,sGoodEName,sSpec,sUnitName", "商品编号,商品名称,英文名称,规格,单位", "商品信息"); }
/// <summary> /// 初始化LookUp控件 /// </summary> /// <param name="lkp">LookUp控件</param> /// <param name="sql">查询SQL</param> /// <param name="returnfield">返回字段</param> /// <param name="displayfield">显示字段</param> /// <param name="columnfield">查询窗口Grid显示列</param> /// <param name="columntetx">查询窗口Grid列显示名称</param> /// <param name="text">查询窗体标题</param> public static void InitLookUpBase(BWS.ERP.Controls.BWSLookUp lkp, string sql, string returnfield, string displayfield, string columnfield, string columntetx, string text) { lkp.SearchFormText = text; lkp.SQL = sql; lkp.DataField = returnfield; lkp.DisplayField = displayfield; lkp.GridDisplayField = columnfield; lkp.GridColumnText = columntetx; }
/// <summary> /// 选择单据 /// </summary> /// <param name="lkp">LookUp控件</param> public static void InitLkpFormID(BWS.ERP.Controls.BWSLookUp lkp) { InitLookUpBase(lkp, "SELECT TOP 100 PERCENT iFormID,sMenuName FROM sysMenu WHERE iFormID<>0 ORDER BY iSort", "iFormID", "sMenuName", "iFormID,sMenuName", "FormID,模块名称", "单据"); }
/// <summary> /// 选择币别 /// </summary> /// <param name="lkp">LookUp控件</param> public static void InitLkpCurrency(BWS.ERP.Controls.BWSLookUp lkp) { InitLookUpBase(lkp, "SELECT sCurrencyID,sCurrencyCName,fExchangeRate,sRemark FROM basCurrency", "sCurrencyID", "sCurrencyCName", "sCurrencyID,sCurrencyCName,fExchangeRate,sRemark", "编号,币别名称,英文名称,汇率,备注", "币别"); }
/// <summary> ///初始用户部门查询 /// </summary> /// <param name="lkp">LookUp控件</param> public static void InitLkpDept(BWS.ERP.Controls.BWSLookUp lkp) { InitLookUpBase(lkp, "SELECT ID,sDeptNo, sDeptName, sDeptEName, sRemark FROM hrDepartment", "ID", "sDeptName", "sDeptNo,sDeptName,sDeptEName,sRemark", "部门编号,中文名称,英文名称,备注", "部门信息"); }
/// <summary> ///初始化员工查询 /// </summary> /// <param name="lkp">LookUp控件</param> /// <param name="sReturnField">设置返回字段</param> public static void InitLkpSystemUser(BWS.ERP.Controls.BWSLookUp lkp, string sReturnField) { InitLookUpBase(lkp, "SELECT ID,sUserID,sUserCName,sUserEName,sDeptNo,sDeptName,sRemark FROM vwsysUser WHERE bIsLock=0", sReturnField, "sUserCName", "sUserID,sUserCName,sUserEName,sDeptName,sRemark", "用户编号,中文名,英文名,部门,备注", "员工信息"); }
/// <summary> /// 选择单据状态 /// </summary> /// <param name="lkp"></param> public static void InitLkpFlag(BWS.ERP.Controls.BWSLookUp lkp) { InitLookUpBase(lkp, "SELECT ID,iFlag,sFlagName FROM basBillState", "iFlag", "sFlagName", "iFlag,sFlagName", "状态值,状态", "单据状态"); }
/// <summary> /// 选择商品信息 /// </summary> /// <param name="lkp"></param> public static void InitLkpGoodInfo(BWS.ERP.Controls.BWSLookUp lkp) { InitLookUpBase(lkp, "SELECT ID,sGoodID,sGoodCName,sGoodEName,sGoodTypeID,sUnitID,sShopID,sGoodTypeName,sUnitCName,sShopCName,ISNULL(fBasePrice,0) AS fBasePrice,ISNULL(fSalePrice,0) AS fSalePrice,dPriceDate FROM vwsalGoodInfoMasterView", "sGoodID", "sGoodCName", "sGoodID,sGoodCName,sGoodEName,sGoodTypeName,sUnitCName,sShopCName,fBasePrice,fSalePrice,dPriceDate", "商品编号,商品名称,英文名称,商品类型,单位,所属门店,进价,销售价,价格日期", "商品信息"); }
/// <summary> /// 选择供应商 /// </summary> /// <param name="lkp">LookUp控件</param> /// <param name="sReturnField">设置返回字段</param> public static void InitLkpSupplier(BWS.ERP.Controls.BWSLookUp lkp, string sReturnField) { InitLookUpBase(lkp, "SELECT ID,sSupplierID,sSupplierSName,sSupplierCName,sSupplierEName,sSupplierTypeName FROM vwbasSupplierMaster", sReturnField, "sSupplierSName", "sSupplierID,sSupplierSName,sSupplierCName,sSupplierEName,sSupplierTypeName", "供应商编号,供应商简称,供应商名称,英文名称,供应商类型", "供应商"); }
/// <summary> /// 选择门店信息 /// </summary> /// <param name="lkp">LookUp控件</param> public static void InitLkpShopID(BWS.ERP.Controls.BWSLookUp lkp) { InitLookUpBase(lkp, "SELECT sShopID,sShopCName,sShopEName,sRemark FROM hrCompanyShopInfo", "sShopID", "sShopCName", "sShopID,sShopCName,sShopEName,sRemark", "门店编号,门店名称,英文名称,备注", "门店"); }