public void PO_Header_INSERT(PO_Header OBJ)
{
Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PO_Header_LAB] " +
" ([SoPO] " +
" ,[VENDCode] " +
" ,[VENDName] " +
" ,[NgayLapPO] " +
" ,[NgayGiaoHang] " +
" ,[DiaChiGiaoHang] " +
" ,[PaymentTerm] " +
" ,[CreatedDate] " +
" ,[CreatedBy] " +
" ,[Note] " +
" ,[Discount] " +
" ,[Locked]) " +
" VALUES " +
"(N'" + OBJ.SoPO +
"',N'" + OBJ.VENDCode +
"',N'" + OBJ.VENDName +
"',CONVERT(datetime,'" + OBJ.NgayLapPO +
"',103),CONVERT(datetime,'" + OBJ.NgayGiaoHang +
"',103),N'" + OBJ.DiaChiGiaoHang +
"','" + OBJ.PaymentTerm +
"',CONVERT(datetime,'" + DateTime.Now +
"',103),N'" + OBJ.CreatedBy +
"',N'" + OBJ.Note +
"',N'" + OBJ.Discount +
"','" + OBJ.Locked +
"')", CommandType.Text);
}
public void PO_Header_UPDATE(PO_Header OBJ)
{
Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PO_Header_LAB] SET " +
"[SoPO] = N'" + OBJ.SoPO + "'" +
"[VENDCode] = N'" + OBJ.VENDCode + "'" +
",[VENDName] = N'" + OBJ.VENDName + "'" +
",[NgayLapPO] = CONVERT(datetime,'" + OBJ.NgayLapPO + "',103)" +
",[NgayGiaoHang] = CONVERT(datetime,'" + OBJ.NgayGiaoHang + "',103)" +
",[DiaChiGiaoHang] = N'" + OBJ.DiaChiGiaoHang + "'" +
",[PaymentTerm] = N'" + OBJ.PaymentTerm + "'" +
",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" +
",[CreatedBy] = N'" + OBJ.CreatedBy + "' " +
",[Note] = N'" + OBJ.Note + "' " +
",[Discount] = N'" + OBJ.Discount + "' " +
",[Locked] = '" + OBJ.Locked + "' " +
" WHERE [ID] = " + OBJ.ID, CommandType.Text);
}
public void PO_Header_INSERT(PO_Header OBJ)
{
DAO.PO_Header_INSERT(OBJ);
}
public void PO_Header_UPDATE(PO_Header OBJ)
{
DAO.PO_Header_UPDATE(OBJ);
}