public static List <OrderModifi> SearchSalesOrder(string ItemCategoryCode, string Code) { string strSQL = string.Empty; List <OrderModifi> list = new List <OrderModifi>(); SqlDataReader reader; strSQL = "SP_WA_SalesOrderSearchForInternal"; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand(strSQL); try { db.AddInParameter(dbCommand, "@ItemCategoryCode", DbType.String, ItemCategoryCode); db.AddInParameter(dbCommand, "@OrderNo", DbType.String, Code); reader = (SqlDataReader)db.ExecuteReader(dbCommand); if (reader.HasRows) { while (reader.Read()) { OrderModifi obj = new OrderModifi(); obj.OrderNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("OrderNo"))); obj.Amount = Math.Round(Convert.ToDouble(reader.GetValue(reader.GetOrdinal("Amount")))); obj.PostingDate = Convert.ToString(reader.GetValue(reader.GetOrdinal("PostingDate"))); obj.BlanketOrderNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("BlanketOrderNo"))); list.Add(obj); } } if (!reader.IsClosed) { reader.Close(); } } catch (SqlException e) { throw e; } catch (Exception e) { throw e; } finally { dbCommand.Dispose(); dbCommand = null; db = null; } return(list); }
public static List <OrderModifi> InternalListApprover() { string strSQL = string.Empty; List <OrderModifi> list = new List <OrderModifi>(); SqlDataReader reader; strSQL = "SP_WA_OrderModificationInternalHistory_Approver"; Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand(strSQL); try { reader = (SqlDataReader)db.ExecuteReader(dbCommand); if (reader.HasRows) { while (reader.Read()) { OrderModifi obj = new OrderModifi(); obj.OrderNo = Convert.ToString(reader.GetValue(reader.GetOrdinal("OrderNo"))); list.Add(obj); } } if (!reader.IsClosed) { reader.Close(); } } catch (SqlException e) { throw e; } catch (Exception e) { throw e; } finally { dbCommand.Dispose(); dbCommand = null; db = null; } return(list); }