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