/// <summary> /// Get destination code from supplier /// </summary> /// <returns></returns> public List <pts_destination> GetListDestination() { List <pts_destination> outList = new List <pts_destination>(); //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "SELECT supplier_cd, supplier_name FROM pts_supplier WHERE supplier_cd like '999%' ORDER BY supplier_cd"; //Execute non query for read database IDataReader reader = SQL.Command(query).ExecuteReader(); query = string.Empty; while (reader.Read()) { pts_destination outItem = new pts_destination() { dept_cd = "Other", destination_cd = reader["supplier_cd"].ToString(), destination_name = reader["supplier_name"].ToString(), registration_user_cd = UserData.usercode, registration_date_time = DateTime.Now }; outList.Add(outItem); } reader.Close(); SQL.Close(); return(outList); }
public int AddDestination(pts_destination adddest) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "INSERT INTO pts_destination(destination_cd, destination_name, dept_cd, registration_user_cd)"; query += "VALUES ('" + adddest.destination_cd + "','" + adddest.destination_name + "','" + adddest.dept_cd + "','" + adddest.registration_user_cd + "')"; //Execute non query for read database int result = SQL.Command(query).ExecuteNonQuery(); query = string.Empty; return(result); }
public int UpdateDest(pts_destination updest) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; //Open SQL connection SQL.Open(); //SQL query string query = "UPDATE pts_destination SET destination_cd='" + updest.destination_cd + "',destination_name = '" + updest.destination_name + "',dept_cd = '" + updest.dept_cd; query += "', registration_user_cd ='" + updest.registration_user_cd; query += "', registration_date_time = now() where destination_id ='" + updest.destination_id + "'"; //Execute non query for read database int result = SQL.Command(query).ExecuteNonQuery(); query = string.Empty; return(result); }
/// <summary> /// Get list destination from database with destination code and department code /// </summary> /// <param name="des_code">string.empty if get list without destination code</param> /// <param name="dept_code">string.empty if get list without department code</param> public void GetListDestination(string des_code, string dept_code) { //SQL library PSQL SQL = new PSQL(); string query = string.Empty; listdestination = new BindingList <pts_destination>(); //Open SQL connection SQL.Open(); //SQL query string query = "SELECT destination_id, destination_cd, destination_name, dept_cd, registration_user_cd, registration_date_time "; query += "FROM pts_destination WHERE 1=1 "; if (!string.IsNullOrEmpty(des_code)) { query += "and destination_cd = '" + des_code + "' "; } if (!string.IsNullOrEmpty(dept_code)) { query += "and dept_cd = '" + dept_code + "' "; } query += "order by destination_id"; //Execute reader for read database IDataReader reader = SQL.Command(query).ExecuteReader(); query = string.Empty; while (reader.Read()) { //Get an item pts_destination outItem = new pts_destination { destination_id = (int)reader["destination_id"], destination_cd = reader["destination_cd"].ToString(), destination_name = reader["destination_name"].ToString(), dept_cd = reader["dept_cd"].ToString(), registration_date_time = (DateTime)reader["registration_date_time"], registration_user_cd = reader["registration_user_cd"].ToString() }; //Add item into list listdestination.Add(outItem); } reader.Close(); //Close SQL connection SQL.Close(); }