public Result_KQKN_KL Result_KQKN_KLDAO_SELECT_SoPKN(Result_KQKN_TD OBJ) { Result_KQKN_KL OBJKL = new Result_KQKN_KL(); DataTable dt = Sql.ExecuteDataTable("SAP", "SELECT * FROM [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_KL] " + " WHERE [SoPKN]='" + OBJ.SoPKN + "'", CommandType.Text); OBJKL.KL = dt.Rows[0]["KL"].ToString(); OBJKL.PassFail = dt.Rows[0]["PassFail"].ToString(); OBJKL.SoPKN = dt.Rows[0]["SoPKN"].ToString(); return(OBJKL); }
public void Result_KQKN_TD_INSERT(Result_KQKN_TD OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_TD] " + " ([SoPKN] " + " ,[KQKNTemplateID] " + " ,[SoPNK] " + " ,[QCDG] " + " ,[UoM1] " + " ,[UoM2] " + " ,[SLNhan] " + " ,[NgayNhan] " + " ,[Solo] " + " ,[NgaySX] " + " ,[HSD] " + " ,[NgayPT] " + " ,[TenNL] " + " ,[Lan] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "('" + OBJ.SoPKN + "'," + OBJ.KQKNTemplateID + ",'" + OBJ.SoPNK + "','" + OBJ.QCDG + "','" + OBJ.UoM1 + "','" + OBJ.UoM2 + "','" + OBJ.SLNhan + "',Convert(datetime,'" + OBJ.NgayNhan + "',103),'" + OBJ.Solo + "',Convert(datetime,'" + OBJ.NgaySX + "',103),Convert(datetime,'" + OBJ.HSD + "',103),Convert(datetime,'" + OBJ.NgayPT + "',103),'" + OBJ.TenNL + "'," + OBJ.Lan + ",Convert(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + //"','" + OBJ.Locked + "','False" + "')", CommandType.Text); }
public void Result_KQKN_TD_UPDATE(Result_KQKN_TD OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_TD] SET" + "[SoPKN] = '" + OBJ.SoPKN + "'" + ",[KQKNTemplateID] = " + OBJ.KQKNTemplateID + ",[SoPNK] = '" + OBJ.SoPNK + "'" + ",[QCDG] = '" + OBJ.QCDG + "'" + ",[UoM1] = '" + OBJ.UoM1 + "'" + ",[UoM2] = '" + OBJ.UoM2 + "'" + ",[SLNhan] = '" + OBJ.SLNhan + "'" + ",[NgayNhan] = Convert(datetime,''" + OBJ.NgayNhan + "',103)" + ",[Solo] = '" + OBJ.Solo + "'" + ",[NgaySX] = Convert(datetime,''" + OBJ.NgaySX + "',103)" + ",[HSD] = Convert(datetime,''" + OBJ.HSD + "',103)" + ",[NgayPT] = Convert(datetime,''" + OBJ.NgayPT + "'" + ",[TenNL] = '" + OBJ.TenNL + "'" + ",[Lan] = " + OBJ.Lan + ",[CreatedDate] = Convert(datetime,''" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + OBJ.CreatedBy + "' " + ",[Note] = N'" + OBJ.Note + "' " + //",[Locked] = '" + OBJ.Locked + "' " + ",[Locked] = 'False' " + " WHERE [ID]=" + OBJ.ID, CommandType.Text); }
public DataTable KQKN_Template_Details_Row_SELECT(Result_KQKN_TD OBJ) { return(Sql.ExecuteDataTable("SAP", "SELECT * FROM [SYNC_NUTRICIEL].[dbo].[tbl_KQKN_Template_Details] " + " WHERE [KQKNTemplateID] =" + OBJ.KQKNTemplateID, CommandType.Text)); }
public void Result_KQKN_TD_DELETE(Result_KQKN_TD OBJ) { Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_TD] " + " WHERE [ID]=" + OBJ.ID, CommandType.Text); }
public DataTable KQKN_Template_Details_Row_SELECT(Result_KQKN_TD OBJ) { return(DAO.KQKN_Template_Details_Row_SELECT(OBJ)); }
public void Result_KQKN_KLDAO_DELETE(Result_KQKN_TD OBJ) { Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_KL] " + " WHERE [SoPKN]='" + OBJ.SoPKN + "'", CommandType.Text); }