//==============Select======================== /// <summary> /// SelectTheoDieuKien_GiaVon: /// - Select_GIAVON /// - Insert_GIAVON /// - Update_TheoMaKhoVaMaHangHoa_GIAVON /// - Delete_TheoMaKhoVaMaHangHoa_GIAVON /// </summary> /// <param name="thaotac"></param> /// <param name="set"></param> /// <param name="filter"></param> /// <returns></returns> public Entities.GiaVon[] SelectTheoDieuKien_GiaVon(string thaotac, Entities.GiaVon set, Entities.GiaVon filter) { Entities.GiaVon[] list = null; try { con = new Connection(); cn = con.openConnection(); cmd = new SqlCommand("exec sp_GiaVon @ThaoTac,@MaKho,@MaHangHoa,@SoLuong,@Gia,@MaKhok,@MaHangHoak,@SoLuongk,@Giak", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = thaotac; //set cmd.Parameters.Add("MaKho", SqlDbType.NVarChar).Value = set.MaKho; cmd.Parameters.Add("MaHangHoa", SqlDbType.NVarChar).Value = set.MaHangHoa; cmd.Parameters.Add("SoLuong", SqlDbType.NVarChar).Value = set.SoLuong; cmd.Parameters.Add("Gia", SqlDbType.NVarChar).Value = set.Gia; //filter cmd.Parameters.Add("MaKhok", SqlDbType.NVarChar).Value = filter.MaKho; cmd.Parameters.Add("MaHangHoak", SqlDbType.NVarChar).Value = filter.MaHangHoa; cmd.Parameters.Add("SoLuongk", SqlDbType.NVarChar).Value = filter.SoLuong; cmd.Parameters.Add("Giak", SqlDbType.NVarChar).Value = filter.Gia; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { int sl; float g; Entities.GiaVon row = new Entities.GiaVon { MaKho = dr["MaKho"].ToString(), MaHangHoa = dr["MaHangHoa"].ToString(), SoLuong = int.TryParse(dr["SoLuong"].ToString(), out sl) ? sl : 0, Gia = float.TryParse(dr["Gia"].ToString(), out g) ? g : 0 }; arr.Add(row); } int n = arr.Count; if (n == 0) { list = null; } list = new Entities.GiaVon[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.GiaVon)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); list = null; } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } return(list); }
//==============Select======================== /// <summary> /// SelectTheoDieuKien_GiaVon: /// - Select_GIAVON /// - Insert_GIAVON /// - Update_TheoMaKhoVaMaHangHoa_GIAVON /// - Delete_TheoMaKhoVaMaHangHoa_GIAVON /// </summary> /// <param name="thaotac"></param> /// <param name="set"></param> /// <param name="filter"></param> /// <returns></returns> public Entities.GiaVon[] SelectTheoDieuKien_GiaVon(string thaotac, Entities.GiaVon set, Entities.GiaVon filter) { Entities.GiaVon[] list = null; try { con = new Connection(); cn = con.openConnection(); cmd = new SqlCommand("exec sp_GiaVon @ThaoTac,@MaKho,@MaHangHoa,@SoLuong,@Gia,@MaKhok,@MaHangHoak,@SoLuongk,@Giak", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = thaotac; //set cmd.Parameters.Add("MaKho", SqlDbType.NVarChar).Value = set.MaKho; cmd.Parameters.Add("MaHangHoa", SqlDbType.NVarChar).Value = set.MaHangHoa; cmd.Parameters.Add("SoLuong", SqlDbType.NVarChar).Value = set.SoLuong; cmd.Parameters.Add("Gia", SqlDbType.NVarChar).Value = set.Gia; //filter cmd.Parameters.Add("MaKhok", SqlDbType.NVarChar).Value = filter.MaKho; cmd.Parameters.Add("MaHangHoak", SqlDbType.NVarChar).Value = filter.MaHangHoa; cmd.Parameters.Add("SoLuongk", SqlDbType.NVarChar).Value = filter.SoLuong; cmd.Parameters.Add("Giak", SqlDbType.NVarChar).Value = filter.Gia; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { int sl; float g; Entities.GiaVon row = new Entities.GiaVon { MaKho = dr["MaKho"].ToString(), MaHangHoa = dr["MaHangHoa"].ToString(), SoLuong = int.TryParse(dr["SoLuong"].ToString(), out sl) ? sl : 0, Gia = float.TryParse(dr["Gia"].ToString(), out g) ? g : 0 }; arr.Add(row); } int n = arr.Count; if (n == 0) list = null; list = new Entities.GiaVon[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.GiaVon)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); list = null; } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } return list; }
//============Thêm Sửa Xóa=================================================== /// <summary> /// ThaoTac_GiaVon: /// - Select_GIAVON /// - Insert_GIAVON /// - Update_TheoMaKhoVaMaHangHoa_GIAVON /// - Delete_TheoMaKhoVaMaHangHoa_GIAVON /// </summary> /// <param name="thaotac"></param> /// <param name="set"></param> /// <param name="filter"></param> /// <returns></returns> public int ThaoTac_GiaVon(string thaotac, Entities.GiaVon set, Entities.GiaVon filter) { int bg = 0; try { con = new Connection(); cn = con.openConnection(); cmd = new SqlCommand("exec sp_GiaVon @ThaoTac,@MaKho,@MaHangHoa,@SoLuong,@Gia,@MaKhok,@MaHangHoak,@SoLuongk,@Giak", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = thaotac; //set cmd.Parameters.Add("MaKho", SqlDbType.NVarChar).Value = set.MaKho; cmd.Parameters.Add("MaHangHoa", SqlDbType.NVarChar).Value = set.MaHangHoa; cmd.Parameters.Add("SoLuong", SqlDbType.NVarChar).Value = set.SoLuong; cmd.Parameters.Add("Gia", SqlDbType.NVarChar).Value = set.Gia; //filter cmd.Parameters.Add("MaKhok", SqlDbType.NVarChar).Value = filter.MaKho; cmd.Parameters.Add("MaHangHoak", SqlDbType.NVarChar).Value = filter.MaHangHoa; cmd.Parameters.Add("SoLuongk", SqlDbType.NVarChar).Value = filter.SoLuong; cmd.Parameters.Add("Giak", SqlDbType.NVarChar).Value = filter.Gia; bg = cmd.ExecuteNonQuery(); } catch (Exception) { bg = 0; } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } if (bg == 0) { return(bg); } return(bg); }