public void COA_Template_DetailsDAO_UPDATE(COA_Template_Details OBJ)
{
Sql.ExecuteNonQuery("SAP", "UPDATE [SYNC_NUTRICIEL].[dbo].[tbl_COA_Template_Details] SET" +
"[COATemplateID] = " + OBJ.COATemplateID +
",[HMKTID] = " + OBJ.HMKTID +
",[Value] = N'" + OBJ.Value + "'" +
",[Tolerance] = N'" + OBJ.Tolerance + "'" +
",[ValueVN] = N'" + OBJ.ValueVN + "'" +
",[ToleranceVN] = N'" + OBJ.ToleranceVN + "'" +
",[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 COA_Template_DetailsDAO_INSERT(COA_Template_Details OBJ)
{
DAO.COA_Template_DetailsDAO_INSERT(OBJ);
}
public void COA_Template_DetailsDAO_DELETE(COA_Template_Details OBJ)
{
DAO.COA_Template_DetailsDAO_DELETE(OBJ);
}
