public void PO_Header_INSERT(PO_Header OBJ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PO_Header_LAB] " + " ([SoPO] " + " ,[VENDCode] " + " ,[VENDName] " + " ,[NgayLapPO] " + " ,[NgayGiaoHang] " + " ,[DiaChiGiaoHang] " + " ,[PaymentTerm] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Discount] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.SoPO + "',N'" + OBJ.VENDCode + "',N'" + OBJ.VENDName + "',CONVERT(datetime,'" + OBJ.NgayLapPO + "',103),CONVERT(datetime,'" + OBJ.NgayGiaoHang + "',103),N'" + OBJ.DiaChiGiaoHang + "','" + OBJ.PaymentTerm + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "',N'" + OBJ.Discount + "','" + OBJ.Locked + "')", CommandType.Text); }
public void Result_COA_TDDAO_INSERT(Result_COA_TD OBJ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_TD] " + " ([SoCOA] " + " ,[COATemplateID] " + " ,[WO] " + " ,[ManfBy] " + " ,[SmpDate] " + " ,[ExpDate] " + " ,[AnlDate] " + " ,[ManfDate] " + " ,[LB_MAT] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.SoCOA + "'," + OBJ.COATemplateID + ",N'" + OBJ.WO + "',N'" + OBJ.ManfBy + "',Convert(datetime,'" + OBJ.SmpDate + "',103),Convert(datetime,'" + OBJ.ExpDate + "',103),Convert(datetime,'" + OBJ.AnlDate + "',103),Convert(datetime,'" + OBJ.ManfDate + "',103),'" + OBJ.LB_MAT + "',Convert(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + //"','" + OBJ.Locked + "','False" + "')", CommandType.Text); }
public void PXN_DetailsDAO_INSERT(PXN_Details OBJ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PXN_Details] " + " ([SoPXN] " + " ,[CTXNID] " + " ,[SLMau] " + " ,[GhiChu] " + " ,[DonGia] " + " ,[ThanhTien] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.SoPXN + "'," + OBJ.CTXNID + ",N'" + OBJ.SLMau + "',N'" + OBJ.GhiChu + "',N'" + OBJ.DonGia + "',N'" + OBJ.ThanhTien + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void BATCH_INSERT(DataRow dr) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_BATCH]" + "([CD_OF]" + ",[Batch]" + ",[Start]" + ",[End]" + ",[ItemCode]" + ",[ItemDescription]" + ",[Formula]" + ",[Version]" + ",[PlannedQty]" + ",[ManufacturedQty]" + ",[Destination]" + ",[PrepareBatchNb]" + ",[TotalBatchNb])" + "VALUES " + "('" + dr["WO"].ToString() + "','" + dr["Batch"].ToString() + "','" + dr["Start"].ToString() + "','" + dr["End"].ToString() + "','" + dr["Code"].ToString() + "','" + dr["Product"].ToString() + "','" + dr["Formula"].ToString() + "','" + dr["Version"].ToString() + "'," + dr["Planned Qty"] + "," + dr["Manufactured Qty"] + ",'" + dr["Destination"].ToString() + "'," + dr["Prepare Batch Nb"] + "," + dr["Total Batch Nb"] + ")", CommandType.Text); // Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_OF_Detail]" + // "([CD_OF]" + // ",[FG_STATUS]" + // ",[DT_PREV]" + // ",[CD_DEPOT]" + // ",[CD_MAT]" + // ",[LB_MAT]" + // ",[QT_PREV]" + // ",[CD_UNIT]" + // ",[NO_ORDRE]" + // ",[CD_MAT1]" + // ",[QT_DOSE]" + // ",[CD_VER]" + // ",[LOSS_COMP])" + //"VALUES" + // "(" + dr["CD_OF"] + // ",'" + 1 + // "','" + DateTime.Parse(dr["DT_PREV"].ToString(), CultureInfo.CreateSpecificCulture("en-GB")) + // "','" + 891 + // "','" + dr["CD_MAT"].ToString() + // "','" + dr["LB_MAT"].ToString() + // "'," + dr["QT_PREV"] + // ",'" + dr["CD_UNIT"].ToString() + // "','" + 1000 + // "','" + dr["CD_MAT1"].ToString() + // "'," + dr["QT_DOSE"] + // ",'" + 89 + // "'," + dr["LOSS_COMP"]+ // ")", CommandType.Text); }
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 KLPKN_Update(int SoPKN, string KL, string PassFail) { Sql.ExecuteNonQuery("SAP", "UPDATE [dbo].[tbl_Result_KQKN_KL] " + "SET [PassFail] = '" + PassFail + "',[KL] = '" + KL + "' WHERE [dbo].[tbl_Result_KQKN_KL].[SoPKN]='" + SoPKN + "'", CommandType.Text); }
public void IBD_RESULT_Header_LABDAO_UPDATE(IBD_RESULT_Header_LAB OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_IBD_RESULT_Header_LAB] SET" + "[FilePath] = N'" + OBJ.FilePath + "'" + ",[FileName] = N'" + OBJ.FileName + "'" + ",[Date] = N'" + OBJ.Date + "'" + ",[Time] = N'" + OBJ.Time + "'" + ",[Case] = N'" + OBJ.Case + "'" + ",[KHMau_GiaoMau] = N'" + OBJ.KHMau_GiaoMau + "'" + ",[Count] = " + OBJ.Count + ",[GMean] = " + OBJ.GMean + ",[Mean] = " + OBJ.Mean + ",[SD] = " + OBJ.SD + ",[CV] = " + OBJ.CV + ",[Min] = " + OBJ.Min + ",[Max] = " + OBJ.Max + ",[Tech] = " + OBJ.Tech + ",[HUYETTHANHHOC_STD_VALUE_ID] = " + OBJ.HUYETTHANHHOC_STD_VALUE_ID + ",[CTXN_ID] = " + OBJ.CTXN_ID + ",[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 KHMau_CTXN_LABDAO_INSERT(KHMau_CTXN_RESULT_DETAILS_LAB OBJ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_KHMau_CTXN_RESULT_DETAILS_LAB] " + " ([KHMau_CTXN_ID] " + " ,[LineNo] " + " ,[MinVal] " + " ,[MaxVal] " + " ,[Custom1] " + " ,[Custom2] " + " ,[Custom3] " + " ,[Custom4] " + " ,[Custom5] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(" + OBJ.KHMau_CTXN_ID + "," + OBJ.LineNo + ",N'" + OBJ.MinVal + "',N'" + OBJ.MaxVal + "',N'" + OBJ.Custom1 + "',N'" + OBJ.Custom2 + "',N'" + OBJ.Custom3 + "',N'" + OBJ.Custom4 + "',N'" + OBJ.Custom5 + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void TDCOA_Insert(int SoCOA , int COATemplateID , string WO , string Manufacturedby //,string SLNhan , DateTime SmpDate //,string Solo , DateTime ExpDate , DateTime AnlDate , DateTime ManfDate , string LB_MAT ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [dbo].[tbl_TDCOA] " + "([SoCOA] " + ",[COATemplateID] " + ",[WO] " + ",[Manufacturedby] " + ",[SmpDate] " + ",[ExpDate] " + ",[AnlDate] " + ",[ManfDate] " + ",[LB_MAT]) " + "VALUES " + "('" + SoCOA + "'," + COATemplateID + ",'" + WO + "','" + Manufacturedby + "','" + SmpDate + "','" + ExpDate + "','" + AnlDate + "','" + ManfDate + "','" + LB_MAT + "')", CommandType.Text); }
public void PTU_Lines_INSERT(PTU_Lines OBJ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PTU_Lines_LAB] " + " ([SoPTU] " + " ,[NoiDung] " + " ,[TAMUNG_ID] " + " ,[SoHD] " + " ,[SoTien] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.SoPTU + "','" + OBJ.NoiDung + "'," + OBJ.TAMUNG_ID + ",N'" + OBJ.SoHD + "'," + OBJ.SoTien + ",CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); //XtraMessageBox.Show(CommandType.Text.ToString()); }
public void IBD_RESULT_Summary_LABDAO_INSERT(IBD_RESULT_Summary_LAB OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_IBD_RESULT_Summary_LAB] " + " ([Type] " + " ,[IBD_RESULT_Header_LAB_ID] " + " ,[AMean] " + " ,[GMean] " + " ,[SD] " + " ,[CV] " + " ,[Min] " + " ,[Max] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.Type + "'," + OBJ.IBD_RESULT_Header_LAB_ID + "," + OBJ.AMean + "," + OBJ.GMean + "," + OBJ.SD + "," + OBJ.CV + "," + OBJ.Min + "," + OBJ.Max + ",Convert(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void PTU_Header_INSERT(PTU_Header OBJ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PTU_Header_LAB] " + " ([SoPTU] " + " ,[VENDCode] " + " ,[VENDName] " + " ,[NgayLapPhieu] " + " ,[NgayTamUng] " + " ,[NoiDung] " + " ,[SoTienTamUng] " + " ,[SoTienDaTamUng] " + " ,[SoTienDeNghiThanhToan] " + " ,[PaymentTerm] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.SoPTU + "',N'" + OBJ.VENDCode + "',N'" + OBJ.VENDName + "',CONVERT(datetime,'" + OBJ.NgayLapPhieu + "',103),CONVERT(datetime,'" + OBJ.NgayTamUng + "',103),N'" + OBJ.NoiDung + "'," + OBJ.SoTienTamUng + "," + OBJ.SoTienDaTamUng + "," + OBJ.SoTienDeNghiThanhToan + ",'" + OBJ.PaymentTerm + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void PXN_ResultDAO_INSERT(PXN_Result OBJ) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_PXN_Result] " + " ([SoPXN] " + " ,[CTXNID] " + " ,[UnitTestCode] " + " ,[PXN_Details_ID] " + " ,[ResultLine] " + " ,[ResultValue] " + " ,[Positive] " + " ,[ResultUoM] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(N'" + OBJ.SoPXN + "'," + OBJ.CTXNID + ",N'" + OBJ.UnitTestCode + "'," + OBJ.PXN_Details_ID + ",N'" + OBJ.ResultLine + "',N'" + OBJ.ResultValue + "',N'" + OBJ.Positive + "',N'" + OBJ.ResultUoM + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
// // public void Appointments_INSERT(string DT_DEB, string DT_FIN, int ResourceId, string Description, string CustomField1, int label) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[Appointments]" + "([Type]" + ",[StartDate]" + ",[EndDate]" + ",[AllDay]" + ",[Status]" + ",[Label]" + ",[ResourceId]" + ",[Description]" + ",[PercentComplete]" + ",[CustomField1]" + ",[TimeZoneId]" + ")" + "VALUES" + "(" + 0 + //",'" + DateTime.Parse(DT_DEB, CultureInfo.CreateSpecificCulture("en-GB")) + //"','" + DateTime.Parse(DT_FIN, CultureInfo.CreateSpecificCulture("en-GB")) + ",CONVERT(datetime,'" + DT_DEB + "',103)" + ",CONVERT(datetime,'" + DT_FIN + "',103)" + "," + 0 + "," + 2 + "," + label + "," + ResourceId + ",N'" + Description + "'," + 100 + ",N'" + CustomField1 + "','SE Asia Standard Time')", CommandType.Text); }
public void COA_Template_DetailsDAO_INSERT(COA_Template_Details OBJ) { //XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString()); Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Details] " + " ([COATemplateID] " + " ,[HMKTID] " + " ,[Value] " + " ,[Tolerance] " + " ,[ValueVN] " + " ,[ToleranceVN] " + " ,[CreatedDate] " + " ,[CreatedBy] " + " ,[Note] " + " ,[Locked]) " + " VALUES " + "(" + OBJ.COATemplateID + "," + OBJ.HMKTID + ",N'" + OBJ.Value + "',N'" + OBJ.Tolerance + "',N'" + OBJ.ValueVN + "',N'" + OBJ.ToleranceVN + "',CONVERT(datetime,'" + DateTime.Now + "',103),N'" + OBJ.CreatedBy + "',N'" + OBJ.Note + "','" + OBJ.Locked + "')", CommandType.Text); }
public void KHMau_CTXN_LABDAO_UPDATE_GoiYCXuatHD(string KHMau, int CTXNID) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_KHMau_CTXN_LAB] SET " + "[GoiYCXuatHD] = 'True'" + //",[NgayTraKetQua] = CONVERT(datetime,'" + OBJ.NgayTraKetQua + "',103)" + ",[NgayGoiYCXuatHD] = CONVERT(datetime,'" + DateTime.Now + "',103)" + " WHERE [KHMau] ='" + KHMau + "' AND [CTXNID]=" + CTXNID, CommandType.Text); }
public void Item_UPDATE( string ItemCode ) { Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_Item] WHERE [ItemCode] = " + "'" + ItemCode + "'", 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 TC_Update(DataRow dr) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_TieuChuan]" + " SET [TC] ='" + dr["TC"].ToString() + "'" + ",[TCDG] = '" + dr["TC"].ToString() + "' " + "WHERE ID=" + int.Parse(dr["ID"].ToString()), CommandType.Text); //return dt; }
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 Appointments_UPDATE(string DT_DEB, string DT_FIN, int UniqueId) { Sql.ExecuteNonQuery("SAP", " UPDATE [SYNC_NUTRICIEL].[dbo].[Appointments] " + "SET " + //"[IdSort] = resources.IdSort "[StartDate] = CONVERT(datetime,'" + DT_DEB + "',103)" + ",[EndDate] = CONVERT(datetime,'" + DT_FIN + "',103)" + " WHERE [UniqueId]=" + UniqueId, CommandType.Text); }
public void Control_Update(DataRow dr) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_Control]" + " SET [Control] ='" + dr["Control"].ToString() + "'," + " [ControlVN] ='" + dr["ControlVN"].ToString() + "'," + " [Characteristic] ='" + dr["Characteristic"].ToString() + "'" + " WHERE ID=" + int.Parse(dr["ID"].ToString()), CommandType.Text); //return dt; }
public void COA_Template_Delete(int ID) { if (XtraMessageBox.Show("Do you want to delete the COA template no = '" + ID.ToString() + "'?", "Confirmation", MessageBoxButtons.YesNo) == DialogResult.Yes) { //e.Cancel = true; Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Details] WHERE COAID =" + ID, CommandType.Text); Sql.ExecuteNonQuery("SAP", "DELETE FROM [SYNC_NUTRICIEL].[dbo].[tbl_COA] WHERE ID =" + ID, CommandType.Text); XtraMessageBox.Show("Delete successfull "); } }
public void Control_Insert(DataRow dr) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_Control] " + "([Control],[ControlVN],[Characteristic]) " + "VALUES " + "('" + dr["Control"].ToString() + "','" + dr["ControlVN"].ToString() + "','" + dr["Characteristic"].ToString() + "'", CommandType.Text); //return dt; }
public void Result_KQKN_KQTTDAO_UPDATE_KQTT_VALUE(Result_KQKN_KQTT OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_KQTT] SET" + "[KQTT] = N'" + OBJ.KQTT + "'" + ",[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 TC_UPDATE(TieuChuan TC) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_TieuChuan] SET" + "[TC] = N'" + TC.TC + "'" + ",[TCDG] = N'" + TC.TCDG + "'" + ",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + TC.CreatedBy + "' " + ",[Note] = N'" + TC.Note + "' " + ",[Locked] = '" + TC.Locked + "' " + " WHERE [ID]=" + TC.ID, CommandType.Text); }
public void Result_COA_KQDAO_UPDATE_VALUE(Result_COA_KQ OBJ) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_KQ] SET" + "[Result] = N'" + OBJ.Result + "'" + ",[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 void KLPKN_Insert(int SoPKN, string KL, string PassFail, int Lan) { Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_Result_KQKN_KL]" + "([SoPKN] " + ",[KL] " + ",[PassFail]) " + "VALUES " + "(" + SoPKN + ",'" + KL + "','" + PassFail + "'," + Lan + ")", CommandType.Text); }
public void PPT_UPDATE(PhuongPhapThu PPT) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_PhuongPhapThu] SET" + "[PPT] = N'" + PPT.PPT + "'" + ",[PPTDG] = N'" + PPT.PPTDG + "'" + ",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + PPT.CreatedBy + "' " + ",[Note] = N'" + PPT.Note + "' " + ",[Locked] = '" + PPT.Locked + "' " + " WHERE [ID]=" + PPT.ID, CommandType.Text); }
public void LOAIMAU_UPDATE(LOAIMAU LOC) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_LoaiMau_LAB] SET" + "[MaLoaiMau] = N'" + LOC.MaLoaiMau + "'" + ",[TenLoaiMau] = N'" + LOC.TenLoaiMau + "'" + ",[CreatedDate] = Convert(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + LOC.CreatedBy + "' " + ",[Note] = N'" + LOC.Note + "' " + ",[Locked] = '" + LOC.Locked + "' " + " WHERE [ID]='" + LOC.ID + "'", CommandType.Text); }
public void CTPT_UPDATE(ChiTieuPhanTich CTPT) { Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_ChiTieuPhanTich] SET" + "[CTPT] = N'" + CTPT.CTPT + "'" + ",[CTPTDG] = N'" + CTPT.CTPTDG + "'" + ",[CreatedDate] = CONVERT(datetime,'" + DateTime.Now + "',103)" + ",[CreatedBy] = N'" + CTPT.CreatedBy + "' " + ",[Note] = N'" + CTPT.Note + "' " + ",[Locked] = '" + CTPT.Locked + "' " + " WHERE [ID]=" + CTPT.ID, CommandType.Text); }