public List <DTO_ChiTietPhieuXuat> timkiem(string tukhoa)
{
List <DTO_ChiTietPhieuXuat> ds = new List <DTO_ChiTietPhieuXuat>();
string query = string.Empty;
query += "SELECT * FROM [tblcthoadonxuat]";
query += "WHERE [mahoadon] = @tukhoa";
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@tukhoa", tukhoa);
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
DTO_ChiTietPhieuXuat ctpx = new DTO_ChiTietPhieuXuat();
ctpx.Id = long.Parse(reader["id"].ToString());
ctpx.MaPx = long.Parse(reader["mahoadon"].ToString());
ctpx.MaDvt = long.Parse(reader["madvt"].ToString());
ctpx.MaMh = long.Parse(reader["mahang"].ToString());
ctpx.SoLuong = int.Parse(reader["soluong"].ToString());
//ctpx.ThanhTien = /*(uint)reader.GetDecimal(5);*/ uint.Parse(reader["dongiaban"].ToString());
ds.Add(ctpx);
}
}
con.Close();
con.Dispose();
}
catch
{
con.Close();
return(null);
}
}
}
return(ds);
}
public List <DTO_ChiTietPhieuXuat> LayDanhSachChiTiet()
{
List <DTO_ChiTietPhieuXuat> ds = new List <DTO_ChiTietPhieuXuat>();
string query = string.Empty;
query = "SELECT * FROM tblChiTietPX";
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows == true)
{
while (reader.Read())
{
DTO_ChiTietPhieuXuat ctpx = new DTO_ChiTietPhieuXuat();
ctpx.Id = long.Parse(reader["id"].ToString());
ctpx.MaPx = long.Parse(reader["maPX"].ToString());
ctpx.MaDvt = long.Parse(reader["maDVT"].ToString());
ctpx.MaMh = long.Parse(reader["maMH"].ToString());
ctpx.SoLuong = int.Parse(reader["soLuong"].ToString());
ctpx.ThanhTien = (uint)reader.GetDecimal(5);
ds.Add(ctpx);
}
}
con.Close();
con.Dispose();
}
catch
{
con.Close();
return(null);
}
}
}
return(ds);
}
public bool SuaChiTietPX(DTO_ChiTietPhieuXuat ctpx)
{
string query = string.Empty;
query = "UPDATE [tblcthoadonxuat] " +
"SET [madvt] = @madvt , [mahang] = @mahang, [soluong] = @soluong " +
"WHERE [id] = @id";
//query = "SuaDaiLy";
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@madvt", ctpx.MaDvt);
cmd.Parameters.AddWithValue("@mahang", ctpx.MaMh);
cmd.Parameters.AddWithValue("@soluong", ctpx.SoLuong);
cmd.Parameters.AddWithValue("@id", ctpx.Id);
try
{
con.Open();
if (cmd.ExecuteNonQuery() > 0)
{
con.Close();
con.Dispose();
return(true);
}
else
{
con.Close();
return(false);
}
}
catch
{
con.Close();
return(false);
}
}
}
}
public bool ThemChiTiet(DTO_ChiTietPhieuXuat chitiet)
{
string query = string.Empty;
query += "INSERT [dbo].[tblcthoadonxuat] ([mahang], [mahoadon],[dongiaban], [madvt], [soLuong])";
query += "VALUES (@mahang, @mahoadon, @dongiaban, @madvt, @soluong)";
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = System.Data.CommandType.Text;
cmd.CommandText = query;
cmd.Parameters.AddWithValue("@mahoadon", chitiet.MaPx);
cmd.Parameters.AddWithValue("@madvt", chitiet.MaDvt);
cmd.Parameters.AddWithValue("@mahang", chitiet.MaMh);
cmd.Parameters.AddWithValue("@soluong", chitiet.SoLuong);
cmd.Parameters.AddWithValue("@dongiaban", Decimal.Parse(chitiet.ThanhTien.ToString()));
try
{
con.Open();
if (cmd.ExecuteNonQuery() > 0)
{
con.Close();
con.Dispose();
return(true);
}
else
{
con.Close();
return(false);
}
}
catch
{
con.Close();
return(false);
}
}
}
}
public bool SuaChiTietPX(DTO_ChiTietPhieuXuat ctpx)
{
return(chitietphieuxuat.SuaChiTietPX(ctpx));
}
public bool ThemChiTietPX(DTO_ChiTietPhieuXuat ctpx)
{
return(chitietphieuxuat.ThemChiTiet(ctpx));
}
