public static List<DTO.MAD_Transportation> Get(string id, string transportationName, int status, bool display)
{
List<DTO.MAD_Transportation> lsArray = new List<DTO.MAD_Transportation>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", id));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationName", transportationName));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", status));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Display", display));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_MAD_Transportation_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.MAD_Transportation(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.SAM_DriverShipment> Get(int shipmentNo_, string transportationNo_, string userNo_)
{
List<DTO.SAM_DriverShipment> lsArray = new List<DTO.SAM_DriverShipment>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ShipmentNo_", shipmentNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@TransportationNo_", transportationNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@UserNo_", userNo_));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_SAM_DriverShipment_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.SAM_DriverShipment(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.FIC_ShippingVolumeHeader> Get(string sSVHeaderNo_, string invoiceNo_, string fromPartnerNo_, string toPartnerNo_, int status)
{
List<DTO.FIC_ShippingVolumeHeader> lsArray = new List<DTO.FIC_ShippingVolumeHeader>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@SVHeaderNo_", sSVHeaderNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@InvoiceNo_", invoiceNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@FromPartnerNo_", fromPartnerNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ToPartnerNo_", toPartnerNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", status));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_FIC_ShippingVolumeHeader_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.FIC_ShippingVolumeHeader(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.SAM_SalesPrice_View> Get(int id, string ContractNo_, string RouteNo_, string ItemNo_, string UnitOfMeasure)
{
List<DTO.SAM_SalesPrice_View> lsArray = new List<DTO.SAM_SalesPrice_View>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ID", id));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractNo_", ContractNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@RouteNo_", RouteNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ItemNo_", ItemNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnitOfMeasure", UnitOfMeasure));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_SAM_SalesPrice_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.SAM_SalesPrice_View(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.MAD_Employee> Get(string id)
{
List<DTO.MAD_Employee> lsArray = new List<DTO.MAD_Employee>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@EmployeeNo_", id));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_MAD_Employee_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.MAD_Employee(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.SYS_User_View> Get(string userNo_)
{
List<DTO.SYS_User_View> lsArray = new List<DTO.SYS_User_View>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@UserNo_", userNo_.Trim()));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_SYS_User_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.SYS_User_View(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static DTO.SYS_User Login(string userNo_, string pasword)
{
DTO.SYS_User item = new DTO.SYS_User();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@UserNo_", userNo_.Trim()));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Pasword", pasword.Trim()));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_SYS_User_Login", lsInput);
if (dt.Rows.Count > 0)
{
item = new DTO.SYS_User(dt.Rows[0]);
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return item;
}
public static List<DTO.FIC_ShippingVolumeLine> Get(int id, string sSVHeaderNo_)
{
List<DTO.FIC_ShippingVolumeLine> lsArray = new List<DTO.FIC_ShippingVolumeLine>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@LineNo_", id));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@SVHeaderNo_", sSVHeaderNo_));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_FIC_ShippingVolumeLine_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.FIC_ShippingVolumeLine(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.SAM_Order> Get(string id, int orderTypeNo_, string routeNo_, string contractNo_, DateTime? createdDate, int status, bool display)
{
List<DTO.SAM_Order> lsArray = new List<DTO.SAM_Order>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@OrderNo_", id));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@OrderTypeNo_", orderTypeNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@RouteNo_", routeNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ContractNo_", contractNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@CreatedDate", createdDate));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", status));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Display", display));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_SAM_Order_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.SAM_Order(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.MAD_ActivityType> Get(int id, int ParentNo_, int UnActivityTypeNo_, int status, bool display)
{
List<DTO.MAD_ActivityType> lsArray = new List<DTO.MAD_ActivityType>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ActivityTypeNo_", id));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ParentNo_", ParentNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@UnActivityTypeNo_", UnActivityTypeNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Status", status));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Display", display));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_MAD_ActivityType_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.MAD_ActivityType(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.SYS_Menu> Get(string menuNo_, int display)
{
List<DTO.SYS_Menu> lsArray = new List<DTO.SYS_Menu>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@MenuNo_", menuNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Display", display));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_SYS_Menu_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.SYS_Menu(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
public static List<DTO.FIC_Inc_Exp_Document> Get(int id, int referenceNo_, string inc_Exp_FormNo_)
{
List<DTO.FIC_Inc_Exp_Document> lsArray = new List<DTO.FIC_Inc_Exp_Document>();
DataProvider.ConnectionVanTai conn = null;
try
{
conn = new DataProvider.ConnectionVanTai();
conn.Open();
List<System.Data.SqlClient.SqlParameter> lsInput = new List<System.Data.SqlClient.SqlParameter>();
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Inc_Exp_DocumentNo_", id));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@ReferenceNo_", referenceNo_));
lsInput.Add(new System.Data.SqlClient.SqlParameter("@Inc_Exp_FormNo_", inc_Exp_FormNo_));
System.Data.DataTable dt = conn.ExecuteNonQueryData("sp_FIC_Inc_Exp_Document_Get", lsInput);
foreach (System.Data.DataRow row in dt.Rows)
{
lsArray.Add(new DTO.FIC_Inc_Exp_Document(row));
}
}
catch (Exception ex)
{
}
finally
{
conn.Close();
}
return lsArray;
}
