public void Set4Controls() { //TD if (isAction == "Edit") { txtSoPKN.Text = OBJTD.SoPKN; } lkeKQKNTemplate.EditValue = OBJTD.KQKNTemplateID; //lkeSoPNK.Text = OBJTD.SoPNK; //lkeSoloPNK.Text = OBJTD.Solo; if (chkRM.CheckState == CheckState.Checked) { lkeSoPNK.Text = OBJTD.SoPNK; lkeSoloPNK.Text = OBJTD.Solo; } else if (chkFG.CheckState == CheckState.Checked) { txtSoMRA.Text = OBJTD.SoMRA; lkeWO.Text = OBJTD.SoPNK; txtSoloWO.Text = OBJTD.Solo; } txtQCDG.Text = OBJTD.QCDG; //txtQCDG.Text = OBJTD.QCDG.Substring(0, OBJTD.QCDG.LastIndexOf(" ")); cmbUoM1.Text = OBJTD.UoM1; cmbUoM2.Text = OBJTD.UoM2; txtSLNhan.Text = OBJTD.SLNhan; dteNgayNhan.Text = OBJTD.NgayNhan.ToString().Substring(0, 10); dteNgaySX.Text = OBJTD.NgaySX.ToString().Substring(0, 10); dteHSD.Text = OBJTD.HSD.ToString().Substring(0, 10); dteNgayPT.Text = OBJTD.NgayPT.ToString().Substring(0, 10); txtTenNL.Text = OBJTD.TenNL; txtLan.Text = OBJTD.Lan.ToString(); //KQTT gridControl1.DataSource = result_KQKN_Detail_RowTableAdapter.FillBySoPKN(sYNC_NUTRICIELDataSet.Result_KQKN_Detail_Row, OBJTD.SoPKN); //KL OBJKL = BUSKL.Result_KQKN_KLBUS_SELECT_SoPKN(OBJTD); txtKL.Text = OBJKL.KL; if (OBJKL.PassFail == "Failed") { chkFail.CheckState = CheckState.Checked; chkPass.CheckState = CheckState.Unchecked; } else { chkFail.CheckState = CheckState.Unchecked; chkPass.CheckState = CheckState.Checked; } ////PNK //lkeSoPNK.Properties.DataSource = RCB.F_RECEIPT_List(); //lkeSoPNK.Properties.SearchMode = DevExpress.XtraEditors.Controls.SearchMode.AutoComplete; //lkeSoPNK.Properties.DisplayMember = "ECH_RECEPS"; //lkeSoPNK.Properties.ValueMember = "ECH_RECEPS"; //lkeSoPNK.Properties.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup; }
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_KLDAO_UPDATE(Result_KQKN_KL OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_KL] SET" + "[SoPKN] = N'" + OBJ.SoPKN + "'" + ",[KL] = N'" + OBJ.KL + "'" + ",[CT] = N'" + OBJ.CT + "'" + ",[NguoiKT] = N'" + OBJ.NguoiKT + "'" + //",[NgayKT] = CONVERT(datetime,'" + OBJ.NgayKT + "',103)" + ",[NgayKT] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[TPKN] = N'" + OBJ.TPKN + "'" + //",[NgayPD] = CONVERT(datetime,'" + OBJ.NgayPD + "',103)" + ",[NgayPD] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[PassFail] = N'" + OBJ.PassFail + "'" + ",[Lan] = " + OBJ.Lan + ",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + OBJ.CreatedBy + "' " + ",[Note] = N'" + OBJ.Note + "' " + //",[Locked] = '" + OBJ.Locked + "' " + ",[Locked] = 'False' " + " WHERE [SoPKN]='" + OBJ.SoPKN + "'", CommandType.Text); }
public void Result_KQKN_KLDAO_INSERT(Result_KQKN_KL OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_KL] " + " ([SoPKN] " + " ,[KL] " + " ,[CT] " + " ,[NguoiKT] " + " ,[NgayKT] " + " ,[TPKN] " + " ,[NgayPD] " + " ,[PassFail] " + " ,[Lan] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.SoPKN + "',N'" + OBJ.KL + "',N'" + OBJ.CT + "',N'" + OBJ.NguoiKT + //"',CONVERT(datetime,'" + OBJ.NgayKT + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.TPKN + //"',CONVERT(datetime,'" + OBJ.NgayPD + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.PassFail + "'," + OBJ.Lan + ",CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + //"','" + OBJ.Locked + "',N'False" + "')", CommandType.Text); }