public void PRICELIST_DetailsDAO_DELETE(PRICELIST_Details OBJ)
{
// Cap nhat 2019-07-06
// Khong cho xoa ma chi set Locked = '1'
// De luu history price list detail
//Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_PriceList_Details_LAB] " +
//" WHERE [ID]=" + OBJ.ID, CommandType.Text);
Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PriceList_Details_LAB] SET" +
"[CreatedDate] = Convert(datetime,'" + DateTime.Now + "',103)" +
",[CreatedBy] = N'" + OBJ.CreatedBy + "' " +
",[Note] = N'" + OBJ.Note + "' " +
",[Locked] = '1' " +
" WHERE [ID]=" + OBJ.ID, CommandType.Text);
}
public void PRICELIST_DetailsDAO_UPDATE(PRICELIST_Details OBJ)
{
Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PriceList_Details_LAB] SET" +
"[CTXNID] = N'" + OBJ.CTXNID + "'" +
",[PLID] = " + OBJ.PLID +
",[UoM] = N'" + OBJ.UoM + "'" +
",[SoLuong] = N'" + OBJ.SoLuong + "'" +
",[DonGia] = N'" + OBJ.DonGia + "'" +
",[DonGiaMuaNgoai] = N'" + OBJ.DonGiaMuaNgoai + "'" +
",[DVMuaNgoaiCode] = N'" + OBJ.DVMuaNgoaiCode + "'" +
",[DVMuaNgoaiName] = N'" + OBJ.DVMuaNgoaiName + "'" +
",[Giam] = N'" + OBJ.Giam + "'" +
",[UoMGiam] = N'" + OBJ.UoMGiam + "'" +
",[VAT] = N'" + OBJ.VAT + "'" +
",[CreatedDate] = Convert(datetime,'" + DateTime.Now + "',103)" +
",[CreatedBy] = N'" + OBJ.CreatedBy + "' " +
",[Note] = N'" + OBJ.Note + "' " +
",[Locked] = '" + OBJ.Locked + "' " +
",[MuaNgoai] = '" + OBJ.MuaNgoai + "' " +
" WHERE [ID]=" + OBJ.ID, CommandType.Text);
}
//public void TC_Insert(TieuChuan tc)
//{
// Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_TieuChuan] " +
// "([TC] " +
// ",[TCDG]) " +
// "VALUES " +
// "('" + tc.TC +
// "','" + tc.TCDG + "'", CommandType.Text);
// //return dt;
//}
//public void PPT_Update(DataRow dr)
//{
// Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PhuongPhapThu]" +
// " SET [PPT] ='"+dr["PPT"].ToString() + "'"+
// ",[PPTDG] = '" + dr["PPTDG"].ToString() + "' " +
// "WHERE ID=" + int.Parse(dr["ID"].ToString()), CommandType.Text);
// //return dt;
//}
public void PRICELIST_DetailsDAO_INSERT(PRICELIST_Details OBJ)
{
//XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString());
Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PriceList_Details_LAB] " +
" ([CTXNID] " +
" ,[PLID] " +
" ,[UoM] " +
" ,[SoLuong] " +
" ,[DonGia] " +
" ,[DonGiaMuaNgoai] " +
" ,[DVMuaNgoaiCode] " +
" ,[DVMuaNgoaiName] " +
" ,[Giam] " +
" ,[UoMGiam] " +
" ,[VAT] " +
" ,[CreatedDate] " +
" ,[CreatedBy] " +
" ,[Note] " +
" ,[Locked] " +
" ,[MuaNgoai]) " +
" VALUES " +
"(N'" + OBJ.CTXNID +
"'," + OBJ.PLID +
",N'" + OBJ.UoM +
"',N'" + OBJ.SoLuong +
"',N'" + OBJ.DonGia +
"',N'" + OBJ.DonGiaMuaNgoai +
"',N'" + OBJ.DVMuaNgoaiCode +
"',N'" + OBJ.DVMuaNgoaiName +
"',N'" + OBJ.Giam +
"',N'" + OBJ.UoMGiam +
"',N'" + OBJ.VAT +
"',Convert(datetime,'" + DateTime.Now +
"',103),N'" + OBJ.CreatedBy +
"',N'" + OBJ.Note +
"','" + OBJ.Locked +
"','" + OBJ.MuaNgoai +
"')", CommandType.Text);
}
public void PRICELIST_DELETE(PRICELIST_Details OBJ)
{
DAO.PRICELIST_DetailsDAO_DELETE(OBJ);
}
public void PRICELIST_UPDATE(PRICELIST_Details OBJ)
{
DAO.PRICELIST_DetailsDAO_UPDATE(OBJ);
}
//public void TC_Insert(TieuChuan tc)
//{
// Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_TieuChuan] " +
// "([TC] " +
// ",[TCDG]) " +
// "VALUES " +
// "('" + tc.TC +
// "','" + tc.TCDG + "'", CommandType.Text);
// //return dt;
//}
//public void PPT_Update(DataRow dr)
//{
// Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PhuongPhapThu]" +
// " SET [PPT] ='"+dr["PPT"].ToString() + "'"+
// ",[PPTDG] = '" + dr["PPTDG"].ToString() + "' " +
// "WHERE ID=" + int.Parse(dr["ID"].ToString()), CommandType.Text);
// //return dt;
//}
public void PRICELIST_INSERT(PRICELIST_Details OBJ)
{
//XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString());
DAO.PRICELIST_DetailsDAO_INSERT(OBJ);
}