//==============Select========================
public Entities.DiemThuongKhachHang[] SelectDiemThuongKhachHang(Entities.DiemThuongKhachHang input)
{
Entities.DiemThuongKhachHang[] list = null;
try
{
con = new Connection();
cn = con.openConnection();
cmd = new SqlCommand("exec sp_DiemThuongKhachHang @ThaoTac,@MaDiemThuongKhachHang,@MaKhachHang,@TenKhachHang,@TongDiem,@DiemDaDung,@DiemConLai,@GhiChu,@Deleted", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac;
//set
cmd.Parameters.Add("MaDiemThuongKhachHang", SqlDbType.VarChar).Value = input.MaDiemThuongKhachHang;
cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar).Value = input.MaKhachHang;
cmd.Parameters.Add("TenKhachHang", SqlDbType.NVarChar).Value = input.TenKhachHang;
cmd.Parameters.Add("TongDiem", SqlDbType.Int).Value = input.TongDiem;
cmd.Parameters.Add("DiemDaDung", SqlDbType.Int).Value = input.DiemDaDung;
cmd.Parameters.Add("DiemConLai", SqlDbType.Int).Value = input.DiemConLai;
cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu;
cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
arr = new ArrayList();
while (dr.Read())
{
Entities.DiemThuongKhachHang row = new Entities.DiemThuongKhachHang();
row.MaDiemThuongKhachHang = dr["MaDiemThuongKhachHang"].ToString();
row.MaKhachHang = dr["MaKhachHang"].ToString();
row.TenKhachHang = dr["TenKhachHang"].ToString();
row.TongDiem = int.Parse(dr["TongDiem"].ToString());
row.DiemDaDung = int.Parse(dr["DiemDaDung"].ToString());
row.DiemConLai = int.Parse(dr["DiemConLai"].ToString());
row.GhiChu = dr["GhiChu"].ToString();
row.Deleted = bool.Parse(dr["Deleted"].ToString());
arr.Add(row);
}
int n = arr.Count;
if (n == 0)
{
list = null;
}
list = new Entities.DiemThuongKhachHang[n];
for (int i = 0; i < n; i++)
{
list[i] = (Entities.DiemThuongKhachHang)arr[i];
}
}
catch (Exception ex)
{ string s = ex.Message.ToString(); list = null; }
finally
{
cmd.Connection.Dispose();
cn.Close();
con.closeConnection();
}
return(list);
}
public static Entities.DiemThuongKhachHang DiemThuongKhachHang_TO_DiemThuongKhachHang(Entities.DiemThuongKhachHang dtkh)
{
Entities.DiemThuongKhachHang kq = new Entities.DiemThuongKhachHang();
kq.MaDiemThuongKhachHang = dtkh.MaDiemThuongKhachHang;
kq.MaKhachHang = dtkh.MaKhachHang;
kq.TenKhachHang = dtkh.TenKhachHang;
kq.TongDiem = dtkh.TongDiem;
kq.DiemDaDung = dtkh.DiemDaDung;
kq.DiemConLai = dtkh.DiemConLai;
kq.GhiChu = dtkh.GhiChu;
kq.Deleted = dtkh.Deleted;
return(kq);
}
public static Entities.DiemThuongKhachHang DiemThuongKhachHang_TO_DiemThuongKhachHang(Entities.DiemThuongKhachHang dtkh)
{
Entities.DiemThuongKhachHang kq = new Entities.DiemThuongKhachHang();
kq.MaDiemThuongKhachHang = dtkh.MaDiemThuongKhachHang;
kq.MaKhachHang = dtkh.MaKhachHang;
kq.TenKhachHang = dtkh.TenKhachHang;
kq.TongDiem = dtkh.TongDiem;
kq.DiemDaDung = dtkh.DiemDaDung;
kq.DiemConLai = dtkh.DiemConLai;
kq.GhiChu = dtkh.GhiChu;
kq.Deleted = dtkh.Deleted;
return kq;
}
//==============Select========================
public Entities.DiemThuongKhachHang[] SelectDiemThuongKhachHang(Entities.DiemThuongKhachHang input)
{
Entities.DiemThuongKhachHang[] list = null;
try
{
con = new Connection();
cn = con.openConnection();
cmd = new SqlCommand("exec sp_DiemThuongKhachHang @ThaoTac,@MaDiemThuongKhachHang,@MaKhachHang,@TenKhachHang,@TongDiem,@DiemDaDung,@DiemConLai,@GhiChu,@Deleted", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac;
//set
cmd.Parameters.Add("MaDiemThuongKhachHang", SqlDbType.VarChar).Value = input.MaDiemThuongKhachHang;
cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar).Value = input.MaKhachHang;
cmd.Parameters.Add("TenKhachHang", SqlDbType.NVarChar).Value = input.TenKhachHang;
cmd.Parameters.Add("TongDiem", SqlDbType.Int).Value = input.TongDiem;
cmd.Parameters.Add("DiemDaDung", SqlDbType.Int).Value = input.DiemDaDung;
cmd.Parameters.Add("DiemConLai", SqlDbType.Int).Value = input.DiemConLai;
cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu;
cmd.Parameters.Add("Deleted", SqlDbType.Bit).Value = input.Deleted;
dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
arr = new ArrayList();
while (dr.Read())
{
Entities.DiemThuongKhachHang row = new Entities.DiemThuongKhachHang();
row.MaDiemThuongKhachHang = dr["MaDiemThuongKhachHang"].ToString();
row.MaKhachHang = dr["MaKhachHang"].ToString();
row.TenKhachHang = dr["TenKhachHang"].ToString();
row.TongDiem = int.Parse(dr["TongDiem"].ToString());
row.DiemDaDung = int.Parse(dr["DiemDaDung"].ToString());
row.DiemConLai = int.Parse(dr["DiemConLai"].ToString());
row.GhiChu = dr["GhiChu"].ToString();
row.Deleted = bool.Parse(dr["Deleted"].ToString());
arr.Add(row);
}
int n = arr.Count;
if (n == 0) list = null;
list = new Entities.DiemThuongKhachHang[n];
for (int i = 0; i < n; i++)
{
list[i] = (Entities.DiemThuongKhachHang)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 ThemSuaXoaDiemThuongKhachHang(Entities.DiemThuongKhachHang input)
{
int bg = 0;
try
{
con = new Connection();
cn = con.openConnection();
cmd = new SqlCommand("exec sp_DiemThuongKhachHang @ThaoTac,@MaDiemThuongKhachHang,@MaKhachHang,@TenKhachHang,@TongDiem,@DiemDaDung,@DiemConLai,@GhiChu,@Deleted", cn);
cmd.Parameters.Add("ThaoTac", SqlDbType.NVarChar).Value = input.ThaoTac;
//set
cmd.Parameters.Add("MaDiemThuongKhachHang", SqlDbType.VarChar).Value = input.MaDiemThuongKhachHang;
cmd.Parameters.Add("MaKhachHang", SqlDbType.VarChar).Value = input.MaKhachHang;
cmd.Parameters.Add("TenKhachHang", SqlDbType.NVarChar).Value = input.TenKhachHang;
cmd.Parameters.Add("TongDiem", SqlDbType.Int).Value = input.TongDiem;
cmd.Parameters.Add("DiemDaDung", SqlDbType.Int).Value = input.DiemDaDung;
cmd.Parameters.Add("DiemConLai", SqlDbType.Int).Value = input.DiemConLai;
cmd.Parameters.Add("GhiChu", SqlDbType.NVarChar).Value = input.GhiChu;
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);
}
