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); }