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 Result_COA_KQDAO_INSERT(Result_COA_KQ OBJ)
{
Sql.ExecuteNonQuery("SAP", "INSERT INTO [SYNC_NUTRICIEL].[dbo].[tbl_Result_COA_KQ] " +
" ([SoCOA] " +
" ,[COA_Template_Details_ID] " +
" ,[Result] " +
",[CreatedDate] " +
" ,[CreatedBy] " +
" ,[Note] " +
" ,[Locked]) " +
" VALUES " +
"(N'" + OBJ.SoCOA +
"'," + OBJ.COA_Template_Details_ID +
",'" + OBJ.Result +
"',Convert(datetime,'" + DateTime.Now +
"',103),N'" + OBJ.CreatedBy +
"',N'" + OBJ.Note +
//"','" + OBJ.Locked +
"','False" +
"')", CommandType.Text);
}
