/// <summary>
///
/// </summary>
/// <param name="gv"></param>
/// <returns></returns>
public Entities.GiaVonBanHang[] Select(Entities.GiaVonBanHang gv)
{
string sql = Common.GiaVonBanHang.Select;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(Common.GiaVonBanHang.HanhDong, SqlDbType.VarChar, 50).Value = gv.HanhDong;
cmd.Parameters.Add(Common.GiaVonBanHang.MaHoaDon, SqlDbType.VarChar, 50).Value = gv.MaHoaDon;
cmd.Parameters.Add(Common.GiaVonBanHang.MaHangHoa, SqlDbType.VarChar, 50).Value = gv.MaHangHoa;
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//Insert Category into ArrayList
List<Entities.GiaVonBanHang> arr = new List<Entities.GiaVonBanHang>();
while (dr.Read())
{
Entities.GiaVonBanHang item = new Entities.GiaVonBanHang();
//item.HanhDong = dr[Common.GiaVonBanHang.HanhDong].ToString();
item.MaHoaDon = dr[Common.GiaVonBanHang.MaHoaDon].ToString();
item.MaHangHoa = dr[Common.GiaVonBanHang.MaHangHoa].ToString();
item.GiaVon = double.Parse(dr[Common.GiaVonBanHang.GiaVon].ToString());
arr.Add(item);
}
int n = arr.Count;
if (n == 0)
return null;
//Giai phong bo nho
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return arr.ToArray();
}
public Entities.GiaVonBanHang[] GiaVon()
{
Entities.GiaVonBanHang[] giaVon = null;
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.GiaVonBanHang gv = new Entities.GiaVonBanHang();
gv.HanhDong = "SelectAll";
gv.MaHoaDon = string.Empty;
gv.MaHangHoa = string.Empty;
clientstrem = cl.SerializeObj(this.client1, "GiaVonBanHang", gv);
////// đổ mảng đối tượng vào datagripview
giaVon = (Entities.GiaVonBanHang[])cl.DeserializeHepper1(clientstrem, giaVon);
if (giaVon == null)
{
giaVon = new Entities.GiaVonBanHang[0];
}
}
catch
{
}
return(giaVon);
}
/// <summary>
///
/// </summary>
/// <param name="gv"></param>
/// <returns></returns>
public bool Insert(Entities.GiaVonBanHang gv)
{
bool kt = false;
try
{
string sql = Common.GiaVonBanHang.Insert;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(Common.GiaVonBanHang.MaHoaDon, SqlDbType.VarChar, 50).Value = gv.MaHoaDon;
cmd.Parameters.Add(Common.GiaVonBanHang.MaHangHoa, SqlDbType.VarChar, 50).Value = gv.MaHangHoa;
cmd.Parameters.Add(Common.GiaVonBanHang.GiaVon, SqlDbType.Float).Value = gv.GiaVon;
int i = cmd.ExecuteNonQuery();
if (i == 1)
{
kt = true;
}
else
{
kt = false;
}
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return(kt);
}
catch (Exception ex)
{
string s = ex.Message;
return(false);
}
}
/// <summary>
///
/// </summary>
/// <param name="gv"></param>
/// <returns></returns>
public Entities.GiaVonBanHang[] Select(Entities.GiaVonBanHang gv)
{
string sql = Common.GiaVonBanHang.Select;
Connection conn = new Connection();
SqlConnection cn = conn.openConnection();
SqlCommand cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add(Common.GiaVonBanHang.HanhDong, SqlDbType.VarChar, 50).Value = gv.HanhDong;
cmd.Parameters.Add(Common.GiaVonBanHang.MaHoaDon, SqlDbType.VarChar, 50).Value = gv.MaHoaDon;
cmd.Parameters.Add(Common.GiaVonBanHang.MaHangHoa, SqlDbType.VarChar, 50).Value = gv.MaHangHoa;
SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
//Insert Category into ArrayList
List <Entities.GiaVonBanHang> arr = new List <Entities.GiaVonBanHang>();
while (dr.Read())
{
Entities.GiaVonBanHang item = new Entities.GiaVonBanHang();
//item.HanhDong = dr[Common.GiaVonBanHang.HanhDong].ToString();
item.MaHoaDon = dr[Common.GiaVonBanHang.MaHoaDon].ToString();
item.MaHangHoa = dr[Common.GiaVonBanHang.MaHangHoa].ToString();
item.GiaVon = double.Parse(dr[Common.GiaVonBanHang.GiaVon].ToString());
arr.Add(item);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
//Giai phong bo nho
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
cn = null;
conn = null;
return(arr.ToArray());
}
public Entities.GiaVonBanHang[] GiaVon()
{
Entities.GiaVonBanHang[] giaVon = null;
try
{
cl = new Server_Client.Client();
this.client1 = cl.Connect(Luu.IP, Luu.Ports);
Entities.GiaVonBanHang gv = new Entities.GiaVonBanHang();
gv.HanhDong = "SelectAll";
gv.MaHoaDon = string.Empty;
gv.MaHangHoa = string.Empty;
clientstrem = cl.SerializeObj(this.client1, "GiaVonBanHang", gv);
////// đổ mảng đối tượng vào datagripview
giaVon = (Entities.GiaVonBanHang[])cl.DeserializeHepper1(clientstrem, giaVon);
if (giaVon == null)
{
giaVon = new Entities.GiaVonBanHang[0];
}
}
catch
{
}
return giaVon;
}
