public void KQKN_Template_Details_Row_INSERT(KQKN_Template_Details_Row OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_KQKN_Template_Details] " + " ([KQKNTemplateID] " + " ,[STT] " + " ,[CTPTID] " + " ,[TCID] " + " ,[PPTID] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(" + OBJ.KQKNTemplateID + ",'" + OBJ.STT + "'," + OBJ.CTPTID + "," + OBJ.TCID + "," + OBJ.PPTID + ",CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void KQKN_Template_Details_Row_UPDATE(KQKN_Template_Details_Row OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_KQKN_Template_Details] SET" + "[KQKNTemplateID] = " + OBJ.KQKNTemplateID + ",[STT] = '" + OBJ.STT + "'" + ",[CTPTID] = " + OBJ.CTPTID + ",[TCID] = " + OBJ.TCID + ",[PPTID] = " + OBJ.PPTID + ",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + OBJ.CreatedBy + "' " + ",[Note] = N'" + OBJ.Note + "' " + ",[Locked] = '" + OBJ.Locked + "' " + " WHERE [ID]=" + OBJ.ID, CommandType.Text); }
public void KQKN_Template_Details_Row_DELETE(KQKN_Template_Details_Row OBJ) { Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_KQKN_Template_Details] " + " WHERE [ID]=" + OBJ.ID, CommandType.Text); }
public void KQKN_Template_Details_Row_INSERT(KQKN_Template_Details_Row OBJ) { DAO.KQKN_Template_Details_Row_INSERT(OBJ); }
public void KQKN_Template_Details_Row_DELETE(KQKN_Template_Details_Row OBJ) { DAO.KQKN_Template_Details_Row_DELETE(OBJ); }