public void KHMau_CTXN_LABDAO_UPDATE_TraKetQua(KHMau_CTXN_LAB OBJ)
{
Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_KHMau_CTXN_LAB] SET " +
"[DaTraKetQua] = 'True'" +
//",[NgayTraKetQua] = CONVERT(datetime,'" + OBJ.NgayTraKetQua + "',103)" +
",[NgayTraKetQua] = CONVERT(datetime,'" + DateTime.Now + "',103)" +
" WHERE [ID] =" + OBJ.ID, CommandType.Text);
}
public void KHMau_CTXN_LABDAO_INSERT(KHMau_CTXN_LAB OBJ)
{
Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_KHMau_CTXN_LAB] " +
" ([KHMau] " +
//" ,[KHMau_GiaoMau] " +
" ,[KHMau_ID] " +
" ,[PriceList_Details_LAB_Id] " +
//_PriceList_Details_LAB_Id
" ,[CTXNID] " +
//" ,[NCTXNID] " +
" ,[DonGia] " +
" ,[DonGiaMuaNgoai] " +
" ,[Discount] " +
" ,[LoaiDiscount] " +
" ,[DonGiaSauDiscount] " +
" ,[ThanhTien] " +
//" ,[KetQua] " +
" ,[SoLuongDat] " +
" ,[SoLuongXN] " +
" ,[VAT] " +
" ,[CreatedDate] " +
" ,[CreatedBy] " +
" ,[Note] " +
" ,[Locked]) " +
" VALUES " +
"(N'" + OBJ.KHMau +
//"','" + OBJ.KHMau_GiaoMau +
"'," + OBJ.KHMau_ID +
"," + OBJ.PriceList_Details_LAB_Id +
"," + OBJ.CTXNID +
"," + OBJ.DonGia +
"," + OBJ.DonGiaMuaNgoai +
"," + OBJ.Discount +
",'" + OBJ.LoaiDiscount +
"'," + OBJ.DonGiaSauDiscount +
"," + OBJ.ThanhTien +
//"," + OBJ.KetQua +
",'" + OBJ.SoLuongDat +
"','" + OBJ.SoLuongXN +
"'," + OBJ.VAT +
//"," + OBJ.NCTXNID +
",CONVERT(datetime,'" + DateTime.Now +
"',103),N'" + OBJ.CreatedBy +
"',N'" + OBJ.Note +
"','" + OBJ.Locked +
"')", CommandType.Text);
}
public void KHMau_CTXN_LABDAO_UPDATE(KHMau_CTXN_LAB OBJ)
{
Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_KHMau_CTXN_LAB] SET " +
"[KHMau_ID] = " + OBJ.KHMau_ID +
",[PriceList_Details_LAB_Id] = " + OBJ.PriceList_Details_LAB_Id +
",[CTXNID] = " + OBJ.CTXNID +
",[DonGia] = " + OBJ.DonGia +
",[DonGiaMuaNgoai] = " + OBJ.DonGiaMuaNgoai +
",[Discount] = " + OBJ.Discount +
",[LoaiDiscount] = N'" + OBJ.LoaiDiscount + "'" +
",[DonGiaSauDiscount] = " + OBJ.DonGiaSauDiscount +
",[ThanhTien] = " + OBJ.ThanhTien +
",[SoLuongDat] = N'" + OBJ.SoLuongDat + "'" +
",[SoLuongXN] = N'" + OBJ.SoLuongXN + "'" +
",[VAT] = " + OBJ.VAT +
",[DaTraKetQua] = N'" + OBJ.DaTraKetQua + "'" +
",[NgayTraKetQua] = CONVERT(datetime,'" + OBJ.NgayTraKetQua + "',103)" +
//"[NCTXNID] = " + OBJ.NCTXNID +
",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" +
",[CreatedBy] = N'" + OBJ.CreatedBy + "' " +
",[Note] = N'" + OBJ.Note + "' " +
",[Locked] = N'" + OBJ.Locked + "' " +
" WHERE [ID] = " + OBJ.ID, CommandType.Text);
}
public void KHMau_CTXN_LABBUS_INSERT(KHMau_CTXN_LAB OBJ)
{
DAO.KHMau_CTXN_LABDAO_INSERT(OBJ);
}
public void KHMau_CTXN_LABBUS_UPDATE_TraKetQua(KHMau_CTXN_LAB OBJ)
{
DAO.KHMau_CTXN_LABDAO_UPDATE_TraKetQua(OBJ);
}
public void KHMau_CTXN_LABDAO_UPDATE(KHMau_CTXN_LAB OBJ)
{
DAO.KHMau_CTXN_LABDAO_UPDATE(OBJ);
}