internal DataTable LoadAllItem(eSqlOperator sqlOperator, string[] ItemTypes, NZString strDealing , DataDefine.eDealingType argDealingType) { ItemBIZ biz = new ItemBIZ(); return(biz.LoadAllItemWithItemType(sqlOperator, ItemTypes, strDealing, argDealingType)); }
public ItemFindDialog(eSqlOperator sqlOperator, eItemType[] eItemTypes, NZString argDealingCode, DataDefine.eDealingType argDealingType) : this(sqlOperator, eItemTypes) { m_DealingType = argDealingType; if (argDealingCode != null && !argDealingCode.IsNull) { this.m_DealingCode = argDealingCode; } else { this.m_DealingCode = new NZString(null, ""); } }
public static ItemFindDialog ShowDialogWithOperator(IWin32Window window, eSqlOperator sqlOperator, eItemType[] eItemTypes, NZString argDealingCode, DataDefine.eDealingType argDealingType) { ItemFindDialog dialog = new ItemFindDialog(sqlOperator, eItemTypes, argDealingCode, argDealingType); dialog.m_loadType = eLoadType.WithOperator; dialog.ShowDialog(window); return(dialog); }
public static ItemFindDialog ShowDialogWithOperator(eSqlOperator sqlOperator, eItemType[] eItemTypes, NZString argDealingCode, DataDefine.eDealingType argDealingType) { return(ShowDialogWithOperator(null, sqlOperator, eItemTypes, argDealingCode, argDealingType)); }
public DataTable LoadAllItemWithItemType(eSqlOperator sqlOperator, string[] ItemTypes, NZString strDealing, DataDefine.eDealingType argDealingType) { ItemDAO dao = new ItemDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadAllItemWithItemType(null, sqlOperator, ItemTypes, strDealing, argDealingType)); }
public DataTable LoadAllItemWithItemType(Database database, eSqlOperator sqlOperator, string[] ItemTypes, NZString strDealing, DataDefine.eDealingType argDealingType) { Database db = UseDatabase(database); string sql = @"SELECT T.*, DL.LOC_DESC FROM TB_ITEM_MS T LEFT JOIN TB_DEALING_MS DL ON T.CUSTOMER_CD = DL.LOC_CD"; DataRequest req = new DataRequest(); if (strDealing != null && !"".Equals(strDealing.NVL(""))) { sql += " WHERE T.CUSTOMER_CD = @CUSTOMER_CD"; req.Parameters.Add("@CUSTOMER_CD", strDealing.Value); } sql += " ORDER BY T.ITEM_CD"; req.CommandText = sql; return(db.ExecuteQuery(req)); }