public static BIENNHANDON searchBienNhan(string sohoso)
{
try
{
GanMoiDataContext db = new GanMoiDataContext();
var data = from don in db.BIENNHANDONs where don.SHS == sohoso select don;
BIENNHANDON donkh = data.SingleOrDefault();
//if (donkh.HOSOCHA != null)
//{
// var hosocha = from don in db.DON_KHACHHANGs where don.SHS == donkh.HOSOCHA select don;
// return hosocha.SingleOrDefault();
//}
return(donkh);
}
catch (Exception ex)
{
}
return(null);
}
public frmTiepNhanKN(string db, string loai)
{
danhbo = db;
loaikh = loai;
InitializeComponent();
fLoad(loaikh);
if ("KH".Equals(loaikh))
{
TB_DULIEUKHACHHANG khachhang = DAL.KhachHang.CKhachHang.finByDanhBo(danhbo);
if (khachhang != null)
{
txtSoDanhBo.Text = khachhang.DANHBO;
txtTenKH.Text = khachhang.HOTEN;
txtsonha.Text = khachhang.SONHA;
txtDuong.Text = khachhang.TENDUONG;
txtDienThoai.Text = khachhang.DIENTHOAI;
cbQuan.SelectedValue = khachhang.QUAN;
cbPhuong.SelectedValue = khachhang.PHUONG;
}
}
else if ("GM".Equals(loaikh))
{
BIENNHANDON donkh = DAL.KhachHang.CGanMoi.searchBienNhan(danhbo);
if (donkh != null)
{
txtSoDanhBo.Text = donkh.SHS;
txtTenKH.Text = donkh.HOTEN;
txtsonha.Text = donkh.SONHA;
txtDuong.Text = donkh.DUONG;
txtDienThoai.Text = donkh.DIENTHOAI;
QUAN q = CHeThongDuong.finByMaQuan(donkh.QUAN);
cbQuan.Text = q.TENQUAN;
cbPhuong.Text = CHeThongDuong.finbyPhuong(q.MAQUAN, donkh.PHUONG).TENPHUONG;
}
}
}
