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));
}
