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);
}