public void UpdateHistory(HistoryDto dto) { var strSql = "UPDATE history SET FileName = '" + dto.FileName + "',FileStatus='" + dto.FileStatus + "',FilePath='" + dto.FilePath + "' WHERE id='" + dto.Id + "'"; MysqlDBUtil.ExecuteSql(strSql); }
public void InsertHistory(HistoryDto dto) { var strSql = "INSERT INTO history(Id,FileName,FileStatus,FilePath) VALUES('" + dto.Id + "','" + dto.FileName + "','" + dto.FileStatus + "','" + dto.FilePath + "')"; MysqlDBUtil.ExecuteSql(strSql); }
public void InsertCode(CodeDto dto) { var strSql = "INSERT INTO code(Id,oldcode,newcode) VALUES('" + dto.Id + "','" + dto.OldCode + "','" + dto.NewCode + "')"; MysqlDBUtil.ExecuteSql(strSql); }