public List <VSalesRecord> getListByCustomerID(int PlatformID, string CustomerID)
{
List <VSalesRecord> list = new List <VSalesRecord>();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@PlatformID", SqlDbType.Int), new SqlParameter("@CustomerID", SqlDbType.NVarChar) };
parameters[0].Value = PlatformID;
parameters[1].Value = CustomerID;
SqlDataReader reader = SQLHelper.RunProcedure("p_SalesRecord_getListByCustomerID", parameters);
while (reader.Read())
{
VSalesRecord item = new VSalesRecord();
item.ID = reader.GetInt32(reader.GetOrdinal("ID"));
item.SalesOrderID = reader.GetString(reader.GetOrdinal("SalesOrderID"));
item.PlatformID = reader.GetInt32(reader.GetOrdinal("PlatformID"));
item.CustomerID = reader.GetString(reader.GetOrdinal("CustomerID"));
item.PlatformName = reader.GetString(reader.GetOrdinal("PlatformName"));
item.Description = reader.GetString(reader.GetOrdinal("Description"));
item.UserName = reader.GetString(reader.GetOrdinal("UserName"));
item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
list.Add(item);
}
reader.Close();
return(list);
}
public List <VSalesRecord> getAll()
{
List <VSalesRecord> list = new List <VSalesRecord>();
SqlDataReader reader = SQLHelper.RunProcedure("p_SalesRecord_getAll", null);
while (reader.Read())
{
VSalesRecord item = new VSalesRecord();
item.PlatformID = reader.GetInt32(reader.GetOrdinal("PlatformID"));
item.ID = reader.GetInt32(reader.GetOrdinal("ID"));
item.SalesOrderID = reader.GetString(reader.GetOrdinal("SalesOrderID"));
item.CustomerID = reader.GetString(reader.GetOrdinal("CustomerID"));
item.Description = reader.GetString(reader.GetOrdinal("Description"));
item.PlatformName = reader.GetString(reader.GetOrdinal("PlatformName"));
item.UserName = reader.GetString(reader.GetOrdinal("UserName"));
item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
list.Add(item);
}
reader.Close();
return(list);
}
public VSalesRecord getBySalesOrderID(string SalesOrderID)
{
bool flag = false;
VSalesRecord record = new VSalesRecord();
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesOrderID", SqlDbType.NVarChar) };
parameters[0].Value = SalesOrderID;
SqlDataReader reader = SQLHelper.RunProcedure("p_SalesRecord_getBySalesOrderID", parameters);
if (reader.Read())
{
record.ID = reader.GetInt32(reader.GetOrdinal("ID"));
record.SalesOrderID = reader.GetString(reader.GetOrdinal("SalesOrderID"));
record.PlatformID = reader.GetInt32(reader.GetOrdinal("PlatformID"));
record.CustomerID = reader.GetString(reader.GetOrdinal("CustomerID"));
record.PlatformName = reader.GetString(reader.GetOrdinal("PlatformName"));
record.Description = reader.GetString(reader.GetOrdinal("Description"));
record.UserName = reader.GetString(reader.GetOrdinal("UserName"));
record.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate"));
flag = true;
}
reader.Close();
return(flag ? record : null);
}