public Entities.KiemTraChung KiemTraMa(Entities.KiemTraChung giatri)
{
ve = new Entities.KiemTraChung();
try
{
SqlDataReader read = null;
Common.Constants.BienChung conten = new Common.Constants.BienChung();
Sql = new Constants.Sql();
string sql = Sql.sp_KiemTraMa;
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar, 50).Value = giatri.Khoachinh;
cmd.Parameters.Add("TenHangHoa", SqlDbType.NVarChar, 50).Value = giatri.Name;
read = cmd.ExecuteReader();
while (read.Read())
{
ve.Hanhdong = read["ThongBao"].ToString();
}
read.Close();
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(ve);
}
/// <summary>
/// kiem tra trang loai don dat hang theo ma don hang
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.TruyenGiaTri KiemTraDonDatHang(Entities.TruyenGiaTri giatri)
{
Entities.TruyenGiaTri ve = null;
try
{
SqlDataReader read = null;
Sql = new Constants.Sql();
string sql = "exec sp_KiemTraDonDatHang @HanhDong,@MaDonDatHang";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("HanhDong", SqlDbType.VarChar, 20).Value = giatri.Giatritruyen;
cmd.Parameters.Add("MaDonDatHang", SqlDbType.VarChar, 20).Value = giatri.Giatrithuhai;
read = cmd.ExecuteReader();
while (read.Read())
{
ve = new Entities.TruyenGiaTri();
ve.Giatritruyen = read[0].ToString();
ve.Giatrithuhai = read[1].ToString();
}
read.Close();
}
catch (Exception ex)
{
string s = ex.Message.ToString();
ve = null;
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(ve);
}
/// <summary>
/// lay ID
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.KiemTraChung[] LayCombox(Entities.KiemTraChung giatri)
{
Entities.KiemTraChung[] matrave = null;
try
{
SqlDataReader read = null;
Common.Constants.BienChung conten = new Common.Constants.BienChung();
Sql = new Constants.Sql();
string sql = "exec sp_LayCombox @tableName,@columnID,@columnName";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("@tableName", SqlDbType.NVarChar, 20).Value = giatri.Name;
cmd.Parameters.Add("@columnID", SqlDbType.NVarChar, 20).Value = giatri.Khoachinh;
cmd.Parameters.Add("@columnName", SqlDbType.NVarChar, 20).Value = giatri.Giatri;
read = cmd.ExecuteReader();
ArrayList arr = new ArrayList();
while (read.Read())
{
Entities.KiemTraChung kt = new Entities.KiemTraChung();
kt.Khoachinh = read[0].ToString().ToUpper();
kt.Giatri = read[1].ToString();
arr.Add(kt);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
matrave = new Entities.KiemTraChung[n];
for (int i = 0; i < n; i++)
{
matrave[i] = (Entities.KiemTraChung)arr[i];
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(matrave);
}
/// <summary>
/// lay ID
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.KiemTraChung[] LayThongTinTienTe()
{
Entities.KiemTraChung[] matrave = null;
try
{
SqlDataReader read = null;
Common.Constants.BienChung conten = new Common.Constants.BienChung();
Sql = new Constants.Sql();
string sql = "exec sp_LayThongTinTienTe";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
read = cmd.ExecuteReader();
ArrayList arr = new ArrayList();
while (read.Read())
{
Entities.KiemTraChung kt = new Entities.KiemTraChung();
kt.Khoachinh = read[0].ToString().ToUpper();
kt.Giatri = read[1].ToString();
kt.Giatri2 = read[2].ToString();
arr.Add(kt);
}
int n = arr.Count;
if (n == 0)
{
return(null);
}
matrave = new Entities.KiemTraChung[n];
for (int i = 0; i < n; i++)
{
matrave[i] = (Entities.KiemTraChung)arr[i];
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(matrave);
}
/// <summary>
///
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.KiemTraChung[] LaySoLuongDaTraLaiTheoHoaDonNhap(Entities.TruyenGiaTri giatri)
{
Entities.KiemTraChung[] tra = null;
try
{
SqlDataReader read = null;
string sql = "exec sp_LaySoLuongDaTraLaiTheoHoaDonNhap @MaHoaDonNhap";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("MaHoaDonNhap", SqlDbType.NVarChar, 20).Value = giatri.Giatritruyen;
read = cmd.ExecuteReader();
ArrayList arr = new ArrayList();
while (read.Read())
{
Entities.KiemTraChung banghi = new Entities.KiemTraChung();
banghi.Giatri = read[0].ToString();
banghi.Giatri2 = read[1].ToString();
arr.Add(banghi);
}
read.Close();
int n = arr.Count;
if (n == 0)
{
tra = null;
}
tra = new Entities.KiemTraChung[n];
for (int i = 0; i < n; i++)
{
tra[i] = (Entities.KiemTraChung)arr[i];
}
}
catch (Exception ex)
{
string s = ex.Message.ToString(); tra = null;
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return(tra);
}
private void LayTenTT()
{
try
{
cbxTienTe_TyGia.Items.Clear();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
Entities.KiemTraChung tt1 = new Entities.KiemTraChung();
tt1 = new Entities.KiemTraChung("Select");
clientstrem = cl.SerializeObj(this.client, "LayThongTinTienTe", tt1);
Entities.KiemTraChung[] tt = new Entities.KiemTraChung[1];
tt = (Entities.KiemTraChung[])cl.DeserializeHepper1(clientstrem, tt);
client.Close();
clientstrem.Close();
if (tt.Length > 0)
{
tigia = tt;
Common.Utilities com = new Common.Utilities();
com.BindingCombobox(tt, cbxTienTe_TyGia, "giatri", "khoachinh");
}
else
{ cbxTienTe_TyGia.Items.Clear(); }
}
catch (Exception ex)
{
cbxTienTe_TyGia.Items.Clear();
string s = ex.Message.ToString();
}
}
/// <summary>
/// hungvv --------------------kiem tra ma hang------------------
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
private string KiemTraMa(string ID)
{
string kt = null;
try
{
Entities.KiemTraChung ktm = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.KiemTraChung("Select", ID);
clientstrem = cl.SerializeObj(this.client, "KiemTraMa", ktm);
Entities.KiemTraChung tra = new Entities.KiemTraChung();
tra = (Entities.KiemTraChung)cl.DeserializeHepper(clientstrem, tra);
kt = tra.Hanhdong;
}
catch (Exception ex)
{ string s = ex.Message; }
return kt;
}
/// <summary>
/// hungvv --------------------kiem tra ma hang khi them chi tiet hang------------------
/// </summary>
/// <param name="ID"></param>
/// <returns></returns>
private string KiemTraMa(Entities.HienThi_ChiTiet_DonDatHang lay)
{
string kt = null;
try
{
Entities.KiemTraChung ktm = new Entities.KiemTraChung();
cl = new Server_Client.Client();
this.client = cl.Connect(Luu.IP, Luu.Ports);
ktm = new Entities.KiemTraChung("Select", lay.MaHangHoa, lay.TenHangHoa);
clientstrem = cl.SerializeObj(this.client, "KiemTraMa", ktm);
Entities.KiemTraChung tra = new Entities.KiemTraChung();
tra = (Entities.KiemTraChung)cl.DeserializeHepper(clientstrem, tra);
if (tra != null)
{
kt = tra.Hanhdong;
}
else
{ kt = null; }
}
catch (Exception ex)
{ string s = ex.Message; }
return kt;
}
/// <summary>
/// lay ID
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.KiemTraChung[] LayThongTinTienTe()
{
Entities.KiemTraChung[] matrave = null;
try
{
SqlDataReader read = null;
Common.Constants.BienChung conten = new Common.Constants.BienChung();
Sql = new Constants.Sql();
string sql = "exec sp_LayThongTinTienTe";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
read = cmd.ExecuteReader();
ArrayList arr = new ArrayList();
while (read.Read())
{
Entities.KiemTraChung kt = new Entities.KiemTraChung();
kt.Khoachinh = read[0].ToString().ToUpper();
kt.Giatri = read[1].ToString();
kt.Giatri2 = read[2].ToString();
arr.Add(kt);
}
int n = arr.Count;
if (n == 0) { return null; }
matrave = new Entities.KiemTraChung[n];
for (int i = 0; i < n; i++)
{
matrave[i] = (Entities.KiemTraChung)arr[i];
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return matrave;
}
/// <summary>
///
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.KiemTraChung[] LaySoLuongDaTraLaiTheoHoaDonNhap(Entities.TruyenGiaTri giatri)
{
Entities.KiemTraChung[] tra = null;
try
{
SqlDataReader read = null;
string sql = "exec sp_LaySoLuongDaTraLaiTheoHoaDonNhap @MaHoaDonNhap";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("MaHoaDonNhap", SqlDbType.NVarChar, 20).Value = giatri.Giatritruyen;
read = cmd.ExecuteReader();
ArrayList arr = new ArrayList();
while (read.Read())
{
Entities.KiemTraChung banghi = new Entities.KiemTraChung();
banghi.Giatri = read[0].ToString();
banghi.Giatri2 = read[1].ToString();
arr.Add(banghi);
}
read.Close();
int n = arr.Count;
if (n == 0) { tra= null; }
tra = new Entities.KiemTraChung[n];
for (int i = 0; i < n; i++)
{
tra[i] = (Entities.KiemTraChung)arr[i];
}
}
catch (Exception ex)
{
string s = ex.Message.ToString(); tra = null;
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return tra;
}
/// <summary>
/// lay ID
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.KiemTraChung[] LayCombox(Entities.KiemTraChung giatri)
{
Entities.KiemTraChung[] matrave=null;
try
{
SqlDataReader read = null;
Common.Constants.BienChung conten = new Common.Constants.BienChung();
Sql = new Constants.Sql();
string sql = "exec sp_LayCombox @tableName,@columnID,@columnName";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("@tableName", SqlDbType.NVarChar, 20).Value = giatri.Name;
cmd.Parameters.Add("@columnID", SqlDbType.NVarChar, 20).Value = giatri.Khoachinh;
cmd.Parameters.Add("@columnName", SqlDbType.NVarChar, 20).Value = giatri.Giatri;
read = cmd.ExecuteReader();
ArrayList arr = new ArrayList();
while (read.Read())
{
Entities.KiemTraChung kt = new Entities.KiemTraChung();
kt.Khoachinh = read[0].ToString().ToUpper();
kt.Giatri = read[1].ToString();
arr.Add(kt);
}
int n = arr.Count;
if (n == 0) { return null; }
matrave = new Entities.KiemTraChung[n];
for (int i = 0; i < n; i++)
{
matrave[i] = (Entities.KiemTraChung)arr[i];
}
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return matrave;
}
public Entities.KiemTraChung KiemTraMa(Entities.KiemTraChung giatri)
{
ve = new Entities.KiemTraChung();
try
{
SqlDataReader read = null;
Common.Constants.BienChung conten = new Common.Constants.BienChung();
Sql = new Constants.Sql();
string sql = Sql.sp_KiemTraMa;
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("MaHangHoa", SqlDbType.VarChar, 50).Value = giatri.Khoachinh;
cmd.Parameters.Add("TenHangHoa", SqlDbType.NVarChar, 50).Value = giatri.Name;
read = cmd.ExecuteReader();
while (read.Read())
{
ve.Hanhdong = read["ThongBao"].ToString();
}
read.Close();
}
catch (Exception ex)
{
string s = ex.Message.ToString();
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return ve;
}
/// <summary>
/// kiem tra trang loai don dat hang theo ma don hang
/// </summary>
/// <param name="giatri"></param>
/// <returns></returns>
public Entities.TruyenGiaTri KiemTraDonDatHang(Entities.TruyenGiaTri giatri)
{
Entities.TruyenGiaTri ve = null;
try
{
SqlDataReader read = null;
Sql = new Constants.Sql();
string sql = "exec sp_KiemTraDonDatHang @HanhDong,@MaDonDatHang";
conn = new Connection();
cn = conn.openConnection();
cmd = new SqlCommand(sql, cn);
cmd.Parameters.Add("HanhDong", SqlDbType.VarChar, 20).Value = giatri.Giatritruyen;
cmd.Parameters.Add("MaDonDatHang", SqlDbType.VarChar, 20).Value = giatri.Giatrithuhai;
read = cmd.ExecuteReader();
while (read.Read())
{
ve= new Entities.TruyenGiaTri();
ve.Giatritruyen = read[0].ToString();
ve.Giatrithuhai = read[1].ToString();
}
read.Close();
}
catch (Exception ex)
{
string s = ex.Message.ToString();
ve = null;
}
finally
{
cmd.Connection.Dispose();
cn.Close();
conn.closeConnection();
}
return ve;
}
