public void MYCOTOXIN_RESULT_Lines_INSERT(MYCOTOXIN_RESULT_Lines OBJ)
{
//XtraMessageBox.Show("LOC.Locked : " + LOC.Locked.ToString());
Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Lines_LAB] " +
" ([MYCOTOCXIN_RESULT_Header_LAB_ID] " +
" ,[CTXN_ID] " +
" ,[Acronym] " +
" ,[OD] " +
" ,[KHMau] " +
" ,[B_Bo] " +
" ,[LogitB_Bo] " +
" ,[LogConc] " +
" ,[Conc_ng_ml] " +
" ,[Conc_ng_g] " +
" ,[Row] " +
" ,[Col] " +
" ,[HsoPhaLoang] " +
" ,[CreatedDate] " +
" ,[CreatedBy] " +
" ,[Note] " +
" ,[Locked]) " +
" VALUES " +
"(" + OBJ.MYCOTOCXIN_RESULT_Header_LAB_ID +
"," + OBJ.CTXN_ID +
",N'" + OBJ.Acronym +
"'," + OBJ.OD +
",N'" + OBJ.KHMau +
"'," + OBJ.B_Bo +
"," + OBJ.LogitB_Bo +
"," + OBJ.LogConc +
"," + OBJ.Conc_ng_ml +
"," + OBJ.Conc_ng_g +
",N'" + OBJ.Row +
"'," + OBJ.Col +
"," + OBJ.HsoPhaLoang +
",Convert(datetime,'" + DateTime.Now +
"',103),N'" + OBJ.CreatedBy +
"',N'" + OBJ.Note +
"','" + OBJ.Locked +
"')", CommandType.Text);
}
public void MYCOTOXIN_RESULT_Lines_UPDATE(MYCOTOXIN_RESULT_Lines OBJ)
{
Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_MYCOTOXIN_RESULT_Lines_LAB] SET" +
"[MYCOTOCXIN_RESULT_Header_LAB_ID] = " + OBJ.MYCOTOCXIN_RESULT_Header_LAB_ID +
",[CTXN_ID] =" + OBJ.CTXN_ID +
",[Acronym] =N'" + OBJ.Acronym + "'" +
",[OD] = " + OBJ.OD +
",[KHMau] = N'" + OBJ.KHMau + "'" +
",[B_Bo] = " + OBJ.B_Bo +
",[LogitB_Bo] = " + OBJ.LogitB_Bo +
",[LogConc] = " + OBJ.LogConc +
",[Conc_ng_ml] = " + OBJ.Conc_ng_ml +
",[Conc_ng_g] = " + OBJ.Conc_ng_g +
",[HsoPhaLoang] = " + OBJ.HsoPhaLoang +
",[Row] = N'" + OBJ.Row + "'" +
",[Col] = " + OBJ.Col +
",[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 MYCOTOXIN_RESULT_Lines_INSERT(MYCOTOXIN_RESULT_Lines OBJ)
{
DAO.MYCOTOXIN_RESULT_Lines_INSERT(OBJ);
}
public void MYCOTOXIN_RESULT_Lines_UPDATE(MYCOTOXIN_RESULT_Lines OBJ)
{
DAO.MYCOTOXIN_RESULT_Lines_UPDATE(OBJ);
}