public override void LoadDataForm()
{
_iEntry = _iEntry ?? new eNhaCungCap();
_aEntry = clsFunction.GetItem <eNhaCungCap>("NhaCungCap/GetByID", _iEntry.KeyID);
SetControlValue();
}
public void InsertNhaCC(eNhaCungCap a)
{
NhaCungCap e = new NhaCungCap();
e.MaNhaCungCap = TaoMaNhaCC();
e.TenNhaCungCap = a.TenNCC;
e.Phone = a.Phone;
e.DiaChi = a.DiaChi;
e.NgayThanhLap = null;
db.NhaCungCaps.InsertOnSubmit(e);
db.SubmitChanges();
}
public override bool SaveData()
{
lstEdited.ToList().ForEach(x =>
{
eNhaCungCap NhaCungCap = (eNhaCungCap)rlokNhaCungCap.GetDataSourceRowByKeyValue(x.IDNhaCungCap) ?? new eNhaCungCap();
x.MaNhaCungCap = NhaCungCap.Ma;
x.TenNhaCungCap = NhaCungCap.Ten;
});
Tuple <bool, List <eSoDuDauKyNhaCungCap> > Res = clsFunction.Post("sodudaukynhacungcap", lstEdited.ToList());
return(Res.Item1);
}
public async override Task <bool> SaveData()
{
lstEdited.ToList().ForEach(x =>
{
eNhaCungCap NhaCungCap = (eNhaCungCap)rlokNhaCungCap.GetDataSourceRowByKeyValue(x.IDNhaCungCap) ?? new eNhaCungCap();
x.MaNhaCungCap = NhaCungCap.Ma;
x.TenNhaCungCap = NhaCungCap.Ten;
});
bool chk = false;
chk = await clsFunction <eSoDuDauKyNhaCungCap> .Instance.AddOrUpdate(lstEdited.ToList());
return(chk);
}
/// <summary>
/// Lấy danh sách nhà cung cấp có công nợ
/// </summary>
/// <returns>danh sách nhà cung cấp</returns>
public List <eNhaCungCap> GetListNhaCungCapNo()
{
List <eNhaCungCap> l = new List <eNhaCungCap>();
foreach (var cn in db.CongNoNCCs)
{
NhaCungCap ncc = cn.HoaDonNhaCungCap.NhaCungCap;
eNhaCungCap encc = new eNhaCungCap();
encc.MaNCC = ncc.MaNhaCungCap;
encc.TenNCC = ncc.TenNhaCungCap;
encc.DiaChi = ncc.DiaChi;
encc.Phone = ncc.Phone;
// entity thiếu field NgayThanhLap so với data base; -- cập nhập ngày 15/11/2016
l.Add(encc);
}
return(l);
}
public bool Update(eNhaCungCap ncc)
{
try
{
Tbl_NhaCungCap update = db.Tbl_NhaCungCaps.Single(tmp => tmp.maNCC == ncc.maNCC);
update.maNCC = ncc.maNCC;
update.tenNCC = ncc.tenNCC;
update.diaChi = ncc.diaChi;
update.sDT = ncc.sDT;
update.email = ncc.email;
db.SubmitChanges();
return(true);
}
catch { return(false); }
}
public int xoa1nhacungcap(eNhaCungCap ncc)
{
Tbl_NhaCungCap p = new Tbl_NhaCungCap();
p = db.Tbl_NhaCungCaps.Where(x => x.maNCC == ncc.maNCC).FirstOrDefault();
if (p != null)
{
return(0);
}
p.maNCC = ncc.maNCC;
p.tenNCC = ncc.tenNCC;
p.diaChi = ncc.diaChi;
p.sDT = ncc.sDT;
p.email = ncc.email;
db.Tbl_NhaCungCaps.DeleteOnSubmit(p);
db.SubmitChanges();
return(1);
}
public int themNCC(eNhaCungCap ncc)
{
var nccap = db.Tbl_NhaCungCaps.Where(x => x.maNCC == ncc.maNCC).FirstOrDefault();
if (nccap != null)
{
return(0);
}
Tbl_NhaCungCap p = new Tbl_NhaCungCap();
p.maNCC = ncc.maNCC;
p.tenNCC = ncc.tenNCC;
p.diaChi = ncc.diaChi;
p.sDT = ncc.sDT;
p.email = ncc.email;
db.Tbl_NhaCungCaps.InsertOnSubmit(p);
db.SubmitChanges();
return(1);
}
private void btnluuncc_Click(object sender, EventArgs e)
{
eNhaCungCap a = new eNhaCungCap();
a.maNCC = txtMaNCC.Text;
a.tenNCC = txtTenNCC.Text;
a.diaChi = txtAddress.Text;
a.sDT = txtphone.Text;
a.email = txtMail.Text;
int m = nccbll.themNCC(a);
if (m == 0)
{
MessageBox.Show("Trùng mã !", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1);
}
else if (m == 1)
{
MessageBox.Show("Thêm thành công !", "Thông báo!", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1);
}
}
private void btThemNhaCC_Click(object sender, EventArgs e)
{
loaddvg();
try
{
if (txtTenncc.Text == null || txtphone.Text == null || txtdiachi.Text == null)
{
MessageBox.Show("Các Thông Tin Băt Buộc Phải Nhập");
}
else
{
eNhaCungCap newncc = new eNhaCungCap();
newncc.TenNCC = txtTenncc.Text;
newncc.DiaChi = txtdiachi.Text;
newncc.Phone = Convert.ToInt32(txtphone.Text);
Sp.ThemNcc(newncc);
LoadCBNCC();
}
}
catch (Exception ex)
{
MessageBox.Show("Error: " + ex.Message.ToString());
}
}
public override bool SaveData()
{
DateTime time = DateTime.Now.ServerNow();
if (_aEntry.KeyID > 0)
{
_aEntry.NguoiCapNhat = clsGeneral.curPersonnel.KeyID;
_aEntry.MaNguoiCapNhat = clsGeneral.curPersonnel.Ma;
_aEntry.TenNguoiCapNhat = clsGeneral.curPersonnel.Ten;
_aEntry.NgayCapNhat = time;
_aEntry.TrangThai = 2;
}
else
{
_aEntry.NguoiTao = clsGeneral.curPersonnel.KeyID;
_aEntry.MaNguoiTao = clsGeneral.curPersonnel.Ma;
_aEntry.TenNguoiTao = clsGeneral.curPersonnel.Ten;
_aEntry.NgayTao = time;
_aEntry.TrangThai = 1;
eNhaCungCap nhaCungCap = (eNhaCungCap)slokNhaCungCap.Properties.GetRowByKeyValue(slokNhaCungCap.EditValue) ?? new eNhaCungCap();
_aEntry.IDNhaCungCap = nhaCungCap.KeyID;
_aEntry.MaNhaCungCap = nhaCungCap.Ma;
_aEntry.TenNhaCungCap = nhaCungCap.Ten;
}
_aEntry.Ma = txtMaPhieu.Text.Trim();
_aEntry.MaLoHang = txtSoLoHang.Text.Trim();
_aEntry.NgayNhap = dteNgayNhap.DateTime;
_aEntry.GhiChu = mmeGhiChu.Text.Trim();
_aEntry.SoLuong = spnSoLuong.Value;
_aEntry.ThanhTien = spnSoTien.Value;
_aEntry.TongTien = spnTongNo.Value;
_aEntry.NoCu = spnNoCu.Value;
_aEntry.ThanhToan = spnThanhToan.Value;
_aEntry.ConLai = spnConLai.Value;
_aEntry.eNhapHangNhaCungCapChiTiet.Clear();
foreach (eNhapHangNhaCungCapChiTiet item in lstDetail)
{
if (item.KeyID > 0)
{
item.NguoiCapNhat = clsGeneral.curPersonnel.KeyID;
item.MaNguoiCapNhat = clsGeneral.curPersonnel.Ma;
item.TenNguoiCapNhat = clsGeneral.curPersonnel.Ten;
item.NgayCapNhat = time;
item.TrangThai = 2;
}
else
{
item.NguoiTao = clsGeneral.curPersonnel.KeyID;
item.MaNguoiTao = clsGeneral.curPersonnel.Ma;
item.TenNguoiTao = clsGeneral.curPersonnel.Ten;
item.NgayTao = time;
item.TrangThai = 1;
}
eKho kho = (eKho)rlokKho.GetDataSourceRowByKeyValue(item.IDKho) ?? new eKho();
item.MaKho = kho.Ma;
item.TenKho = kho.Ten;
_aEntry.eNhapHangNhaCungCapChiTiet.Add(item);
}
Tuple <bool, eNhapHangNhaCungCap> Res = _aEntry.KeyID > 0 ?
clsFunction.Put("NhapHangNhaCungCap", _aEntry) :
clsFunction.Post("NhapHangNhaCungCap", _aEntry);
if (Res.Item1)
{
KeyID = Res.Item2.KeyID;
}
return(Res.Item1);
}
public void ThemNcc(eNhaCungCap e)
{
z.InsertNhaCC(e);
}
