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) { InitializeComponent(); SelectedItem = new ItemUIDM(); m_sqlOperator = sqlOperator; if (eItemTypes != null && eItemTypes.Length > 0) { if (eItemTypes.Length == 1 && eItemTypes[0] == eItemType.All) { ItemTypes = new string[] { "SHAFT", "SCREW", "WASHER" }; } else { ItemTypes = new string[eItemTypes.Length]; for (int i = 0; i < eItemTypes.Length; i++) { //ItemTypes[i] = string.Format("{0:00}", (int)eItemTypes[i]); ItemTypes[i] = eItemTypes[i].ToString(); } } } }
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(IWin32Window window, eSqlOperator sqlOperator, eItemType[] eItemTypes) { ItemFindDialog dialog = new ItemFindDialog(sqlOperator, eItemTypes); dialog.m_loadType = eLoadType.WithOperator; dialog.ShowDialog(window); return(dialog); }
public ErrorItem CheckNotExistWithItemType(NZString ItemCD, eSqlOperator sqlOperator, string[] itemTypes) { ItemDAO dao = new ItemDAO(CommonLib.Common.CurrentDatabase); if (!dao.ExistWithItemTypes(null, ItemCD, sqlOperator, itemTypes)) { ErrorItem errorItem = new ErrorItem(ItemCD.Owner, TKPMessages.eValidate.VLM0009.ToString()); return(errorItem); } return(null); }
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 DataTable LoadAllItemWithItemType(Database database, eSqlOperator sqlOperator, string[] ItemTypes, NZString strSupplier) { Database db = UseDatabase(database); string sql = @"SELECT T.*, TT.ORDER_LOC_CD, TT.STORE_LOC_CD, TT.ORDER_PROCESS_CLS, TT.ORDER_LOC_CD, TT.STORE_LOC_CD, TT.PACK_SIZE, TT.CONSUMTION_CLS, TT.LOT_SIZE FROM TB_ITEM_MS T INNER JOIN TB_ITEM_PROCESS_MS TT ON T.ITEM_CD = TT.ITEM_CD"; if (ItemTypes != null && ItemTypes.Length > 0) { string strOperator = "IN"; if (sqlOperator == eSqlOperator.NotIn) { strOperator = "NOT IN"; } sql += string.Format(" WHERE t.ITEM_CLS {0} (", strOperator); for (int i = 0; i < ItemTypes.Length; i++) { sql += "'" + ItemTypes[i] + "'"; if (i < ItemTypes.Length - 1) { sql += ", "; } } sql += " )"; } sql += " AND TT.ORDER_LOC_CD = :SUPPLIER_CD"; DataRequest req = new DataRequest(sql); req.Parameters.Add("SUPPLIER_CD", strSupplier.Value); return(db.ExecuteQuery(req)); }
/// <summary> /// Check exists the specified key. /// </summary> public bool ExistWithItemTypes(Database database, NZString ITEM_CD, eSqlOperator sqlOperator, string[] itemTypes) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); sb.AppendLine(" SELECT 1 "); sb.AppendLine(" FROM TB_ITEM_MS "); sb.AppendLine(" WHERE ITEM_CD = :ITEM_CD "); if (itemTypes != null && itemTypes.Length > 0) { string strOperator = "IN"; if (sqlOperator == eSqlOperator.NotIn) { strOperator = "NOT IN"; } sb.AppendLine(string.Format(" AND ITEM_CLS {0} (", strOperator)); for (int i = 0; i < itemTypes.Length; i++) { sb.AppendLine("'" + itemTypes[i] + "'"); if (i < itemTypes.Length - 1) { sb.AppendLine(", "); } } sb.AppendLine(" )"); } DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("ITEM_CD", DataType.NVarChar, ITEM_CD.Value); return(db.ExecuteQuery(req).Rows.Count > 0); }
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)); }
public static ItemFindDialog ShowDialogWithOperator(eSqlOperator sqlOperator, eItemType[] eItemTypes, NZString argDealingCode, DataDefine.eDealingType argDealingType) { return(ShowDialogWithOperator(null, sqlOperator, eItemTypes, argDealingCode, argDealingType)); }
public static ItemFindDialog ShowDialogWithOperator(eSqlOperator sqlOperator, eItemType[] eItemTypes) { return(ShowDialogWithOperator(null, sqlOperator, eItemTypes)); }
internal DataTable LoadAllItem(eSqlOperator sqlOperator, string[] ItemTypes) { ItemBIZ biz = new ItemBIZ(); return(biz.LoadAllItemWithItemType(sqlOperator, ItemTypes)); }
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(eSqlOperator sqlOperator, string[] ItemTypes) { ItemDAO dao = new ItemDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadAllItemWithItemType(null, sqlOperator, ItemTypes)); }
public DataTable LoadAllItemWithItemType(Database database, eSqlOperator sqlOperator, string[] ItemTypes) { Database db = UseDatabase(database); string sql = @"SELECT TIM.* , DL.LOC_DESC " //TIM.ITEM_CD, //TIM.SHORT_NAME, //TIM.ITEM_DESC, //TIM.KIND_OF_PRODUCT, //TIM.CUSTOMER_CD, //TIM.CUSTOMER_USE_POINT, //TIM.WEIGHT, //TIM.BOI, //TIM.PRODUCTION_DI, //TIM.ITEM_LEVEL, //TIM.MAT_NAME, //TIM.MAT_SIZE, //TIM.MAT_SUPPLIER_CD, //TIM.KIND_OF_MAT, //TIM.MAT_DI, //TIM.REMARK, //TIM.CRT_DATE, //TIM.CRT_BY, //TIM.UPD_DATE, //TIM.UPD_BY, //TIM.SCREW_KIND, //TIM.SCREW_HEAD, //TIM.SCREW_M, //TIM.SCREW_L, //TIM.SCREW_TYPE, //TIM.SCREW_REMARK1, //TIM.SCREW_REMARK2, //TIM.HEXABULAR, //--TIMM.MACHINE_PROCESS AS PROCESS1, //--TIMM.MACHINE_TYPE AS MACHINE_TYPE1, //--TIMM.MACHINE_PROCESS AS PROCESS2, //--TIMM.MACHINE_TYPE AS MACHINE_TYPE2, //--TIMM.MACHINE_PROCESS AS PROCESS3, //--TIMM.MACHINE_TYPE AS MACHINE_TYPE3, //--TIMM.MACHINE_PROCESS AS PROCESS4, //--TIMM.MACHINE_TYPE AS MACHINE_TYPE4, //--TIMM.MACHINE_PROCESS AS PROCESS5, //--TIMM.MACHINE_TYPE AS MACHINE_TYPE5, //--TIMM.MACHINE_PROCESS AS PROCESS6, //--TIMM.MACHINE_TYPE AS MACHINE_TYPE6, //TIM.HEAT_FLAG, //TIM.HEAT_TYPE, //TIM.HEAT_HARDNESS, //TIM.HEAT_CORE_HARDNESS, //TIM.HEAT_CASE_DEPTH, //TIM.PLATING_FLAG, //TIM.PLATING_KIND, //TIM.PLATING_SUPPLIER_CD, //TIM.PLATING_THICKNESS1_1, //TIM.PLATING_THICKNESS1_2, //TIM.PLATING_THICKNESS2_1, //TIM.PLATING_THICKNESS2_2, //TIM.PLATING_KTC, //TIM.BAKING_FLAG, //TIM.BAKING_TIME, //TIM.BAKING_TEMP, //TIM.OTHER_TREATMENT1_FLAG, //TIM.OTHER_TREATMENT1_KIND, //TIM.OTHER_TREATMENT1_CONDITION, //TIM.OTHER_TREATMENT2_FLAG, //TIM.OTHER_TREATMENT2_KIND, //TIM.OTHER_TREATMENT2_CONDITION, //TIM.ROUTING_TEXT + " FROM TB_ITEM_MS TIM " + " LEFT JOIN TB_DEALING_MS DL ON TIM.CUSTOMER_CD = DL.LOC_CD"; //LEFT JOIN TB_ITEM_PROCESS_MS TIPM ON TIM.ITEM_CD = TIPM.ITEM_CD //LEFT JOIN TB_ITEM_MACHINE_MS TIMM ON TIPM.ITEM_CD = TIMM.ITEM_CD"; if (ItemTypes != null && ItemTypes.Length > 0) { string strOperator = "IN"; if (sqlOperator == eSqlOperator.NotIn) { strOperator = "NOT IN"; } sql += string.Format(" WHERE TIM.KIND_OF_PRODUCT {0} (", strOperator); for (int i = 0; i < ItemTypes.Length; i++) { sql += "'" + ItemTypes[i] + "'"; if (i < ItemTypes.Length - 1) { sql += ", "; } } sql += " )"; } sql += " ORDER BY TIM.ITEM_CD"; DataRequest req = new DataRequest(sql); return(db.ExecuteQuery(req)); }