//==============Select======================== public Entities.ChiTietTheGiamGia[] SelectChiTietTheGiamGia(Entities.ChiTietTheGiamGia input) { Entities.ChiTietTheGiamGia[] list = null; try { con = new Connection(); cn = con.openConnection(); cmd = new SqlCommand("exec sp_ChiTietTheGiamGia @ThaoTac,@MaTheGiamGia,@MaKhachHang,@TenKhachHang,@GiaTriThe,@NgayThu,@MaPhieuThu,@Deleted", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac; //set cmd.Parameters.Add("MaTheGiamGia", SqlDbType.VarChar).Value = input.MaTheGiamGia; cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar).Value = input.MaKhachHang; cmd.Parameters.Add("TenKhachHang", SqlDbType.NVarChar).Value = input.TenKhachHang; cmd.Parameters.Add("GiaTriThe", SqlDbType.Float).Value = input.GiaTriThe; cmd.Parameters.Add("NgayThu", SqlDbType.DateTime).Value = input.NgayThu; cmd.Parameters.Add("MaPhieuThu", SqlDbType.VarChar).Value = input.MaPhieuThu; cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.ChiTietTheGiamGia row = new Entities.ChiTietTheGiamGia(); row.MaTheGiamGia = dr["MaTheGiamGia"].ToString(); row.MaKhachHang = dr["MaKhachHang"].ToString(); row.TenKhachHang = dr["TenKhachHang"].ToString(); row.GiaTriThe = float.Parse(dr["GiaTriThe"].ToString()); row.NgayThu = DateTime.Parse(dr["NgayThu"].ToString()); row.MaPhieuThu = dr["MaPhieuThu"].ToString(); row.Deleted = bool.Parse(dr["Deleted"].ToString()); arr.Add(row); } int n = arr.Count; if (n == 0) { list = null; } list = new Entities.ChiTietTheGiamGia[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.ChiTietTheGiamGia)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); list = null; } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } return(list); }
//==============Select======================== public Entities.ChiTietTheGiamGia[] SelectChiTietTheGiamGia(Entities.ChiTietTheGiamGia input) { Entities.ChiTietTheGiamGia[] list = null; try { con = new Connection(); cn = con.openConnection(); cmd = new SqlCommand("exec sp_ChiTietTheGiamGia @ThaoTac,@MaTheGiamGia,@MaKhachHang,@TenKhachHang,@GiaTriThe,@NgayThu,@MaPhieuThu,@Deleted", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac; //set cmd.Parameters.Add("MaTheGiamGia", SqlDbType.VarChar).Value = input.MaTheGiamGia; cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar).Value = input.MaKhachHang; cmd.Parameters.Add("TenKhachHang", SqlDbType.NVarChar).Value = input.TenKhachHang; cmd.Parameters.Add("GiaTriThe", SqlDbType.Float).Value = input.GiaTriThe; cmd.Parameters.Add("NgayThu", SqlDbType.DateTime).Value = input.NgayThu; cmd.Parameters.Add("MaPhieuThu", SqlDbType.VarChar).Value = input.MaPhieuThu; cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); arr = new ArrayList(); while (dr.Read()) { Entities.ChiTietTheGiamGia row = new Entities.ChiTietTheGiamGia(); row.MaTheGiamGia = dr["MaTheGiamGia"].ToString(); row.MaKhachHang = dr["MaKhachHang"].ToString(); row.TenKhachHang = dr["TenKhachHang"].ToString(); row.GiaTriThe = float.Parse(dr["GiaTriThe"].ToString()); row.NgayThu = DateTime.Parse(dr["NgayThu"].ToString()); row.MaPhieuThu = dr["MaPhieuThu"].ToString(); row.Deleted = bool.Parse(dr["Deleted"].ToString()); arr.Add(row); } int n = arr.Count; if (n == 0) list = null; list = new Entities.ChiTietTheGiamGia[n]; for (int i = 0; i < n; i++) { list[i] = (Entities.ChiTietTheGiamGia)arr[i]; } } catch (Exception ex) { string s = ex.Message.ToString(); list = null; } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } return list; }
//==============Insert======================== public int ThemSuaXoaChiTietTheGiamGia(Entities.ChiTietTheGiamGia input) { int bg = 0; try { con = new Connection(); cn = con.openConnection(); cmd = new SqlCommand("exec sp_ChiTietTheGiamGia @ThaoTac,@MaTheGiamGia,@MaKhachHang,@TenKhachHang,@GiaTriThe,@NgayThu,@MaPhieuThu,@Deleted", cn); cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac; //set cmd.Parameters.Add("MaTheGiamGia", SqlDbType.VarChar).Value = input.MaTheGiamGia; cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar).Value = input.MaKhachHang; cmd.Parameters.Add("TenKhachHang", SqlDbType.NVarChar).Value = input.TenKhachHang; cmd.Parameters.Add("GiaTriThe", SqlDbType.Float).Value = input.GiaTriThe; cmd.Parameters.Add("NgayThu", SqlDbType.DateTime).Value = input.NgayThu; cmd.Parameters.Add("MaPhieuThu", SqlDbType.VarChar).Value = input.MaPhieuThu; cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted; bg = cmd.ExecuteNonQuery(); } catch (Exception) { bg = 0; } finally { cmd.Connection.Dispose(); cn.Close(); con.closeConnection(); } if (bg == 0) { return(bg); } return(bg); }
//Cập nhật trạng thái đã thanh toán của thẻ giá trị private bool CapNhatChiTietTheGiamGia() { try { Entities.ChiTietTheGiamGia input = new Entities.ChiTietTheGiamGia(); input.ThaoTac = "insert"; input.MaTheGiamGia = comboBox1.Text.ToUpper(); input.MaKhachHang = txtdoituong.Text.ToUpper(); input.TenKhachHang = LayTenKhachHang(txtdoituong.Text.ToUpper()); LayTheGiamGia(); foreach (Entities.TheGiamGia item in TGG) { if (item.MaTheGiamGia.ToUpper().Equals(comboBox1.Text.ToUpper())) { input.GiaTriThe = double.Parse(item.GiaTriThe); } } input.NgayThu = DateServer.Date(); input.MaPhieuThu = txtsochungtu.Text.ToUpper(); input.Deleted = false; cl = new Server_Client.Client(); this.client1 = cl.Connect(Luu.IP, Luu.Ports); clientstrem = cl.SerializeObj(this.client1, "ChiTietTheGiamGia", input); int msg = 0; msg = (int)cl.DeserializeHepper(clientstrem, msg); if (msg != 0) return true; else return false; } catch { return false; } }